How can PDO::execute return true when no insert happened?

Question

I'm using PDO::prepare() to prepare an INSERT statement. PDO::execute() returns true, and $dbh->lastInsertId() always has the next id, but no row is actually inserted!

What could be causing this?

Your Common Sense · Accepted Answer · 2013-02-21 07:25:40Z

if $dbh->lastInsertId() returns id from this very insert (i.e. no other inserts were fired), the row was apparently inserted. Just double-check your table. I mean it.

Ja͢ck · Accepted Answer · 2013-02-21 07:25:47Z

0

I'm going to stab in the dark here and wager that you didn't run $dbh->commit() afterwards. Without the commit it will roll back the changes once your script ends or the connection is closed.

2 Comments

Rob Johansen Over a year ago

I thought perhaps this was the case, since the second insert has a foreign-key constraint that depends on the success of the first insert. I've added a $dbh->commit() after the first insert, and it does show up correctly, but the second insert still throws a foreign-key constraint error. Any ideas why?

Ja͢ck Over a year ago

@AlienBishop In that case you would need to give more details.

Collectives™ on Stack Overflow

How can PDO::execute return true when no insert happened?

2 Answers 2

Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Related