INSERT INTO > PHP

• 목록

$sql = "INSERT INTO MyGuests (firstname, lastname, email)

VALUES ('John', 'Doe', 'john@example.com')";

if ($mysqli->query($sql) === TRUE) {

  //if (mysqli_query($mysqli, $sql)) {

  //Get ID of The Last Inserted Record

  $last_id = $mysqli->insert_id;

  //$last_id = mysqli_insert_id($mysqli);

  echo $last_id;

} else {

  echo $mysqli->error;

}