| Name | Address | City | State | Zip |
| Abigail Hoffman | 413 5th St. | San Bernardino | CA | 96543 |
| Horace Greely | 54334 Pancake Drive | Bangor | ME | 01234 |
Here is sample code to display the above table. You must replace host_name, user_name, password and database_name
with your own host and database information.
<?php
$connect = mysql_connect("host_name","user_name","password");
if (!$connect)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("database_name", $connect);
$result = mysql_query("SELECT * FROM patrons");
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$name = $row['name'];
$address = stripslashes($row['address']);
$city = stripslashes($row['city']);
$state = stripslashes($row['state']);
$zip = $row['zip'];
$display_block .=
"<tr>
<td>$name</td>
<td>$address</td>
<td>$city</td>
<td>$state</td>
<td>$zip</td>
</tr>";
}
?>
<HTML>
<HEAD>
<TITLE>Library Patrons</TITLE>
</HEAD>
<BODY>
<H1>Library Patrons</H1>
<table width="100%" border="1">
<tr>
<b><td>Name</td></b>
<b><td>Address</td></b>
<b><td>City</td></b>
<b><td>State</td></b>
<b><td>Zip</td></b>
</tr>
<? echo "$display_block"; ?>
</table>
</BODY>
</HTML>
<?php
mysql_free_result($result);
?>