php分页

//查询代理
    function loadAffs($bcgs,$prj,$affaccount){
    $sql="select CONCAT('R-', t1.id) AS RID, t1.prj, t3.prjname, t1.bid, t2.name, t1.AffBZ, t1.uid, t1.CUNKUAN, t1.TIKUAN, t1.HYJG, t1.TICHENG, t1.NEWMEMS, t1.HUOYUE, t1.pwd, t2.AffLoginURL, t1.BEILV, t1.HUILV";
        $sql=$sql." from myccs.t_bet_bcgs_link t1, myccs.t_bet_bcgs t2, myccs.t_ccs_project t3 where t1.prj=t3.prjid and t1.bid=t2.id";
        if (!empty($bcgs))
        $sql = $sql." and t1.bid='$bcgs'";
       
        if (!empty($prj))
        $sql = $sql." and t1.prj='$prj'";
       
        if (!empty($affaccount))
        $sql = $sql." and t1.uid='$affaccount'";
       
        $sql2 = "select count(*) as countnum from myccs.t_bet_bcgs_link t1, myccs.t_bet_bcgs t2, myccs.t_ccs_project t3 where t1.prj=t3.prjid and t1.bid=t2.id";
        if (!empty($bcgs))
        $sql2 = $sql2." and t1.bid='$bcgs'";
       
        if (!empty($prj))
        $sql2 = $sql2." and t1.prj='$prj'";
       
        if (!empty($affaccount))
        $sql2 = $sql2." and t1.uid='$affaccount'"; 
 
$count = db_first_value($sql2); 

$Page_size = 50;
$page_count = ceil($count/$Page_size); 
$init       = 1; 
$page_len   = 7; 
$max_p      = $page_count; 
$pages      = $page_count; 
//判断当前页码 
if(empty($_GET['page'])||$_GET['page']<0){ 
$page=1; 
}else { 
$page=$_GET['page']; 
} 
$offset=$Page_size*($page-1); 
$sql=$sql." limit $offset,$Page_size";
         
    $result= db_query($sql);
   
while ($row=mysql_fetch_array($result)) { 
echo "<tr><td>".$row['RID']."</td><td>".$row['prj']."</td><td>".$row['prjname']."</td><td>".$row['name']."</td></tr>"; 
}

$page_len = ($page_len%2)? $page_len:$pagelen+1;//页码个数 
$pageoffset = ($page_len-1)/2;//页码个数左右偏移量 


$key="  <span class='page'> 总记录：".$count."&nbsp;&nbsp;&nbsp;&nbsp;"; 
$key.="<span>$page/$pages</span>&nbsp;";   //第几页,共几页 
if($page!=1){ 

$key.="<a href='".$_SERVER['PHP_SELF']."?page=1'>第一页</a> ";    //第一页 
$key.="<a href='".$_SERVER['PHP_SELF']."?page=".($page-1)."'>上一页</a>"; //上一页' 
}else { 
$key.="第一页 ";//第一页 
$key.="上一页"; //上一页 
} 
if($pages>$page_len){ 
//如果当前页小于等于左偏移 
if($page<=$pageoffset){ 
$init=1; 
$max_p = $page_len; 
}else{//如果当前页大于左偏移 
//如果当前页码右偏移超出最大分页数 
if($page+$pageoffset>=$pages+1){ 
$init = $pages-$page_len+1; 
}else{ 
//左右偏移都存在时的计算 
$init = $page-$pageoffset; 
$max_p = $page+$pageoffset; 
} 
} 
} 
for($i=$init;$i<=$max_p;$i++){ 
if($i==$page){ 
$key.='<span>'.$i.'</span>'; 
} else { 
$key.=" <a href='".$_SERVER['PHP_SELF']."?page=".$i."'>".$i."</a>"; 
} 
} 

if($page!=$pages){ 
$key.=" <a href='".$_SERVER['PHP_SELF']."?page=".($page+1)."'>下一页</a> ";//下一页 
$key.="<a href='".$_SERVER['PHP_SELF']."?page={$pages}'>最后一页</a>"; //最后一页 
}else { 
$key.="下一页 ";//下一页 
$key.="最后一页"; //最后一页 
} 
$key.='</span>';

echo "<tr><td colspan=4>";
echo $key;
echo "</td></tr>";
    }