Pager - search
| From: | Brent | Date: | Mon, 05 Dec 2005 22:11:44 +0000 |
| Subject: | Pager - search | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-22161@lists.php.net to get a copy of this message | ||
I'm having some trouble getting pager to work correctly. The problem is
displaying the next page after a search. It pulls the first page of data no
problem, but when I go to the next page, it defaults back to the sorted data
instead of the search data? Below is a code snippet, any ideas? Thanks!
Brent
if ((tool::securePost('search')) && (tool::securePost('search') !=
"") ||
((tool::secureGet('query')) && (tool::secureGet('query') !=
""))){
if (tool::securePost('search')){
$sql = "select * from users";
switch(tool::securePost('searchby')){
case "username":
$sql .= " where
username like '%".tool::securePost('usersearch')."%' order by
username";
break;
case "password":
$sql .= " where
password like '%".tool::securePost('usersearch')."%' order by
username";
break;
}
}
$users = $instDb->getAssocArray($sql);
}else{
$users = $instDb->getAssocArray("select * from user order by
username");
}
$params = array(
'mode' => 'jumping',
'perPage' => '20',
'delta' => '5',
'itemData'=> $users,
'altNext' => $navigation['nextpage'],
'altPrev' => $navigation['prevpage'],
'nextImg' => $navigation['next'],
'prevImg' => $navigation['prev'],
);
$pager = & Pager::factory($params);
$data = $pager->getPageData();
$links = $pager->getLinks();
$this->assign('allUsers',$data);
$this->assign('allLinks',$links);
$this->assign('currentPage',$pager->getCurrentPageID());
$this->assign('totalPage',$pager->numPages());