Get last insert id after a prepared insert with PDO

by

From the Manual:

Returns the ID of the last inserted
row, or the last value from a sequence
object, depending on the underlying
driver. For example, PDO_PGSQL()
requires you to specify the name of a
sequence object for the name
parameter.

It should be something like:

return $db->lastInsertId('yourIdColumn');

[EDIT] Update link to doc

More Related Contents:

  1. Can I bind an array to an IN() condition in a PDO query?
  2. PHP – Using PDO with IN clause array
  3. PDO Prepared Inserts multiple rows in single query
  4. PDO prepared statement – what are colons in parameter names used for?
  5. pdo prepared statements with wildcards
  6. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  7. How do I use pdo’s prepared statement for order by and limit clauses?
  8. Insert multiple rows with PDO prepared statements
  9. Replacing mysql_* functions with PDO and prepared statements
  10. PHP PDO::bindParam() data types.. how does it work?
  11. Binding params for PDO statement inside a loop
  12. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  13. Calling stored procedure with Out parameter using PDO
  14. When *not* to use prepared statements?
  15. Which tokens can be parameterized in PDO prepared statements?
  16. How do I enable php to work with postgresql?
  17. Retrieve (or simulate) full query from PDO prepared statement
  18. Setting a connect timeout with PDO
  19. PDO error: SQLSTATE[HY000]: General error: 2031
  20. How to prevent PDO from interpreting a question mark as a placeholder?
  21. Use of PDO in classes [duplicate]
  22. Error while using PDO prepared statements and LIMIT in query [duplicate]
  23. PHP PDO and Mysql [closed]
  24. Best way to get result count before LIMIT was applied
  25. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  26. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  27. How to connect to mssql using pdo through PHP and Linux?
  28. using nulls in a mysqli prepared statement
  29. store_result() and get_result() in mysql returns false
  30. PHP PDO returning single row

Leave a Comment