P粉3156805652023-08-25 17:13:59
更改為:
$sth = "更新 rpacks SET rpacks_location = :location WHERE rpacks_id = :id";
P粉2486022982023-08-25 13:33:14
您的 update
查詢中存在錯誤,因為您使用了 insert
查詢語法。
以下是正確的查詢:
$sql = "UPDATE rpacks SET rpacks_location = :location WHERE rpacks_id = :id"; $stmt = $conn->prepare($sql); $stmt->execute([':location'=>$location, ':id'=>$id]);
參考: http://dev.mysql.com/doc/refman/5.0/ en/update.html