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 = "[email protected]";
$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? — Pekka
– Pekka, Commented Oct 27, 2012 at 10:02
Please stick your prepare and execute inside a try { } catch (PDOException $e) { echo $e; } block, and tell us the results. — Daedalus
– Daedalus, Commented Oct 27, 2012 at 10:03

juergen d · Accepted Answer · 2016-08-10 21:50:08Z

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, 2016 at 21:50

answered Oct 27, 2012 at 10:04

juergen d

205k40 gold badges305 silver badges377 bronze badges

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

2 Comments

Bastiaan ten Klooster Over a year ago

Thanks that saved me a lot of time! Forgetting that often.. Will accept when I can, have a good day!

juergen d Over a year ago

I use the MySQL workbench for designing my queries. It highlights reserved words and you can see the problem from the beginning.

user1105787 · Accepted Answer · 2012-10-27 10:15:55Z

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, 2012 at 10:15

user1105787

Comments

Man Programmer · Accepted Answer · 2012-10-27 10:05:50Z

0

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

add this lines to get any pdo query error

answered Oct 27, 2012 at 10:05

Man Programmer

5,3662 gold badges24 silver badges21 bronze badges

Collectives™ on Stack Overflow

Why doesn't my query execute?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related