PDO lastInsertId() always return 0

by

Other than a bug in php/PDO or your framework, there are two possibilities. Either lastInsertId() is called on a different MySQL connection than the insert, or you are generating the id in your application/framework and inserting it, rather than letting auto_increment generate it for you. Which column in the table is the primary key/auto_increment? Is that column included in $attributes in your create() function?

You can test PDO to make sure that part is working correctly with this code (in a new file):

// Replace the database connection information, username and password with your own.
$conn = new PDO('mysql:dbname=test;host=127.0.0.1', 'user', 'password');

$conn->exec('CREATE TABLE testIncrement ' .
            '(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50))');
$sth = $conn->prepare('INSERT INTO testIncrement (name) VALUES (:name)');
$sth->execute([':name' => 'foo']);
var_dump($conn->lastInsertId());
$conn->exec('DROP TABLE testIncrement');

When I ran this script, the output was

string(1) "1"

More Related Contents:

  1. What is the difference between bindParam and bindValue?
  2. How do I create a PDO parameterized query with a LIKE statement?
  3. PDOException SQLSTATE[HY000] [2002] No such file or directory
  4. PHP PDO: charset, set names?
  5. How to get numeric types from MySQL using PDO?
  6. Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
  7. PDO prepared statement – what are colons in parameter names used for?
  8. php pdo: get the columns name of a table
  9. Use bound parameter multiple times
  10. What is the difference between MySQL, MySQLi and PDO? [closed]
  11. Why is PDO better for escaping MySQL queries/querystrings than mysql_real_escape_string?
  12. PDO bindParam vs. execute
  13. how safe are PDO prepared statements
  14. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  15. PDO error message? [duplicate]
  16. PHP PDO – Num Rows
  17. php pdo prepare repetitive variables
  18. How to solve General error: 2006 MySQL server has gone away
  19. Replacing mysql_* functions with PDO and prepared statements
  20. How to make PDO run SET NAMES utf8 each time I connect, In ZendFramework
  21. How do I sanitize input with PDO?
  22. Calling stored procedure with Out parameter using PDO
  23. When *not* to use prepared statements?
  24. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  25. Setting a connect timeout with PDO
  26. What is the best way to insert multiple rows in PHP PDO MYSQL?
  27. PDO MySQL: Insert multiple rows in one query
  28. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  29. PDO LIMIT and OFFSET [duplicate]
  30. PDO::rowCount VS COUNT(*)

Leave a Comment