$update_sql = "UPDATE guestbook SET reply = '$reply', replytime = $replytime WHERE id = $_POST[id]";報錯提示：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
7 回答
已采納
wcysky
TA貢獻2條經驗 獲得超0個贊
SQL語句改下?$update_sql = "UPDATE guestbook SET reply = '".$reply."', replytime = $replytime WHERE id = $_POST[id]";
單引號不解析php變量，被當做字符串了
mooc用戶18273
TA貢獻50條經驗 獲得超30個贊
$update_sql = "UPDATE guestbook SET reply = '{$reply}', replytime = {$replytime} WHERE id = {$_POST[id]}";
試一下
青年賣魚丸
TA貢獻1條經驗 獲得超0個贊
$update_sql?=?"UPDATE?guestbook?SET?reply?=?'"?.??mysql_real_escape_string($reply).?"',?replytime?=?'$replytime'?WHERE?id?=?{$_POST['id']}";
泥豆芽兒MT
TA貢獻2條經驗 獲得超0個贊
?$update_sql = "UPDATE guestbook SET reply = '$reply', replytime = $replytime WHERE id = $_POST[id]";
改成 ??$update_sql = "UPDATE guestbook SET??reply = “.$reply.", replytime = ".$replytime."WHERE id = ".$_POST[id]; 試試看
添加回答
舉報
0/150
提交
取消