UPDATE using prepared statements gives unexpected T_VARIABLE error

Question

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

score 2 · Accepted Answer · answered Dec 19 '13 at 16:40

2

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.

answered Dec 19 '13 at 16:40

L00_Cyph3r

score 1 · Answer 2 · answered Dec 19 '13 at 16:40

1

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

answered Dec 19 '13 at 16:40

Matteo Tassinari

Right! Fixed, thanks. – Matteo Tassinari Dec 19 '13 at 16:42
:) I knew it was something simple. THanks folks! – user3115806 Dec 19 '13 at 16:42
You're welcome :) If the answer helped you, feel free to upvote and/or accept it! – Matteo Tassinari Dec 19 '13 at 16:43
I can't upvote/accept. I think I'm too much of a noob... :/ (I have negative 3 for my question) maybe it was formatted poorly? – user3115806 Dec 19 '13 at 16:49
@user3115806 - you should be able to accept after (I think) 15 minutes have passed; you can't upvote until you have 15 reputation. – andrewsi Dec 19 '13 at 16:53

2 Answers2