Incorrect Syntax Saving to an INT field using PHP::PDO

Question

0.00/5 (No votes)

See more:

Hello Everyone,

I have been battling with an issue for the past 24 hours.

Whenever I try to save into an int field.

This is what I did:

<br />
$query = "Update comments Set comment_authorized = 1 Where id = 4";<br />
$result = $pdo->prepare($query);<br />
$result->execute();<br />

This is the error I get:

SQLSTATE[42000]: Syntax error or access violation: 1064 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 'Set comment_authorized = 1 Where (id = 4)' at line 1

This same approach works well when inserting into non-INT columns. I just don't know why this is not working.

I have debugged this and couldn't just figure it out. After-all, this is a very simple basic statement.

Please help.

Posted 7-Dec-13 21:42pm

awedaonline

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

awedaonline · Accepted Answer · 2013-12-08T00:15:00

I eventually got this solved without using binding approach as provided above. Surprisingly, this is exactly what I did, I just gave the interpretation of my script's query in the question I posted.

However, I now sanitized each parameter value before using it in the query like this:

<br />
$id = Security::sanitize($id);<br />
$query = "UPDATE comments SET comment_authorized = 1 WHERE id = $id";<br />
...<br />

Incorrect Syntax Saving to an INT field using PHP::PDO

1 solution

Solution 1

Add your solution here

Preview 0

Incorrect Syntax Saving to an INT field using PHP::PDO

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us