How can a GET parameter indicating the current page, along with LIMIT and OFFSET calculations, be used to implement pagination in a PHP project?

To implement pagination in a PHP project, a GET parameter indicating the current page can be used along with LIMIT and OFFSET calculations to fetch a specific subset of data from a database. By adjusting the LIMIT and OFFSET values based on the current page, the application can display a limited number of results per page, allowing users to navigate through multiple pages of data. 

// Assuming connection to database is already established

$limit = 10; // Number of results per page
$page = isset($_GET['page']) ? $_GET['page'] : 1; // Get current page from GET parameter

$offset = ($page - 1) * $limit; // Calculate OFFSET value

$query = "SELECT * FROM your_table LIMIT $limit OFFSET $offset";
$result = mysqli_query($connection, $query);

// Display results on the page
while ($row = mysqli_fetch_assoc($result)) {
    // Display data here
}

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

Keywords

GET parameter pagination LIMIT OFFSET PHP project

Related Questions