Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners

DB2 PHP Generator online Help

Prev Return to chapter overview Next

GetLastInsertId

Returns the auto generated id used in the latest query (usually INSERT) on a table with an autoincrement column.

 

Signature:

function GetLastInsertId()

 

Example:

$sql = "INSERT INTO customer (first_name, last_name) VALUES ('John', 'Doe')";

$this->GetConnection()->ExecSQL($sql);

$lastInsertedCustomerId = $this->GetConnection()->GetLastInsertId();



Prev Return to chapter overview Next