How to Get the Last ID Saved in MySQL Using PHP, How to Set up Expiration on MySql in PHP, How to Convert MySQL Date and Time to Another Format in PHP,How to Add Simply Seconds, Minutes, Hours, Days, Months and Years to a Date and Time in PHP,How to Create a Simple Currency Converter in PHP,How to Create Simple Calorie Calculator Using PHP,How to Convert Number into Words in PHP

How to Get the Last ID Saved in MySQL Using PHP

by

Hello Guys today’s tutorial is all about How to Get the Last ID Saved in MySQL Using PHP The LAST_INSERT_ID() function returns the AUTO_INCREMENT id of the last row that has been inserted or updated in a table. Let’s get started:
1. Open PHPMyAdmin.
2. Create a database and name it as “getlasid”.
3. Create database connection and save it.
4.Then Create a form name it index.php and put this code

<!DOCTYPE html>
<html>
<head>
<title>How to Get the Last ID Saved in MySQL Using PHP</title>
</head>
<body>
	<h2>Add Form:</h2>
	<form method="POST">
	<label>Firstname:</label><input type="text" name="firstname">
	<label>Lastname:</label><input type="text" name="lastname">
	<label>Address:</label><input type="text" name="address">
	<input type="submit" value="Add" name="submit">
	</form>
	<?php
		$id="";
		$row['firstname']="";
		$row['lastname']="";
		$row['address']="";
		
		if (isset($_POST['submit'])){
			
			$firstname=$_POST['firstname'];
			$lastname=$_POST['lastname'];
			$address=$_POST['address'];
			
			include('conn.php');
			
			$conn->query("insert into `user` (firstname, lastname, address) values ('$firstname','$lastname','$address')"); 
			$id = $conn->insert_id;
			$query=$conn->query("select * from `user` where userid='$id'");
			$row = $query->fetch_assoc();
		}
	?>
	<h2>Last inserted Id: <?php echo $id; ?></h2>
	<h2>Data:</h2>
	<label>Firstname: </label> <?php echo $row['firstname']; ?><br>
	<label>Lastname: </label> <?php echo $row['lastname']; ?><br>
	<label>Address: </label> <?php echo $row['address']; ?>
</body>
</html>

<!DOCTYPE html>
<html>
<head>
<title>How to Get the Last ID Saved in MySQL Using PHP</title>
</head>
<body>
	<h2>Add Form:</h2>
	<form method="POST">
	<label>Firstname:</label><input type="text" name="firstname">
	<label>Lastname:</label><input type="text" name="lastname">
	<label>Address:</label><input type="text" name="address">
	<input type="submit" value="Add" name="submit">
	</form>
	<?php
		$id="";
		$row['firstname']="";
		$row['lastname']="";
		$row['address']="";
		
		if (isset($_POST['submit'])){
			
			$firstname=$_POST['firstname'];
			$lastname=$_POST['lastname'];
			$address=$_POST['address'];
			
			include('conn.php');
			
			$conn->query("insert into `user` (firstname, lastname, address) values ('$firstname','$lastname','$address')"); 
			$id = $conn->insert_id;
			$query=$conn->query("select * from `user` where userid='$id'");
			$row = $query->fetch_assoc();
		}
	?>
	<h2>Last inserted Id: <?php echo $id; ?></h2>
	<h2>Data:</h2>
	<label>Firstname: </label> <?php echo $row['firstname']; ?><br>
	<label>Lastname: </label> <?php echo $row['lastname']; ?><br>
	<label>Address: </label> <?php echo $row['address']; ?>
</body>
</html>

5.Lastly, Run and test the program!

Sample

If you have any comments or suggestions about the How to Get the Last ID Saved in MySQL Using PHP please message us directly.

Download Source Code here:

Other Articles you might read also:

1 thought on “How to Get the Last ID Saved in MySQL Using PHP”

Leave a Comment