What is equivalent of mysql_insert_id(); using prepared statement?

Question

I have used prepared statement to insert an order into an orders table but now I want to insert the order items into the order items table based on the last ID inserted in the orders table:

if (isset($_POST['process'])) {

    $order_name = $_POST['order_name'];
    //create initial order
    $stmt = $conn2->prepare("INSERT INTO orders (order_name) VALUES (?)");
    $stmt->bind_param('s', $order_name);
    $stmt->execute();

    //this gets the most recent auto incremented ID from the database - this is the order_id we have just created
    $order_id = mysql_insert_id();

    //loop over all of our order items and add to the database
    foreach ($_SESSION['order'] as $item) {

What is equivalent to mysql_insert_id(); using prepared statement?

You mean, what is the equivalent of `mysql_insert_id` in the PDO library? Something wrong with [the documentation](http://www.php.net/manual/en/pdo.lastinsertid.php)? — Lightness Races in Orbit, Mar 17 '12 at 21:17

score 24 · Accepted Answer · answered Mar 17 '12 at 21:10

24

If you're using PDO, it's PDO::lastInsertId(). So if your database handle is called $link:

$order_id = $link->lastInsertId();

If you're using MySQLi, it's mysqli::$insert_id or mysqli_insert_id():

$order_id = $link->insert_id;

answered Mar 17 '12 at 21:10

Ry-

218,210
55
464
476

but im using prepared statements with mysqli not PDO – user1227124 Mar 17 '12 at 21:10
@user1227124: Then it's [`mysqli::$insert_id`](http://php.net/manual/en/mysqli.insert-id.php) or `mysqli_insert_id()`. – Ry- Mar 17 '12 at 21:12
1

@user1227124: Next time, please just look it up in the documentation. We expect prior research in SO questions. – Lightness Races in Orbit Mar 17 '12 at 21:19

score 3 · Answer 2 · answered Mar 17 '12 at 21:11

3

You can try $stmt->insert_id to get inserted id

answered Mar 17 '12 at 21:11

safarov

7,793
2
36
52

What is equivalent of mysql_insert_id(); using prepared statement?

2 Answers2

Linked