What is the difference between mysqli_insert_id and mysql_insert_id in PHP?

The main difference between mysqli_insert_id and mysql_insert_id in PHP is that mysqli_insert_id is used with the improved MySQLi extension for PHP, while mysql_insert_id is used with the deprecated MySQL extension. It is recommended to use mysqli_insert_id as the MySQLi extension is more secure and offers better performance. 

// Using mysqli_insert_id
$mysqli = new mysqli("localhost", "username", "password", "database");
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// Perform an insert query
$mysqli->query("INSERT INTO table_name (column_name) VALUES ('value')");

// Get the last inserted ID
$last_id = $mysqli->insert_id;

// Close the connection
$mysqli->close();

Keywords

mysqli_insert_id mysql_insert_id PHP difference functions

Related Questions