How does the choice between MySQLi and PDO affect the handling of autoincrement IDs in PHP?

When using MySQLi, autoincrement IDs can be retrieved after inserting a new record by calling the `insert_id` method on the database connection object. However, with PDO, you need to use the `lastInsertId` method on the PDO object itself to get the autoincrement ID. 

// Using MySQLi
$mysqli = new mysqli("localhost", "username", "password", "database");
$mysqli->query("INSERT INTO table_name (column_name) VALUES ('value')");
$new_id = $mysqli->insert_id;

// Using PDO
$pdo = new PDO("mysql:host=localhost;dbname=database", "username", "password");
$pdo->query("INSERT INTO table_name (column_name) VALUES ('value')");
$new_id = $pdo->lastInsertId();

Keywords

MySQLi PDO autoincrement IDs handling PHP

Related Questions