How can pagination be implemented in PHP to display a certain number of entries per page from a table with multiple entries?

To implement pagination in PHP to display a certain number of entries per page from a table with multiple entries, you can use the LIMIT clause in SQL queries to fetch a specific number of rows per page. You also need to calculate the total number of pages based on the total number of entries and the desired number of entries per page. Finally, you can create pagination links to navigate through the pages. 

<?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);
}

// Define number of entries per page
$entries_per_page = 10;

// Get current page number
if (isset($_GET['page'])) {
    $page = $_GET['page'];
} else {
    $page = 1;
}

// Calculate offset
$offset = ($page - 1) * $entries_per_page;

// Fetch entries from database
$sql = "SELECT * FROM table_name LIMIT $offset, $entries_per_page";
$result = $conn->query($sql);

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

// Create pagination links
$sql = "SELECT COUNT(*) as total FROM table_name";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$total_entries = $row['total'];
$total_pages = ceil($total_entries / $entries_per_page);

for ($i = 1; $i <= $total_pages; $i++) {
    echo "<a href='?page=$i'>$i</a> ";
}

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

Keywords

pagination PHP entries per page table multiple entries

Related Questions