PDO get the last ID inserted

by

That’s because that’s an SQL function, not PHP. You can use PDO::lastInsertId().

Like:

$stmt = $db->prepare("...");
$stmt->execute();
$id = $db->lastInsertId();

If you want to do it with SQL instead of the PDO API, you would do it like a normal select query:

$stmt = $db->query("SELECT LAST_INSERT_ID()");
$lastId = $stmt->fetchColumn();

More Related Contents:

  1. PDOException SQLSTATE[HY000] [2002] No such file or directory
  2. PDO mysql: How to know if insert was successful
  3. MySQL check if a table exists without throwing an exception
  4. Fetching single row, single column with PDO
  5. Replacing mysql_* functions with PDO and prepared statements
  6. PDO::PARAM for type decimal?
  7. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  8. PHP PDO and Mysql [closed]
  9. Using PHP data in MySQL [closed]
  10. How to properly set up a PDO connection
  11. PHP PDO prepared statements
  12. Automated or regular backup of mysql data
  13. “Invalid parameter number: parameter was not defined” Inserting data
  14. PDO binding values for MySQL IN statement [duplicate]
  15. implement LIKE query in PDO
  16. PHP PDO prepared statement — MySQL LIKE query
  17. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  18. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  19. How to connect to mssql using pdo through PHP and Linux?
  20. How do I loop through a MySQL query via PDO in PHP?
  21. IP address storing in MySQL database using PHP [duplicate]
  22. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  23. Use of PDO in classes [duplicate]
  24. How to handle PDO exceptions [duplicate]
  25. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  26. PDO and MySQL Fulltext searches
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  29. MySQL ORDER BY rand(), name ASC
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment