Take ID after database insertion / MySQL / PHP

Asked Feb 20 '17 at 16:59

Active Feb 20 '17 at 16:59

Viewed 33 times

I want to take the ID of a row just after its creation. Im using PDO.

Here is my code:

$insertNewIndividualConv = $bdd->prepare('INSERT INTO conv_individual(user1, user2, created) VALUES(:user1, :user2, :created)');
$insertNewIndividualConv -> execute(array(

    "user1"=>$user1verif,
    "user2"=>$user2verif,
    "created"=>date("F j, Y, g:i a")

     ));

//Extract ID of this new row here

Thank you.

asked Feb 20 '17 at 16:59

bdtry

Read docs: http://php.net/manual/en/pdo.lastinsertid.php – JustOnUnderMillions Feb 20 '17 at 16:59
Or http://stackoverflow.com/questions/10680943/pdo-get-the-last-id-inserted#10680965 – JustOnUnderMillions Feb 20 '17 at 17:01
Thank you @JustOnUnderMillions – bdtry Feb 20 '17 at 17:04

Take ID after database insertion / MySQL / PHP

0 Answers0