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

$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>

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.

There is a missing semicolon, replace

$stmt = $db->prepare('UPDATE blog set entrytitle = ?,blogentry = ? where id = ?') // <-- missing semicolon here!

with

$stmt = $db->prepare('UPDATE blog set entrytitle = ?,blogentry = ? where id = ?'); // <-- now fixed

but let me say, this is simple standard debugging...