ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:insert_id

This is an old revision of the document!


insert_Id

Syntax
mixed insert_Id()

Description

The function insert_Id() returns the last auto-increment number of any table, generated by an insert on a table with an auto-increment column. If no such insertion has occurred or the database does not support the operation, the function returns false.

It is important to remember that there is only a single storage instance for the number, and if one insert statement with an auto-increment number succeeds another, the insert_id value for the second statement will overwrite the value of the first, so retrieve the value of the first before executing the second.

Usage

/*
 * Connection assumed
 */
 
/*
 * Insert into table with auto-increment column, current highest value 100
 */
$db->Execute('INSERT INTO monkeys (type) value "arctic"');
$lastId = $db->insert_Id();
print $lastId;
/*
 * returns value 101
 */
v5/reference/connection/insert_id.1437761512.txt.gz · Last modified: (external edit)