各位帮我看看这个例子错在哪里?
vvhot 2004-08-15 12:33:14 这个例子的作用是通过提交表单向数据库中存储数据:
<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 = $_POST['add_record'];
$Biz_Name = $_POST['Biz_Name'];
$Biz_Address = $_POST['Biz_Address'];
$Biz_City = $_POST['Biz_City'];
$Biz_Telephone = $_POST['Biz_Telephone'];
$Biz_URL = $_POST['Biz_URL'];
$Biz_Categories = $_POST['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>
产生错误提示:
Parse error: parse error, unexpected T_IF in F:\public\register2.php on line 30
这个所谓的unexpected T_IF是什么意思?