 | Read data from mysql in php |
| <?php
| | 1:$con = mysql_connect("localhost","peter","abc123");
| | 2:if (!$con)
| | 3: {
| | 4: die('Could not connect: ' . mysql_error());
| | 5: }
| | 6:
| | 7:mysql_select_db("my_db", $con);
| | 8:
| | 9:$result = mysql_query("SELECT * FROM Persons");
| | 10:
| | 11:echo "<table border='1'>
| | 12:<tr>
| | 13:<th>Firstname</th>
| | 14:<th>Lastname</th>
| | 15:</tr>";
| | 16:
| | 17:while($row = mysql_fetch_array($result))
| | 18: {
| | 19: echo "<tr>";
| | 20: echo "<td>" . $row['FirstName'] . "</td>";
| | 21: echo "<td>" . $row['LastName'] . "</td>";
| | 22: echo "</tr>";
| | 23: }
| | 24:echo "</table>";
| | 25:
| | 26:mysql_close($con);
| | 27:?>
| | 28: |
|