使用预准备语句更新会产生意外的T_VARIABLE错误[重复]

Question

This question already has an answer here:

• Reference - What does this error mean in PHP? 34 answers

$stmt = $db->prepare('UPDATE blog set entrytitle = ?,blogentry = ? where id = ?')
$stmt->bind_param("ssi", $entrytitle,$blogentry,$id);

The error is from the second line but I get the feeling it's being caused by the UPDATE query.

DB columns for the items are:

entrytitle is varchar(65) blogentry is longtext id is int(11)

</div>

Answer 1

You forgot a semi-colon on line 1...

$stmt = $db->prepare('UPDATE blog set entrytitle = ?,blogentry = ? where id = ?');
$stmt->bind_param("ssi", $entrytitle,$blogentry,$id);

Now the second $stmt is unexpected.