In this post we will see How to validate an HTML textbox for phone numbers using JavaScript. We will be using ASCII values of numbers for performing the validation on every key press. You may want to open …
What we are using here: MySQL database: –MySQL Username: root –No MySQL Password –Database Name: PracticeDatabase –Table Name: Contacts And 3 echo statements to print the HTML table. The code:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
<?php //Connect to the host. $con = mysql_connect('localhost','root','') or die(mysql_error()); //Connect to database. mysql_select_db('PracticeDatabase',$con) or die(mysql_error()); $result = mysql_query("select * from Contacts")or die(mysql_error()); //Print the table column names echo '<table border="1"> <tr> <th>Name</th> <th>Phone</th> </tr>'; //Print all the data from our database while($data = mysql_fetch_array($result)){ echo "<tr> <td>".$data['Name']."</td> <td>".$data['Phone']."</td> </tr> <br>"; } echo '</table> '; //End table tag. ?> |
Output: Have a better way of doing this? …
Ever tried to process html from within echo statement? Well here are a couple of ways to do this: Our html statement: <input type = “text” name = “textbox1″> The Wrong way: echo”<input type = “text” name = “textbox1″>” …