CODEWITHSUNDEEP
phpsqlpdoauto-increment
user2461031
user2461031

Reputation: 513

Get the last auto increment id

lets say my code is:

$req = $bdd->prepare('INSERT INTO test(name, surname) VALUES(:name, :surname)');
$req->execute(array(
    'name' => $name,
    'surname' => $surname));

And my table test has an auto increment field named id

What is the best way to get the 'id' corresponding to $req?

Upvotes: 0

Views: 2613

Answers (1)

user1846065
user1846065

Reputation:

PDO has a method for this:

$id = $pdo->lastInsertId();

or in your case:

$id = $bdd->lastInsertId();

You can find more information about the lastInsertID method here.

Upvotes: 3

Related Questions