How do I get the last inserted ID of a MySQL table in PHP?

by

If you’re using PDO, use PDO::lastInsertId.

If you’re using Mysqli, use mysqli::$insert_id.

If you’re still using Mysql:

Please, don’t use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi – this article will help you decide which. If you choose PDO, here is a good tutorial.

But if you have to, use mysql_insert_id.

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  3. The requested URL was not found on this server.
  4. SQL injections in ADOdb and general website security
  5. Save PHP array to MySQL?
  6. PHP PDO prepared statement — MySQL LIKE query
  7. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  8. How can I use mysqli_fetch_array() twice?
  9. Best practice multi language website
  10. Executing multiple SQL queries in one statement with PHP
  11. Prevent InnoDB auto increment ON DUPLICATE KEY
  12. mysql_num_rows() expects parameter 1 to be resource, boolean given in [duplicate]
  13. Easy way to export a SQL table without access to the server or phpMyADMIN
  14. How to know if MySQLnd is the active driver?
  15. using nulls in a mysqli prepared statement
  16. How can I count the numbers of rows that a MySQL query returned?
  17. MySQL: Add sequence column based on another field
  18. How to run the PHP script at scheduled time
  19. How to handle error for duplicate entries?
  20. How to handle PDO exceptions [duplicate]
  21. MySql PHP select count of distinct values from comma separated data (tags)
  22. mysql_insert_id() returns 0
  23. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  24. Change name of Laravel’s created_at and updated_at
  25. How do I get database column names in Laravel?
  26. PDO and MySQL Fulltext searches
  27. How to avoid “Using temporary” in many-to-many queries?
  28. Difference between mysql_fetch_array and mysql_fetch_row?
  29. 500 Internal Server Error?
  30. Aggregated query without GROUP BY

Leave a Comment