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

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.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)