mysql_query get last insert id php code example
Example 1: mysql get the last id php
$query = "insert into users(username,fname,lname) values('sonarika','Sonarika','Bhadoria')";
mysqli_query($con,$query);
$lastid = mysqli_insert_id($con);
Example 2: last_insert_id() php
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) { die('Impossible de se connecter : ' . mysql_error()); }
mysql_select_db('mydb');
mysql_query("INSERT INTO mytable (product) values ('something')");
printf("last inserted id is %d\n", mysql_insert_id());
?>