MySQL PDO Connection，如何检索插入的ID？ [重复]

Question

This question already has an answer here:

• Get last insert id after a prepared insert with PDO 3 answers

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.

</div>

Answer 1

You can use this.

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

FYI Link