$stmt = $pdo->prepare("INSERT INTO orders (customer_id, amount) VALUES (?, ?)"); $stmt->execute([$customer_id, $amount]); $order_id = $pdo->lastInsertId(); echo "New order ID: $order_id";
$stmt = $mysqli->prepare("INSERT INTO users (name, email) VALUES (?, ?)"); $stmt->bind_param("ss", $name, $email); $stmt->execute(); $user_id = $mysqli->insert_id; echo "New user ID: $user_id";The package/library used in example 1 is PDO and in example 2 is mysqli.