failed to insert into table (php mysql)

Question

im writing a app that checks user status im using mysql and i want to have a table name check

this is my code :

mysqli_report(MYSQLI_REPORT_ALL);
$stmt = $mysqli->prepare("INSERT INTO check VALUES (?,?)");

i get error :

Uncaught exception 'mysqli_sql_exception' with message '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 'check VALUES (?,?)' at line 1'

what am i doing wrong ?

Barmar · Accepted Answer · 2014-01-13 07:32:06Z

1

your table name (check)

is a reserved word in MySQL.

Surround it in backticks like this:

$mysqli->prepare("INSERT INTO `check` VALUES (?,?)");

edited Jan 13, 2014 at 7:32

Barmar

789k57 gold badges555 silver badges669 bronze badges

answered Jan 13, 2014 at 7:31

Nimrod007

9,9518 gold badges50 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shankar Narayana Damodaran · Accepted Answer · 2014-01-13 07:31:01Z

1

check is a reserved word in MySQL . Enclose it in backticks !

Like this

mysqli_report(MYSQLI_REPORT_ALL);
$stmt = $mysqli->prepare("INSERT INTO `check` VALUES (?,?)");

answered Jan 13, 2014 at 7:31

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

Collectives™ on Stack Overflow

failed to insert into table (php mysql)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related