Based on feedback (and the long time between updates), I’m releasing an updated version of the PHP pagination class.
Changes
- No more SQL errors if using the class on a query with no results (although I fail to see the point of using it on an empty query anyway, but the bug is fixed)
- When selecting ‘ALL’ only one page is displayed, and if you are using the display_items_per_page drop-down menu, ‘ALL’ is now selected as well.
- If a page less than page one, or greater than the total number of pages is requested, no results are displayed and the appropriate prevous/next links are disabled
- The items per page array that populates the display_items_per_page drop-down menu is now an option that can be configured when instantiating the class. Previously this was hard-coded to the class.
- The $high option has been removed from the class (it was never used).
Note that if you receive a PHP notice about undefined indexes that you should turn down your error reporting. This notice may be displayed when loading the page for the first time when no $_GET variables are present. The class accounts for this, however PHP throws a notice about it.
Examples
I’ve also added license info at the head of the class (CC Attribution-ShareAlike 3.0 Unported (CC BY-SA 3.0)).
Hi,
I tried using v.1 and then v.2 of this pagination class and for some reason I can’t get the $pages->limit to work.
I used
$pages = new Paginator;
$pages->items_per_page = 21;
$pages->mid_range = 5;
run query “select * from table $pages->limit”
run query “select count(*) from table” for total items
$pages->items_total = $totalitems;
$pages->paginate();
For some reason the $pages->limit never get initialized. I even tried echo out $pages->limit without the query and it stills show nothing. Do you have any idea what could be happening? Thanks.
I’d need to have access to your code. I dropped the new versions in the same old examples here and there were no issues.
Thanks for the reply. I figured out the problem.
$pages->paginate() has to be called before I can use $pages->limit, unlike the other properties that were set.
I too am having this problem with the $pages->paginate(); having to be called first, Doing what Nathan said worked but It means that the word “All” is output twice, onces prior to the database call and one after including the pagination items.
Im not sure if this is a bug or not.
Cheers
Dan.
Hi, Any reasons why the the pagination only shows a link to page 1 and a link showing all the pages? I have 20 items and limited the results to 2 items per page.
Is it doing that for you here on the demo?
I believe I’m seeing something similar to what Michael cited (referring to our own machines, not the online demo): I see ’1′ and ‘All’ (followed by the default 25 City records). Clicking ‘All’ does display all records, but I don’t see any pagination.
(David, not Michael!)
How to make multiple pagination in single page? if have any idea please share with me… :)
Hi, great example, one little change
function display_jump_menu() {
for ($i = 1; $i num_pages; $i++) {
$option .= ($i == $this->current_page) ? "$i\n" : "$i\n";
}
return "Page:items_per_page$this->querystring';return false\">$option\n";
}
would produce a warning so just change the function like this:
function display_jump_menu() {
$option = '';
for ($i = 1; $i num_pages; $i++) {
$option .= ($i == $this->current_page) ? "$i\n" : "$i\n";
}
return "Page:items_per_page$this->querystring';return false\">$option\n";
}
so my problem is this:
$pages->items_total = XXXXXXXXXXXX;
$pages->mid_range = 25;
$pages->items_per_page = 50;
$pages->paginate();
$search = new search($_GET, $pages->limit);
I won’t know the total number until my search obj is instantiated. I can’t do the search till I got a limit. I’m stuck in a catch 22.
Any ideas?
Try reading the instructions carefully.
I thought I had. My full code, with nothing left to assumptions (using version 2 of the class):
//Step 1
require( $_SERVER['DOCUMENT_ROOT'] . "/classes/paginator.class.php");
//Step 3
$pages = new Paginator();
//Step 4
$pages->items_total = XXXXXXXXXXXX;
//Step 5
$pages->mid_range = 25;
$pages->items_per_page = 50;
//Step 6
$pages->paginate();
//Step 8
$search = new search($_GET, $pages->limit);
The problem is, my query has WHERE clauses in it… and is dynamic. When I instantiate my search object, I have it doing two queries inside, one with the limit and one without to populate $this->numrows and $this->results. Should I consider reworking it slightly to perhaps instantiate two searches, one with and one without the limit and forget about the $this->numrows property?
Whenever I do a search, then click on the next page, it always goes back to the original listing.
Example … I have 524 images I’m showing. Then, I do a search on say, photographer, which comes up with 175 images. It shows the right amount the first time (175), but when I click on the NEXT page, it always goes back to 524 images, instead of keeping the 175 I searched on?
Search on “Barry” under photographer for an example.
I just wanted to mention ‘admin’ set me straight on what I was doing wrong. Works perfect now!
Thanks
Hi Great pagination class.
I have 1 problem My site works through a template so my page links are in the format of /?index.php?page=gallery your pagination class works perfect as a standalone page but when I load it through my template in an include (“includes/gallery.php”); the page loads fine and the pagination links are all there but when I click a link on the pagination I get a not found 404 error.
Example
my gallery link = http://domain/index.php?page=gallery
on the pagination links they are ilke this http://domain/index.php?page=2&ipp=15
any help would be great thanks
I’d need to see your actual site/code to help.
Hi below is the code of my index page which loads the other pages as includes and below that is the gallery page include. All works fine when access the gallery when it is not an include but when you use the gallery as the include it loads the page fine and displays all the links but the links do not work any help to solve this problem would be great.
index page:
Gallery include page:
items_total = $num_rows[0];
$pages->mid_range = 9;
$pages->paginate();
echo “”;
echo “”.$pages->display_jump_menu().$pages->display_items_per_page().”";
echo “”;
echo “”;
echo $pages->display_pages();
echo “”;
$query = “SELECT photoName, photoID FROM photos WHERE active = 1 order by photoID desc $pages->limit”;
$result = mysql_query($query);
echo “”;
echo “”;
while($row = mysql_fetch_array($result))
{
echo “”;
echo ““;
}
echo “”;
echo “”;
echo “”;
echo $pages->display_pages();
echo “”;
echo “Page $pages->current_page of $pages->num_pages”;
echo “”;
?>
This is the index page it did not get posted before i guess it was because i had the body tags in it.
I’ll try again. index page
include (“includes/header.php”);
$page=(isset($_GET['page']))?$_GET['page']:’home’;
switch($page){
case “home”:
include (“includes/home.php”);
break;
case “contact”:
include (“includes/contact.php”);
break;
case “gallery”:
include (“includes/gallery.php”);
break;
default:
include (“includes/404.html”);
break;
}
include (“includes/footer.php”);
Can you provide some Demos of usage?
Can you provide some demos?
Do you see where it says “examples”…
I mean in zip file to check how to use this php class. In examples section of site the script is running. I need It’s code.
Sorry I found your post for usage:
http://www.catchmyfame.com/2007/07/28/finally-the-simple-pagination-class/
I can’t seem to get the paging working correctly when dealing with random recordsets ( ORDER BY RAND() ). When you go to the second page, the query gets resorted and you end up seeing records that originally appeared on page 1 also appear on page 2 and so on. It works perfectly for queries by any other sort order, but random does not.
Any advice on how to correct this would be greatly appreciated!
Random ordering won’t work because every time you change pages, the query gets executed and re-randomizes the results.
Thanks for the quick response.
There’s no way to store the query in memory to continue traversing through it in page chunks?
No, that would be more of a JavaScript solution where you randomize your entire recordset, pass it to the user, and then paginate it on the client side. One of the advantages of this class is its speed, which it gets by limiting the size of the data requested. Randomizing it would effectively kill that, unless you randomized your recordset once and then stored it in another table to query from.
Nevermind…ended up using a seeded RAND(#) call instead and holding the value in a session variable. That way I can hold the random recordset during that session and renew on next. All works great that way :)
Great! thanks. that’s what i was looking for since some time.
It works so far but if i go through the pages one by one the url will add many of the same requests into it.
/index.php?page=16&ipp=25&ipp=25&ipp=25&ipp=25&ipp=25&ipp=25&ipp=25
thats the outcome. Not sure why this will happen.
Any hint please ? Thanks
Has to be your code. I have some pages up to 60 something, and it doesn’t do that on my site.
Wish list …
Images for next-previous-All.
Option to remove ‘ALL’ if list hits certain amount – 500,1,000. (:
good stuff!
can ask something?
how can i implement this one in search..paginating the search result, thanks.