I am using pagination for a set of query results.
the website now uses friendly URL's with the help from mod_rewrite.
I am trying to get my pagination working again but in having trouble...
.htaccess file:
Code: Select all
RewriteRule ^/results/page([0-9]{1,4})(/)$ results.php?num=$1 [L]Code: Select all
$query = "SELECT * FROM tblJobs";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$data[] = $row;
$i_Total++;
}
$params = array(
'itemData' => $data,
'perPage' => 5,
'append' => false,
'urlVar' => 'num',
'mode' => 'Jumping',
'path' => 'http://quest-recruiting/results/',
'fileName' => 'page%d/'
);
$pager = & Pager::factory($params);
$pagedata = $pager->getPageData();
$links = $pager->getLinks();
if($pager->isLastPage())
{
$items = $pager->numItems() % $params['perPage'];
}
else
{
$items = $params['perPage'];
}
list($first, $last) = $pager->getOffsetByPageId();
$s_HtmlContent .= '<p>Page: '.$links['all'].'</p>'."\n";
$s_HtmlContent .= '<p>Results '.$first.' - '.$last.' of about '.$pager->numItems().'</p>'."\n";
foreach($pagedata as $row)
{
// more code here
$s_HtmlContent .= '<p>'.$row['description'].'</p>'."\n";
// more code here
}http://pear.php.net/manual/en/package.h ... .intro.php
TIA!