Are there any best practices to follow when displaying the last 10 entries from a database in PHP?

When displaying the last 10 entries from a database in PHP, it is important to retrieve the entries in descending order based on a timestamp or an auto-incrementing ID to ensure the most recent entries are displayed first. Additionally, limiting the query to only retrieve the last 10 entries can help improve performance and reduce unnecessary data retrieval. 

<?php
// Connect to database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Retrieve the last 10 entries from the database
$sql = "SELECT * FROM table_name ORDER BY timestamp_column DESC LIMIT 10";
$result = $conn->query($sql);

// Display the last 10 entries
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "ID: " . $row["id"]. " - Name: " . $row["name"]. "<br>";
    }
} else {
    echo "0 results";
}

// Close connection
$conn->close();
?>

Keywords

PHP database query pagination limit

Related Questions