MySQL Last Inserted ID
Monday, 18. September 2006, 00:16:55
In some cases, you will need to retrieve the last inserted ID which was inserted into your database using PHP specifically when you are using an 'auto_increment' parameter for that field. Obviously there is a common way of doing this, but there is also a built in function which will help you to achieve the same result with less code.
The common way :
The easy way :
A useful snippet if you aren't familiar with the 'mysql_insert_id()' function. This will save you some coding and time if you've been using other common, longer ways in the past.
The common way :
$query = "INSERT INTO table (id, value) VALUES ('', 'value')";
mysql_query($query) or die(mysql_error());
$id = mysql_result((mysql_query("SELECT * FROM table WHERE value = 'value'")), 0, 'id');
echo "The last inserted ID was :" . $id;
The easy way :
$query = "INSERT INTO table (id, value) VALUES ('', 'value')";
mysql_query($query) or die(mysql_error());
echo "The last inserted ID was :" . mysql_insert_id();
A useful snippet if you aren't familiar with the 'mysql_insert_id()' function. This will save you some coding and time if you've been using other common, longer ways in the past.
(0%)
WIDGETIZE
Skulled # 25. September 2006, 21:20
Run "SHOW TABLE STATUS [FROM dbname] [LIKE tblname]" query through a mysql_query(), and the resulting result resource has the insert id for the key with auto_increment set in the table under the value "Auto_increment"
It's a more eloborate version than the straightforward mysql_insert_id() function. But it works.
Antonie Potgieter # 25. September 2006, 21:35
I think that when you are going to focus on optimization and speed, your method will most likely be a bit faster than having PHP do the work for you.
Thanks for the comment.
Brian Armsrong # 20. June 2007, 18:06