smarty+adodb+部分自定义类的php开发模式_PHP教程

$db=new Db; 
 $sql="select * from com_info,hr_info where hr_info.ci_id=com_info.id and {$cate} like '%{$content}%'"; 
 $totalArr=$db->execute($sql); 
 $url="hr.php?op=searchHrInfoAction&cate={$cate}&content=".urlencode($content); 
 $totalItems=count($totalArr); 
 $currentPageNumber=(isset($_GET['page']))?$_GET['page']:1; 
 $pageNav=new PageNumber($currentPageNumber,$totalItems,3,3,$url); 
 $currentPageRs=$pageNav->getRsPerPage(&$totalArr); 
 $pageNavigation=$pageNav->getPageNumber(); 
 $smarty->assign("pageNavigation",$pageNavigation); 
 $smarty->assign("hr",$currentPageRs); 
 $smarty->display("hr_get.htm");