Object Oriented Style

  $stmt = $maindb->prepare("
    INSERT INTO my_table
    (
      MyColumn1,
      MyColumn2
    ) VALUES (
      ?,
      ?
    )");
  $stmt->bind_param("si", $MyColumn1, $MyColumn2);
  $MyColumn1 = "abc";
  $MyColumn2 = 12;
  $stmt->execute();
  $stmt->close();
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 (
			some_id,
			email_address
		) VALUES (
			$some_id,
			'$email'
		)");
	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.

Comments

Your email address will not be published.