last_insert_id.php

<?php
try {
 // connection information
 $pdo = new PDO('mysql:host=localhost;dbname=some_db_name;charset=utf8', 'some_user_name', 'some_password');
 $pdo - ->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 // begin a transaction
 $pdo->beginTransaction();
 // Assume the 'user input' values have been sanitized and validated.
 $first_name = 'Josh';
 $last_name = 'Otwell';
 // prepare insert statement
 $insert_sql = "INSERT INTO `user_details`(`first_name`, `last_name`)
 VALUES(:first_name, :last_name)";
 $insert_stmt = $pdo->prepare($insert_sql);
 $insert_stmt->bindValue(':first_name', $first_name);
 $insert_stmt->bindValue(':last_name', $last_name);
 // try the insert, if something goes wrong, rollback.
 if ($insert_stmt->execute() === FALSE) {
 $pdo->rollback();
 echo 'Unable to insert data';
 } else {
 $last_insert_id = $pdo->lastInsertId();
 echo 'Last Insert ID: '.$last_insert_id;
 $pdo->commit();
 }
} catch (PDOException $e) {
 echo 'Database Error '.$e->getMessage().' in '.$e->getFile().
 ': '.$e->getLine();
}