Breaking News: Grepper is joining You.com. Read the official announcement!

PHP MySQL Get Last Inserted ID

Add Answer

naly moslih answered on May 16, 2020 Popularity 10/10 Helpfulness 7/10

answer PHP MySQL Get Last Inserted ID

related get last inserted id in php

related mysql get the last id php

PHP MySQL Get Last Inserted ID

Comment

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";

if ($conn->query($sql) === TRUE) {
  $last_id = $conn->insert_id;
  echo "New record created successfully. Last inserted ID is: " . $last_id;
} else {
  echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

Popularity 10/10 Helpfulness 7/10 Language php

Source: Grepper

Tags: get mysql php

Link to this answer
Share Copy Link

Contributed on May 23 2022

naly moslih

0 Answers Avg Quality 2/10

Closely Related Answers

get last inserted id in php

Comment

Example (MySQLi Procedural)
$last_id = mysqli_insert_id($conn);

Popularity 10/10 Helpfulness 9/10 Language php

Source: Grepper

Tags: get

Link to this answer
Share Copy Link

Contributed on Mar 26 2021

Ankur

0 Answers Avg Quality 2/10

mysql get the last id php

Comment

// Insert query 
$query = "insert into users(username,fname,lname) values('sonarika','Sonarika','Bhadoria')"; 

mysqli_query($con,$query); 

// Get last insert id 
$lastid = mysqli_insert_id($con);

Popularity 10/10 Helpfulness 6/10 Language php

Source: makitweb.com

Tags: get

Link to this answer
Share Copy Link

Contributed on May 16 2020

Cerbrain

0 Answers Avg Quality 2/10

PHP MySQL Get Last Inserted ID

Contents

More Related Answers

PHP MySQL Get Last Inserted ID

Closely Related Answers

get last inserted id in php

mysql get the last id php

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.