MySQL PDO Connection, how do I retrieve the inserted ID?

Question

I have a PDO connection where I am inserting a new ROW in the databse:

$sql = UPDATE invoices SET ..."

Or

$sql = INSERT INTO invoices ..."

Then:

$stmt = self::getPDOConnection(self::DEFAULT_CONNECTION_NAME)->prepare($this->sql);
$stmt->execute($this->values);

And I would like to get the id of the updated, inserted element.

Thank you.

score 3 · Accepted Answer · answered Jul 07 '14 at 12:16

3

You can use this.

public string PDO::lastInsertId ([ string $name = NULL ] )

answered Jul 07 '14 at 12:16

Rohit Choudhary

Thank you, however, what if I have multiple users on the same project using different insertions, updates, I am sure that this will return the right id? – Milos Cuculovic Jul 07 '14 at 12:20
1

No, only the last inserted ID will be returned (this is easily tested). The only way to guarantee that you are returning the right ID to the right user is write a process or function that queries the database based on what that user just inserted into the table. http://www.php.net/manual/en/pdo.lastinsertid.php – Jay Blanchard Jul 07 '14 at 12:23

1 Answers1