Discover Auto Increment ID After MySQL Insert With PHP

9th March 2008 - 2 minutes read time

Inserting a value into a database with an auto incrementing field is quite common. Once you insert the new row you would expect that you need to do another query to get the newly created ID.

Another option is to use the mysql_insert_id() function to retrieve the ID created by the last insert statement.

// insert
$sql = 'INSERT INTO table(colum1, colum2) VALUES(1, 2);';
mysql_query($sql);
 
// get new id
$id = mysql_insert_id();

The $id variable will now contain your most recently inserted ID.

PHP

Comments

Permalink
with this code we can find next record id (that is mean if multi user working by db, this number is not what thing that we want)

esmailzadeh (Mon, 05/03/2010 - 13:37)

Add new comment

The content of this field is kept private and will not be shown publicly.

Related Content

PHP:CSI - Date Is Less Than One Month Ago

27th February 2022

Working with logic surrounding dates can sometimes be difficult and it's fairly common to come across really subtle date and time based bugs.

I was recently shown a bug in a PHP application that looks like it should be working at face value, but doesn't actually produce the correct result.

Read more.

An Introduction To Object Reflection In PHP

30th January 2022

Reflection is used to gather more information about code during the runtime of the program. This allows code to inspect itself and to make small modifications, which is useful in a variety of situations.

Read more.

Fibers In PHP 8.1

18th December 2021

PHP 8.1 comes with a few new additions to the language, and one that I have seen get the most attention is fibers. This is a feature that allows PHP code to be executed in a concurrent thread, with the ability to pause and resume that code at will.

Read more.