Classe: DB_Pager  - X-Ref

This class handles all the stuff needed for displaying paginated results
from a database query of Pear DB, in a very easy way.
Documentation and examples of use, can be found in:
http://vulcanonet.com/soft/pager/ (could be outdated)

IMPORTANT!
Since PEAR DB already support native row limit (more fast and avaible in
all the drivers), there is no more need to use $pager->build() or
the $pager->fetch*() methods.

Usage example:

< ?php
require_once 'DB/Pager.php';
$db = DB::connect('your DSN string');
$from = 0;   // The row to start to fetch from (you might want to get this
// param from the $_GET array
$limit = 10; // The number of results per page
$maxpages = 10; // The number of pages for displaying in the pager (optional)
$res = $db->limitQuery($sql, $from, $limit);
$nrows = 0; // Alternative you could use $res->numRows()
while ($row = $res->fetchrow()) {
// XXX code for building the page here
$nrows++;
}
$data = DB_Pager::getData($from, $limit, $nrows, $maxpages);
// XXX code for building the pager here
? >