PHP/mysqli , how to know about newly inserted ID

Question

I have a simple table , contains a primary key which has an Auto Increment index.

When I do insertion with mysqli , is there any chance to know the last inserted value of the Auto Increment column ?

Note:

There might be multiple people trying to insert simultaneously

wont [this](http://www.php.net/manual/en/mysqli.insert-id.php) work? — Milan Halada, May 23 '12 at 12:35
Is [mysqli_insert_id function](http://php.net/manual/en/mysqli.insert-id.php) doesn't work??? — bitoshi.n, May 23 '12 at 12:36
Note that the simultaneous thing is covered with `mysqli_insert_id()` because it returns the last inserted id for the current session. — Marcus Adams, May 23 '12 at 12:46

score 10 · Accepted Answer · edited Jul 18 '13 at 14:41

10

edited Jul 18 '13 at 14:41

Rok Jarc

answered May 23 '12 at 12:35

bcmcfc

score 5 · Answer 2 · answered May 23 '12 at 12:56

5

You can use the insert_id value (not a method call) from the database object :)

$id = $db->insert_id;

answered May 23 '12 at 12:56

Antony Carthy

score 2 · Answer 3 · answered Dec 21 '12 at 00:30

2

Correction to last post, procedural style takes a parameter "$link", where $link is the identifier returned by mysqli_connect() or mysqli_init():

$last_id = mysqli_insert_id($link);

answered Dec 21 '12 at 00:30

Mason Barge

score 1 · Answer 4 · answered May 23 '12 at 12:35

1

answered May 23 '12 at 12:35

verisimilitude

score 1 · Answer 5 · answered May 23 '12 at 12:37

1

   $last_id = $link->insert_id;

Where $link is MySQLi resource.

Or:

$last_id = mysqli_insert_id();

answered May 23 '12 at 12:37

Vishal

5 Answers5