PHP MySQL Get Last Inserted ID

PHP MySQL Get Last Inserted ID

In PHP MySQL Get Last Inserted ID in table with an AUTO_INCREMENT primary key, you may want to get the ID of the newly inserted record. PHP provides methods to retrieve it.

Using `mysqli_insert_id()` (Procedural)

<?php
$conn = mysqli_connect("localhost", "root", "", "test_db");

if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

// Insert data
$sql = "INSERT INTO users (name, email, age) VALUES ('Vipul', 'vipul@example.com', 25)";
if (mysqli_query($conn, $sql)) {
$last_id = mysqli_insert_id($conn);
echo "New record created successfully. Last inserted ID is: " . $last_id;
} else {
echo "Error: " . mysqli_error($conn);
}

mysqli_close($conn);
?>

<?php

$conn = mysqli_connect("localhost", "root", "", "test_db");

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

// Insert data

$sql = "INSERT INTO users (name, email, age) VALUES ('Vipul', 'vipul@example.com', 25)";

if (mysqli_query($conn, $sql)) {

$last_id = mysqli_insert_id($conn);

echo "New record created successfully. Last inserted ID is: " . $last_id;

} else {

echo "Error: " . mysqli_error($conn);

}

mysqli_close($conn);

mysqli_insert_id($conn) returns the last inserted auto-increment ID for the connection.

Using `mysqli` Object-Oriented

<?php
$conn = new mysqli("localhost", "root", "", "test_db");

if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO users (name, email, age) VALUES ('Amit', 'amit@example.com', 28)";

if ($conn->query($sql) === TRUE) {
$last_id = $conn->insert_id;
echo "New record created successfully. Last inserted ID is: " . $last_id;
} else {
echo "Error: " . $conn->error;
}

$conn->close();
?>

<?php

$conn = new mysqli("localhost", "root", "", "test_db");

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

$sql = "INSERT INTO users (name, email, age) VALUES ('Amit', 'amit@example.com', 28)";

if ($conn->query($sql) === TRUE) {

$last_id = $conn->insert_id;

echo "New record created successfully. Last inserted ID is: " . $last_id;

} else {

echo "Error: " . $conn->error;

}

$conn->close();

$conn->insert_id is the object-oriented way of retrieving the last ID.

Using PDO

<?php
try {
$conn = new PDO("mysql:host=localhost;dbname=test_db", "root", "");
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$stmt = $conn->prepare("INSERT INTO users (name, email, age) VALUES (:name, :email, :age)");
$stmt->bindParam(':name', $name);
$stmt->bindParam(':email', $email);
$stmt->bindParam(':age', $age);

$name = "Ravi";
$email = "ravi@example.com";
$age = 30;

$stmt->execute();

// Get last inserted ID
$last_id = $conn->lastInsertId();
echo "New record created successfully. Last inserted ID is: " . $last_id;

} catch(PDOException $e) {
echo "Error: " . $e->getMessage();
}

$conn = null; // Close connection
?>

<?php

try {

$conn = new PDO("mysql:host=localhost;dbname=test_db", "root", "");

$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$stmt = $conn->prepare("INSERT INTO users (name, email, age) VALUES (:name, :email, :age)");

$stmt->bindParam(':name', $name);

$stmt->bindParam(':email', $email);

$stmt->bindParam(':age', $age);

$name = "Ravi";

$email = "ravi@example.com";

$age = 30;

$stmt->execute();

// Get last inserted ID

$last_id = $conn->lastInsertId();

echo "New record created successfully. Last inserted ID is: " . $last_id;

} catch(PDOException $e) {

echo "Error: " . $e->getMessage();

}

$conn = null; // Close connection

$conn->lastInsertId() works with PDO to return the last auto-increment ID.

Key Points

Use mysqli_insert_id() (procedural), $conn->insert_id (OO), or $conn->lastInsertId() (PDO).
The last inserted ID is per connection, so it won’t interfere with other users inserting records simultaneously.
Useful for relational data, e.g., inserting into one table and using the ID in another table.

PHP MySQL Get Last Inserted ID