【代码片段】php分页代码

<?
include_once "../config/auth.php";
include_once "../config/public_include.php";
include_once "../config/db_function.php";
include_once "../config/functions.inc.php"; 
$conn = Connect_DB($DB_VARS_ARRAY);  
$fullname=$_GET['fullname'];
$action=$_GET['action'];
$smarty->assign('fullname',$fullname);
$smarty->assign('action',$action);
$page_now=$_GET['page_now'];
if(strlen($page_now)<1){
	$page_now=1;
}
if($action==""){ 
    $sql="select * from gys";
}else{
    $sql="select * from gys where  fullname like '%$fullname%'";	
}	
$page_recs=8;//每页显示记录数
$rec=mysql_query($sql,$conn);
$total_user=mysql_num_rows($rec);
$pages=ceil($total_user/$page_recs);
if($page_now>$pages){
	$page_now=$pages;
}
if($page_now<=1){
    $before_page=1;
    if($pages>1){
    	$after_page=$page_now+1;
    }else{
    	$after_page=1;
    }
}else{
    $before_page=$page_now-1;
    if($page_now < $pages){
	    $after_page=$page_now+1;
	}else{
		$after_page=$pages;
    }
}
$i=($page_now-1)*$page_recs;
$tmpi=0;
if($total_user>0){
    mysql_data_seek($rec,$i);
}
while($row=mysql_fetch_array($rec)){			
	$userarray[$tmpi]['id']=$row["Id"];				
	$userarray[$tmpi]['fullname']=$row['fullname'];		
	$tmpi++;
	if($tmpi>=$page_recs){
		break;
	}
}
$sql3="select * from type1";
$rec3=mysql_query($sql3,$conn);
$i=1;
while($row3=mysql_fetch_array($rec3,MYSQL_ASSOC)){
    $userarray3[$i]['id']=$row3["Id"];
    $userarray3[$i]['names']=$row3["names"];
    $i++;
}
$smarty->assign("userarray3",$userarray3);
$smarty->assign("userarray",$userarray);
$smarty->assign("page_now",$page_now);
$smarty->assign("page_recs",$page_recs);
$smarty->assign("pages",$pages);
$smarty->assign("total_user",$total_user);
$smarty->assign("before_page",$before_page);
$smarty->assign("after_page",$after_page);
$smarty->display('gys_select.tpl');
?>