Mysql Insert Id Function in PHP

In PHP mysql_insert_id() function is used for those table which contains Auto-generated field. When function is executed then last query in a row returns the id value. Function returns zero value if there were no auto-generated field.

How mysql_insert_id() work ?

STEP 1: we create a table in a database with auto-generated field.

CREATE TABLE  tbl_student_inf

(

stu_ id NOT NULL AUTO_INCREMENT,

stu_name VARCHAR(250) NOT NULL,

PRIMARY KEY(‘stu_id’)

)

STEP 2: Create a connection file (connection.php)

<?php

mysql_connect("localhost","root","") or die ("Connection not exist" . mysql_error());

mysql_select_db("tutorial") or die ("table does not exists" ." " . mysql_error());

?>

 

STEP 3: PHP code (student_information.php) page

<?php

include("connection.php");

// include data base  connection file in a php page

$qry = "INSERT  INTO  tbl_student_inf (stu_name)  VALUES  (‘John’)";

mysql_query($qry);

$calculate_last_id = mysql_insert_id();

echo "New record inserted successfully. Last inserted ID in a table is: " .  $calculate_last_id;

?>

Result:

mysl-insert-id




Leave a Reply

avatar
  Subscribe  
Notify of