Php pdo last insert id

$stmt = $db->prepare("...");
$stmt->execute();
$id = $db->lastInsertId();

Source: stackoverflow.com

Pdo last id

Beware of lastInsertId() when working with transactions in mysql. The following code returns 0 instead of the insert id.



<?php

try {

    $dbh = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');



    $stmt = $dbh->prepare("INSERT INTO test (name, email) VALUES(?,?)");



    try {

        $dbh->beginTransaction();

        $tmt->execute( array('user', 'user@example.com'));

        $dbh->commit();

        print $dbh->lastInsertId();

    } catch(PDOExecption $e) {

        $dbh->rollback();

        print "Error!: " . $e->getMessage() . "</br>";

    }

} catch( PDOExecption $e ) {

    print "Error!: " . $e->getMessage() . "</br>";

}

?>



When no exception is thrown, lastInsertId returns 0. However, if lastInsertId is called before calling commit, the right id is returned.

Source: php.net

Similar codes

46 votes278 views6 answers
Add column to migration laravel
PHP Laravel
1 vote176 views3 answers
Create new laravel project with specific version
PHP
0 vote173 views1 answer
Php pdo sql server connect
PHP
0 vote194 views1 answer
Laravel breeze rquire
PHP Laravel
0 vote278 views1 answer
Init curl
PHP
11 votes188 views3 answers
Require password confirm laravel
PHP
46 votes264 views6 answers
Add new column in existing table in laravel migration
PHP Laravel
33 votes202 views6 answers
How to run a specific migration in laravel
PHP Laravel
15 votes220 views4 answers
Php Error Reporting
PHP
1 vote197 views1 answer
Invalid datetime format laravel
PHP