Databases: Finishing a Listing Service - Displaying the Database (
Page 3 of 5 )
Example 8-6 shows a page that displays the information in the database. The links on the left side of the page are created from the categories table and link back to the script, adding a category ID. The category ID forms the basis for a query on the businesses table and the biz_categories table.
Example 8-6. Business listing page
<html>
<head>
<title>
<?php
$doc_title = 'Business Listings';
echo "$doc_title\n";
?>
</title>
</head>
<body>
<h1>
<?= $doc_title ?>
</h1>
<?php
// establish the database connection
require_once('db_login.php');
$pick_message = 'Click on a category to find business listings:';
?>
<table border=0>
<tr><td valign="top">
<table border=5>
<tr><td class="picklist"><strong><?= $pick_message ?></strong></td></tr>
<p>
<?php
// build the scrolling pick list for the categories
$sql = "SELECT * FROM categories";
$result = $db->query($sql);
if (DB::isError($result)) die($result->getMessage());
while ($row = $result->fetchRow()){
if (DB::isError($row)) die($row->getMessage());
echo '<tr><td class="formlabel">';
echo "<a href="$PHP_SELF?cat_id=$row[0]">";
echo "$row[1]</a></td></tr>\n";
}
?>
</table>
</td>
<td valign="top">
<table border=1>
<?php
if ($cat_id) {
$sql = "SELECT * FROM businesses b, biz_categories bc where";
$sql .= " category_id = '$cat_id'";
$sql .= " and b.business_id = bc.business_id";
$result = $db->query($sql);
if (DB::isError($result)) die($result->getMessage());
while ($row = $result->fetchRow()){
if (DB::isError($row)) die($row->getMessage());
if ($color == 1) {
$bg_shade = 'dark';
$color = 0;
} else {
$bg_shade = 'light';
$color = 1;
}
echo "<tr>\n";
for($i = 0; $i < count($row); $i++) {
echo "<td class="$bg_shade">$row[$i]</td>\n";
}
echo "</tr>\n";
}
}
?>
</table>
</td></tr>
</table>
</body>
</html>
The business listings page is illustrated in Figure 8-7.
Figure 8-7. Business Listings page
