如何获取表的自动增量主键

Question

I have a small MySQL database of sellers where there is a table, in which each seller has an auto-increment primary key (and there is not any other unique key attribute). Now I want to retrieve each seller data from the php script

// Nothing wrong with this code
    $stmt = $this->conn->prepare("SELECT * FROM seller WHERE id= ? LIMIT 1");
    $stmt->bind_param("i", $ud);
    $stmt->execute();
    $result = $stmt->get_result();

But.. to retrieve data with this query, I need to have the primary key ( i.e. autoincrement id of the seller ). How would I know what is the primary key of the record inserted?

Answer 1

insert_id attribute of the prepared statement saved me. Now just after my insert statement I can get the last inserted primary key of the table-

$stmt->execute();
$sid = $stmt->insert_id;

This is equivalent to the LAST_INSERT_ID() function in mysql. Make sure you use this in the same session, just after insertion of the table row. Otherwise, it returns a null set.