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

0 vote252 views1 answer
Taxonomy_get_children drupal 8
PHP
1 vote220 views1 answer
Append single quote around variable in php string
PHP
9 votes241 views3 answers
Pass variable to blade laravel
PHP
0 vote227 views4 answers
Not found the requested url was not found on this server. apache/2.4.51 (win64) openssl/1.1.1l php/8.0.13 server at localhost port 80
PHP
3 votes218 views1 answer
Codeigniter check insert
PHP
0 vote239 views1 answer
Php pdo random multiple insert query
PHP
10 votes236 views2 answers
Laravel success message
PHP Laravel
61 votes239 views6 answers
Php delete element from array
PHP
34 votes225 views6 answers
Random number generator in php
PHP
0 vote195 views1 answer
Laravel translation parameters
PHP