How to Implement Pagination in PHP and MySQL to Display 10 Results Per Page?

PHP and MySQL Pagination: A Step-by-Step Guide to Displaying 10 Results Per Page

To paginate your MySQL query that retrieves your user's redirects and displays 10 results per page, consider the following solution:

1. Calculate Pagination Variables:

<code class="php">$perPage = 10;
$page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
$startAt = $perPage * ($page - 1);</code>

2. Count Total Results:

<code class="php">$query = "SELECT COUNT(*) as total FROM redirect
WHERE user_id = '".$_SESSION['user_id']."'";
$r = mysql_fetch_assoc(mysql_query($query));

$totalPages = ceil($r['total'] / $perPage);</code>

3. Generate Page Links:

<code class="php">$links = "";
for ($i = 1; $i <= $totalPages; $i++) {
  $links .= ($i != $page) 
            ? "<a href='index.php?page=$i'>Page $i</a> "
            : "$page ";
}</code>

4. Execute the Paginated Query:

<code class="php">$query = "SELECT * FROM 'redirect'
WHERE 'user_id'= \''.$_SESSION['user_id'].' \' 
ORDER BY 'timestamp' LIMIT $startAt, $perPage";

$r = mysql_query($query);</code>

5. Display Results and Page Links:

Implement your own logic to display the retrieved results and the generated page links.

<code class="php">// display results here the way you want

echo $links; // show links to other pages</code>

This solution uses PHP and MySQL pagination techniques to display a fixed number of results per page and provide navigation links to other pages.

The above is the detailed content of How to Implement Pagination in PHP and MySQL to Display 10 Results Per Page?. For more information, please follow other related articles on the PHP Chinese website!