📄 8-5.php

📁 《php程序设计》的配套源码《php程序设计》的配套源码《php程序设计》的配套源码《php程序设计》的配套源码
💻 PHP
字号:
<html>
<head>
<title>
<?php
  $doc_title = 'Business Registration';
  echo "$doc_title\n";
?>
</title>
</head>
<body>
<h1>
<?= $doc_title ?>
</h1>

<?php
  require_once('db_login.php');

  // fetch query parameters
  $add_record = $_REQUEST['add_record'];
  $Biz_Name = $_REQUEST['Biz_Name'];
  $Biz_Address = $_REQUEST['Biz_Address'];
  $Biz_City = $_REQUEST['Biz_City'];
  $Biz_Telephone = $_REQUEST['Biz_Telephone'];
  $Biz_URL = $_REQUEST['Biz_URL'];
  $Biz_Categories = $_REQUEST['Biz_Categories'];


  $pick_message = 'Click on one, or control-click on<BR>multiple categories:'

  if ($add_record == 1) {
      $pick_message = 'Selected category values<BR>are highlighted:';
      $sql  = 'INSERT INTO businesses (name, address, city, telephone, url)';
      $sql .= ' VALUES (?, ?, ?, ?, ?)';
      $params = array($Biz_Name, $Biz_Address, $Biz_City,
                      $Biz_Telephone, $Biz_URL);
      $query = $db->prepare($sql);
      if (DB::isError($query)) die($query->getMessage());
      $resp = $db->execute($query, $params);
      if (DB::isError($resp)) die($resp->getMessage());
      $resp = $db->commit();
      if (DB::isError($resp)) die($resp->getMessage());
      echo '<P CLASS="message">Record inserted as shown below.</P>';
      $biz_id = $db->getOne('SELECT max(business_id) FROM businesses');
  }

?>

<form method="POST" action="register2.php">
<table>
<tr><td class="picklist"><?= $pick_message ?>
    <p>
    <select name="Biz_Categories[]" size="4" multiple>
    <?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());
          if ($add_record == 1){
              $selected = false;
              if (in_array($row[1], $Biz_Categories)) {
                  $sql  = 'INSERT INTO biz_categories';
                  $sql .= ' (business_id, category_id)';
                  $sql .= ' VALUES (?, ?)';
                  $params = array($biz_id, $row[0]);
                  $query = $db->prepare($sql);
                  if (DB::isError($query)) die($query->getMessage());
                  $resp = $db->execute($query, $params);
                  if (DB::isError($resp)) die($resp->getMessage());
                  $resp = $db->commit();
                  if (DB::isError($resp)) die($resp->getMessage());
                  print("<option selected>$row[1]</option>\n");
                  $selected = true;
              }
              if ($selected == false) {
                  echo "<option>$row[1]</option>\n";
              }
          } else {
              echo "<option>$row[1]</option>\n";
          }
      }
    ?>

    </select>
    </td>
    <td class="picklist">
        <table>
        <tr><td class="FormLabel">Business Name:</td>
            <td><input type="text" name="Biz_Name" size="40" maxlength="255"
                value="<?= $Biz_Name ?>"</td>
        </tr>
        <tr><td class="FormLabel">Address:</td>
         <td><input type="text" name="Biz_Address" size="40" maxlength="255"
                value="<?= $Biz_Address ?>"</td>
        </tr>
        <tr><td class="FormLabel">City:</td>
            <td><input type="text" name="Biz_City" size="40" maxlength="128
"                value="<?= $Biz_City ?>"</td>
        </tr>
        <tr><td class="FormLabel">Telephone:</td>
        <td><input type="text" name="Biz_Telephone" size="40" maxlength="64"
                value="<?= $Biz_Telephone ?>"</td>
        </tr>
        <tr><td class="FormLabel">URL:</TD>
            <td><input type="text" name="Biz_URL" size="40" maxlength="255"
                value="<?= $Biz_URL ?>"</td>
        </tr>
        </table>
    </td>
</tr>
</table>
<p>
<input type="hidden" name="add_record" value="1">

<?php
  //  Display the submit button on new forms, link to a fresh registration
  //  page on confirmations.
  if ($add_record == 1){
      echo '<p><a href="register2.php">Add Another Business</a></p>';
  } else {
      echo '<input type="submit" name="submit" value="Add Business">';
  }
?>

</p>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -