php man page for mysqli_insert_id

MYSQLI_INSERT_ID(3)							 1						       MYSQLI_INSERT_ID(3)

mysqli::$insert_id - Returns the auto generated id used in the last query

       Object oriented style

SYNOPSIS
       mixed$mysqli->insert_id ()

DESCRIPTION
       Procedural style
       mixed mysqli_insert_id (mysqli  $link)

	The  mysqli_insert_id(3) function returns the ID generated by a query on a table with a column having the AUTO_INCREMENT attribute. If the
       last query wasn't an INSERT or UPDATE statement or if the modified table does not have a column with  the  AUTO_INCREMENT  attribute,  this
       function will return zero.

       Note

	       Performing  an  INSERT  or  UPDATE  statement  using  the  LAST_INSERT_ID()  function  will  also  modify the value returned by the
	      mysqli_insert_id(3) function.

PARAMETERS
	      o $
		link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)

RETURN VALUES
	The value of the AUTO_INCREMENT field that was updated by the previous query. Returns zero if there was no previous query on  the  connec-
       tion or if the query did not update an AUTO_INCREMENT value.

       Note

	       If the number is greater than maximal int value, mysqli_insert_id(3) will return a string.

EXAMPLES
       Example #1

	      $mysqli->insert_id example

	      Object oriented style

	      <?php
	      $mysqli = new mysqli("localhost", "my_user", "my_password", "world");

	      /* check connection */
	      if (mysqli_connect_errno()) {
		  printf("Connect failed: %s
", mysqli_connect_error());
		  exit();
	      }

	      $mysqli->query("CREATE TABLE myCity LIKE City");

	      $query = "INSERT INTO myCity VALUES (NULL, 'Stuttgart', 'DEU', 'Stuttgart', 617000)";
	      $mysqli->query($query);

	      printf ("New Record has id %d.
", $mysqli->insert_id);

	      /* drop table */
	      $mysqli->query("DROP TABLE myCity");

	      /* close connection */
	      $mysqli->close();
	      ?>

	      Procedural style

	      <?php
	      $link = mysqli_connect("localhost", "my_user", "my_password", "world");

	      /* check connection */
	      if (mysqli_connect_errno()) {
		  printf("Connect failed: %s
", mysqli_connect_error());
		  exit();
	      }

	      mysqli_query($link, "CREATE TABLE myCity LIKE City");

	      $query = "INSERT INTO myCity VALUES (NULL, 'Stuttgart', 'DEU', 'Stuttgart', 617000)";
	      mysqli_query($link, $query);

	      printf ("New Record has id %d.
", mysqli_insert_id($link));

	      /* drop table */
	      mysqli_query($link, "DROP TABLE myCity");

	      /* close connection */
	      mysqli_close($link);
	      ?>

	      The above examples will output:

	      New Record has id 1.

PHP Documentation Group 												       MYSQLI_INSERT_ID(3)