• Product Information
  • About
  • News
  • Screenshots
  • Video tutorials
  • Changelog
• Support Information
  • Documentation
  • Resources
  • FAQ
  • Samples
  • Support
  • Upgrade policy
  • Feature matrix
• Download
• Purchase

Download Buy

DB2 PHP Generator online Help

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();