I have a pagination script that displays a list of all pages like so:
prev [1][2][3][4][5][6][7][8][9][10][11][12][13][14] next
But I would like to only show ten of the numbers at a time:
prev [3][4][5][6][7][8][9][10][11][12] next
How can I accomplish this? Here is my code so far:
<?php
/* Set current, prev and next page */
$page = (!isset($_GET['page']))? 1 : $_GET['page'];
$prev = ($page - 1);
$next = ($page + 1);
/* Max results per page */
$max_results = 2;
/* Calculate the offset */
$from = (($page * $max_results) - $max_results);
/* Query the db for total results.
You need to edit the sql to fit your needs */
$result = mysql_query("select title from topics");
$total_results = mysql_num_rows($result);
$total_pages = ceil($total_results / $max_results);
$pagination = '';
/* Create a PREV link if there is one */
if($page > 1)
{
$pagination .= '< a href="?page='.$prev.'">Previous</a> ';
}
/* Loop through the total pages */
for($i = 1; $i <= $total_pages; $i++)
{
if(($page) == $i)
{
$pagination .= $i;
}
else
{
$pagination .= '< a href="index.php?page='.$i.'">'.$i.'</a>';
}
}
/* Print NEXT link if there is one */
if($page < $total_pages)
{
$pagination .= '< a hr_ef="?page='.$next.'"> Next</a>';
}
/* Now we have our pagination links in a variable($pagination) ready to
print to the page. I pu it in a variable because you may want to
show them at the top and bottom of the page */
/* Below is how you query the db for ONLY the results for the current page */
$result=mysql_query("select * from topics LIMIT $from, $max_results ");
while ($i = mysql_fetch_array($result))
{
echo $i['title'].'<br />';
}
echo $pagination;
?>
10 next pages
for($i = $page + 1; $i <= min($page + 11, $total_pages); $i++)
or if you want 5 prev and 5 next
for($i = max(1, $page - 5); $i <= min($page + 5, $total_pages); $i++)
I've just been looking for an answer to the same original question, and couldn't find it, so this is what I came up with. I hope someone else finds it useful.
$totalPages = 20;
$currentPage = 1;
if ($totalPages <= 10) {
$start = 1;
$end = $totalPages;
} else {
$start = max(1, ($currentPage - 4));
$end = min($totalPages, ($currentPage + 5));
if ($start === 1) {
$end = 10;
} elseif ($end === $totalPages) {
$start = ($totalPages - 9);
}
}
for ($page = $start; $page <= $end; $page++) {
echo '[' . $page . ']';
}
Results:
$currentPage = 1; // [1][2][3][4][5][6][7][8][9][10]
$currentPage = 4; // [1][2][3][4][5][6][7][8][9][10]
$currentPage = 10; // [6][7][8][9][10][11][12][13][14][15]
$currentPage = 17; // [11][12][13][14][15][16][17][18][19][20]
$currentPage = 20; // [11][12][13][14][15][16][17][18][19][20]
If you just want a quick fix, you might try modifying your for
loop a little. For example, you won't want to start at 1, and you won't necessarily want to loop while $i <= $total_pages
.
Displaying an odd number of pagination links might make more sense: you would display the current page, then four to the left of it, and four to the right. Something like this:
for($i = $page_number - 4; $i <= $page_number + 4; $i++) {
but you would obviously need to do a little bit more to ensure you weren't displaying negative numbers, or displaying more links than there are pages.
$page = 3;
$totalPages = 33;
$count = 9;
$startPage = max(1, $page - $count);
$endPage = min( $totalPages, $page + $count);
if($page-1 > 0){
echo '<a class="btn btn-default" href="/search-results?page="'.($page-
1).'"><< Prev</a>';
}
for($i = $startPage; $i < $endPage; $i++): if($i <= $totalPages):
echo '<a class="btn btn-<?=$i == $page || $i == 1 && $page == "" ?
'success' : 'primary';?>"style="margin-right:2px;" href="/search-
results?page="'.$i.'">'.$i.'</a>';
endif; endfor;
if($page < $totalPages){
echo '<a class="btn btn-default" href="/search-results?page="'.
($page+1).'">Next >></a>';
}