Why doesn't my query execute?

Question

I have a query that get's fed these variables (but from a POST form):

$username = "John";
$email = "johnsmith@mail.com";
$passwordEnc = "9d4e1e23bd5b727046a9e3b4b7db57bd8d6ee684";
$activated = 0;
$activationKey = "5753a498f025464d72e088a9d5d6e872592d5f91";

The query is as follows:

$stmt = $dbu->prepare("INSERT INTO users (username, email, password, activated, key) VALUES (?, ?, ?, ?, ?)");
$stmt->execute(array($username, $email, $passwordEnc, $activated, $activationKey));

There is no error, but the entry isn't added to my table named 'users'.

possible duplicate of [How to squeeze error message out of PDO?](http://stackoverflow.com/questions/3726505/how-to-squeeze-error-message-out-of-pdo) — Pekka, Oct 27 '12 at 10:02
Please stick your prepare and execute inside a `try { } catch (PDOException $e) { echo $e; }` block, and tell us the results. — Daedalus, Oct 27 '12 at 10:03

juergen d · Accepted Answer · 2016-08-10T21:50:08.610

6

You need to escape reserved words in MySQL like password and key with backticks

INSERT INTO users (username, email, `password`, activated, `key`) VALUES ...

edited Aug 10 '16 at 21:50

answered Oct 27 '12 at 10:04

juergen d

201,996
37
293
362

Thanks that saved me a lot of time! Forgetting that often.. Will accept when I can, have a good day! – Bastiaan ten Klooster Oct 27 '12 at 10:05
I use the MySQL workbench for designing my queries. It highlights reserved words and you can see the problem from the beginning. – juergen d Oct 27 '12 at 10:06

score 2 · Answer 2 · answered Oct 27 '12 at 10:15

2

I checked http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html, just to save you some time 'Key' is the only word reserved on there.

answered Oct 27 '12 at 10:15

score 0 · Answer 3 · answered Oct 27 '12 at 10:05

0

$dbu->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbu->errorInfo();

add this lines to get any pdo query error

answered Oct 27 '12 at 10:05

Man Programmer

5,300
2
21
21

Why doesn't my query execute?

3 Answers3