Object Oriented Style

  $stmt = $maindb->prepare("
    INSERT INTO my_table
    ) VALUES (
  $stmt->bind_param("si", $MyColumn1, $MyColumn2);
  $MyColumn1 = "abc";
  $MyColumn2 = 12;
Get Auto ID Of New Record
  $result = $maindb->query("INSERT INTO some_table (list_name, user_id) VALUES ('john', 1000)");
  if ($result == TRUE)
    $my_variable = $maindb->insert_id;		//Get the auto increment ID value that was assigned

Procedural Style

	$result = mysqli_query($dblink, "INSERT INTO my_table (
		) VALUES (
	if ($result != TRUE)
		die("ERROR - Can't add to database");
Get Auto ID Of New Record
	$result = mysqli_query($dblink, "INSERT INTO some_table (list_name, user_id) VALUES ('$list_name', $user_id)");
	if ($result == TRUE)
		$my_variable = mysqli_insert_id($dblink);		//Get the auto increment ID value that was assigned

The mysqli_insert_id() 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.

Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.


Your email address will not be published.