How can PHP be used to access and display data from a MySQL database without overwhelming the user with a long page?

To prevent overwhelming the user with a long page when displaying data from a MySQL database using PHP, you can implement pagination. Pagination breaks up the data into smaller, more manageable chunks that the user can navigate through. 

<?php
// Establish a database connection
$connection = mysqli_connect("localhost", "username", "password", "database");

// Determine the current page
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$limit = 10; // Number of items per page

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

// Fetch data from the database with pagination
$query = "SELECT * FROM table LIMIT $limit OFFSET $offset";
$result = mysqli_query($connection, $query);

// Display the data
while ($row = mysqli_fetch_assoc($result)) {
    echo $row['column1'] . ' - ' . $row['column2'] . '<br>';
}

// Create pagination links
$total_results = mysqli_num_rows(mysqli_query($connection, "SELECT * FROM table"));
$total_pages = ceil($total_results / $limit);

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

// Close the database connection
mysqli_close($connection);
?>

Keywords

PHP MySQL data access data display pagination

Related Questions