PHP uses POD to access MySQL database, how to return the last inserted record of the self-increment number ID

PHP uses POD to access MySQL database, how to return the last inserted record of the self-increment number ID
PHP uses POD to access MySQL database, how to return the last inserted record of the self-increment number ID

Share to: more

------Solution--------------------
String Pdo::lastinsertid ([string $name = NULL])
------Solution--------------------
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 (). "
";
}
} catch (Pdoexecption $e) {
Print "error!:". $e->getmessage (). "
";
}
?>

