Nov 14th 08 Posted by Robert Dicks in Computing, MySQL, php

Getting The Last Auto Increment Field With PHP

On many occasions you need to find the value of the last auto increment field inserted into a MySQL table. For example within my Content Management System if someone creates a new web page and saves it the user is taken back to edit this new page. In order to do this I must retrieve the value of the last auto increment field inserted into the database.

To do this I use the php mysql_insert_id(); function.

You can add this value to a variable by using the following code:-

$MyValue = mysql_insert_id();

So with this variable you could select an item from a database eg:

$MyQuery = "SELECT * FROM MyTable WHERE UniqueField = $MyValue";

Of course you should always check that $MyValue is numeric for security so we don’t break the query. For this we could use the php intval function.

intval($MyValue);

Related posts:

1. Resetting MySQL Auto Increment Field
2. Connecting to MySQL with PHP
3. Basic PHP – Assigning Values to Variables
4. Detecting Mobile Devices with PHP
5. Database Connections Outside of Webroot