📄 8-6.php

📁 《php程序设计》的配套源码《php程序设计》的配套源码《php程序设计》的配套源码《php程序设计》的配套源码

💻 PHP

字号:

<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>
<tr><td valign="top">
    <table>
    <tr><td class="picklist"><?= $pick_message ?></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>
<?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>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -