How To Get The Latest Record In Mysql

Getting the latest record in MySQL is a task that can be accomplished in a few simple steps.

Whether you’re a beginner or a seasoned web developer, it’s important to know how to fetch data from a database efficiently. In this tutorial, we’ll show you how to get the latest record in MySQL using a simple query.

Step 1: Connect to the Database

To fetch data from a database, you need to first connect to it. Here’s how you can connect to a MySQL database using PHP:

1
2
3
4
5
6
7
8
9
10
11
12
13
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";
 
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
 
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";

Step 2: Write the Query

Once you’ve connected to the database, you can write a query to get the latest record. Here’s an example of how you can do that:

1
2
3
4
5
6
7
8
9
10
11
$query = "SELECT * FROM table_name ORDER BY id DESC LIMIT 1";
$result = mysqli_query($conn, $query);
 
if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "id: " . $row["id"]. " - Name: " . $row["name"]. " " . $row["lastname"]. "<br>";
    }
} else {
    echo "0 results";
}

Step 3: Execute the Query and Get the Result

Now that you’ve written the query, you need to execute it and get the result. Here’s how you can do that:

1
2
3
4
5
6
7
8
9
10
$result = mysqli_query($conn, $query);
 
if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "id: " . $row["id"]. " - Name: " . $row["name"]. " " . $row["lastname"]. "<br>";
    }
} else {
    echo "0 results";
}

Conclusion

In this tutorial, we’ve shown you how to get the latest record in a MySQL database using a simple query.

By following these steps, you’ll be able to fetch data from your database efficiently and effectively. Remember to always sanitize your inputs and outputs to avoid SQL injection attacks.

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";
 
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
 
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
 
$query = "SELECT * FROM table_name ORDER BY id DESC LIMIT 1";
$result = mysqli_query($conn, $query);
 
if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "id: " . $row["id"]. " - Name: " . $row["name"]. " " . $row["lastname"]. "<br>";
    }
} else {
    echo "0 results";
}

Output:

Connected successfully
id: 3 - Name: John Doe