How can I prevent a long page in PHP when displaying a large table?

To prevent a long page in PHP when displaying a large table, you can implement pagination. Pagination breaks up the table into multiple pages, making it easier for users to navigate through the data. This can be achieved by limiting the number of rows displayed per page and providing navigation links to move between pages. 

<?php
// Define the number of rows to display per page
$rows_per_page = 10;

// Get the current page number from the URL, default to page 1
$page = isset($_GET['page']) ? $_GET['page'] : 1;

// Calculate the offset for the SQL query
$offset = ($page - 1) * $rows_per_page;

// Query the database with LIMIT and OFFSET to fetch only the rows for the current page
$sql = "SELECT * FROM your_table LIMIT $rows_per_page OFFSET $offset";
// Execute the query and display the table data

// Display pagination links
$total_rows = // Get total number of rows from the database
$total_pages = ceil($total_rows / $rows_per_page);

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

Keywords

pagination limit offset MySQL data truncation

Related Questions