Last updated on February 25th, 2022 at 08:15 am
If you have auto_increment field set for MySQL table then it is very easy to get details of last row in that table. I have also provided complete php code on how to get details of last n rows in a MySQL table.
We have provided code examples for both mysql_connect and mysqli_connect functions.
Before getting started,
Lets assume I have a table named testable with the below data
mysql> select * from testable;
+----+--------------+------------------------+
| Id | Name | Email_Address |
+----+--------------+------------------------+
| 1 | Steve Jones | [email protected] |
| 2 | Stella Tom | [email protected] |
| 3 | Arthur Peter | [email protected] |
+----+--------------+------------------------+
3 rows in set (0.00 sec)
mysql>
Using mysql_connect()
First step is, Connect to your database using PHP. Name the file as connect.php
<?php
//change these values accordingly
$host = "localhost";
$username = "root";
$password = "SOMEPWD";
$database = "MY_DATASE";
//Make your connection to database
$con = mysql_connect($host,$username,$password);
//Check your connection
if (!$con) {
die("Could not connect: " . mysql_error());
}
//Select your database
$db_selected = mysql_select_db($database, $con);
//Check your connection
if (!$con) {
die("Could not connect: " . mysql_error());
}
?>
Second step is to run MySQL query and get the last row in the table. Name this file as last_row.php
include('connect.php');
$table = "MY_TABLE";
$lastrow = mysql_query("SELECT * FROM $table ORDER BY id DESC LIMIT 1");
$get_last_row = mysql_fetch_array($lastrow);
echo $get_last_row['Email_Address'];
In the above code we are initially connecting to the database using the include statement.
SELECT * FROM $table ORDER BY id DESC LIMIT 1
This query will return last row from the table. I have many columns in that table and one of them is named as ‘Email_Address’.
After fetching details of the row we can display it using below code.
$get_last_row = mysql_fetch_array($lastrow);
echo $get_last_row['Email_Address'];
To get last n rows in a MySQL table, All you have to do is change the MySQL query
SELECT * FROM SOMETABLE ORDER BY id DESC LIMIT 3
I have given numeric 3 after LIMIT. That means sql will display last 3 rows in the table. You can change that number according to your needs. In order to display these values in php you need to modify the code and add a while loop.
$lastrow = mysql_query("SELECT * FROM $table ORDER BY id DESC LIMIT 3");;
while($get_last_row = mysql_fetch_array($lastrow))
{
echo $get_last_row['Email_Address']."<p>";
}
Using mysqli_connect()
Now let us create a connect.php file with all the MySQL database connection details.
<?php
//change these values accordingly
$host = "localhost";
$username = "";
$password = "";
$database = "";
//Make your connection to database
$con = mysqli_connect($host,$username,$password);
//Check your connection
if (!$con) {
die("Could not connect: " . mysqli_error());
}
//Select your database
$db_selected = mysqli_select_db($con,$database);
//Check your connection
if (!$con) {
die("Could not connect: " . mysqli_error());
}
?>
Next step is to create a file named index.php in the same location and use the code below to fetch the last row from the table
<?php
include('connect.php');
$table = "testable";
$lastrow = mysqli_query($con,"SELECT * FROM $table ORDER BY id DESC LIMIT 1");
$get_last_row = mysqli_fetch_array($lastrow);
echo $get_last_row['Email_Address']." is the last row in the table";
?>