我在页面上有一个表单,该表单将记录id发布到我想要显示该记录的页面。形式是:
<form method="post" action="update.php">
<input type="hidden" name="sel_record" value="$id">
<input type="submit" name="update" value="Update this Order">
</form>
我已经测试了,看看$id是否得到正确的值,它确实得到了。当它发布到update.php时,它不返回任何值。什么好主意吗?下面是更新页面代码:
$sel_record = $_POST['sel_record'];
$result = mysql_query("SELECT * FROM `order` WHERE `id` = '$sel_record'") or die (mysql_error());
if (!$result) {
print "Something has gone wrong!";
} else {
while ($record = mysql_fetch_array($result)) {
$id = $record['id'];
$firstName = $record['firstName'];
$lastName = $record['lastName'];
$division = $record['division'];
$phone = $record['phone'];
$email = $record['email'];
$itemType = $record['itemType'];
$job = $record['jobDescription'];
$uploads = $record['file'];
$dateNeeded = $record['dateNeeded'];
$quantity = $record['quantity'];
$orderNumber = $record['orderNumber'];
}
}
您没有将php标签<?php ?>
放入html
<input type="hidden" name="sel_record" value="<?php echo $id; ?>">
您还应该尝试在while循环之外定义这些变量。
$id = '';
$result = mysql_query("SELECT * FROM `order` WHERE `id` = '$sel_record'") or die (mysql_error());
if (!$result) {
print "Something has gone wrong!";
} else {
while ($record = mysql_fetch_array($result)) {
$id = $record['id'];
}
}
这不是一个完整的例子,但是你可以理解。
您必须转义字符串…你可以去掉order和id周围的单引号。
试题:
$result = mysql_query("SELECT * FROM order WHERE id = '")。sel_record美元。")
如果$sel_record是一个String,否则去掉单引号:
…WHERE id = "。美元sel_record)
你也可以使用函数sprintf和mysql_real_escape_string来格式化:
$query = sprintf("SELECT * FROM order WHERE id = '%s'"),sel_record美元mysql_real_escape_string ());