Re: Pagination
| From: | Matthew Weier O'Phinney | Date: | Sun, 27 Mar 2005 01:20:47 +0000 |
| Subject: | Re: Pagination | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-211644@lists.php.net to get a copy of this message | ||
* Pavel <pavel@ogi.cz>:
>> I am wanting to paginate records from a MySQL Database.
>> I want there to be 5 records on a page, on multiple pages.
>
> example for selecting page of records from mysql table:
> $sql=sprintf("
> SELECT SQL_CALC_FOUND_ROWS * FROM table LIMIT %d, %d",
> $position*$records,
> $records
> );
>
> after get count of all records:
> $sql='SELECT FOUND_ROWS()';
>
>> (I would like there to be a "next" and "previous.")
>
> you can use http://pear.php.net/package/Pager
+1 PEAR::Pager
In the examples/ directory of the Pager class is a wrapper class for
doing pagination from DB results; this will answer the OP's question.
--
Matthew Weier O'Phinney | WEBSITES:
Webmaster and IT Specialist | http://www.garden.org
National Gardening Association | http://www.kidsgardening.com
802-863-5251 x156 | http://nationalgardenmonth.org
mailto:matthew@garden.org | http://vermontbotanical.org