一个好用的分页函数_php技巧

本人原创的代码,高手看来,也许流程笨拙点,但是很实用.看者要顶啊 <br><br>    /*---------------------------------------------------------------// <BR>  * 函数说明：分页函数 page($sql,$pagesize="30") <BR>  * $sql 查询语句(除limit外，可带排序或者条件限制)  <BR>  * 如 select * from stu where time between "1" and "30"; <BR> <div>……本2文来源gaodai.ma#com搞##代!^码@网3</div><code>搞代gaodaima码</code> * $pagesize 每页的显示条数 <BR>  * ## 可输出数组$arr的值，说明如下：  <BR>  *    $arr["first"]    首页及地址 <BR>  *    $arr["page_pre"] 上一页及地址 <BR>  *    $arr["all"]      当第几页和总页数 <BR>  *    $arr["page_next"]下一页及地址 <BR>  *    $arr["last"]     末页及地址 <BR>  *    $arr["pagelist"] 页码列表及地址，显示当前页前后4页列表 <BR>  *    $arr["query"]    语句 $arr["query"] = mysql_query($sql) <BR>  *    $arr["nums"]     记录总数 <BR>  *                                 2006.09.06 by Kevin QQ:84529890 <BR>//----------------------------------------------------------------*/ <BR>function page($sql,$pagesize="30"){ <br><br>global $arr,$PHP_SELF; <br><br>$query = mysql_query($sql); <BR>$num = mysql_num_rows($query); <BR>$pagecount = ceil($num/$pagesize); <BR>$page = $_GET["page"]; <BR>if(!$page) $page=1; <BR>if($page>$pagecount) $page = $pagecount; <br><br>$offset = ($page-1)*$pagesize; <BR>$sql.=" limit $offset , $pagesize"; <BR>$arr["query"] = mysql_query($sql); <br><br>if($page>1){ <BR>     $page_pre = $page-1; <BR>  $page_url = $PHP_SELF . "?page=".$page_pre; <BR>  $arr["page_pre"] = "上一页|\n"; <BR>} <BR>if($page<$pagecount){ <BR>     $page_next = $page+1; <BR>  $page_url = $PHP_SELF . "?page=".$page_next; <BR>  $arr["page_next"] = "|下一页\n"; <BR>} <br><br>$arr["all"] = "<font color="#FF0000">".$page ."</font>/". $pagecount . "页"; <BR>$arr["first"] = "首页\n|"; <BR>$arr["last"]  = "|末页\n"; <br><br>$plfront=""; <BR>if($page=1){ <BR>     for($i=1;$i<=9;$i++){ <BR>      $plfront.= " ".$i.""; <BR>   } <BR>}elseif($page>5 && $page<$pagecount-5){ <BR>     for($i=$page-4;$i<$page+5;$i++){ <BR>      $plfront.= " ".$i.""; <BR>   } <BR>}else{ <BR>     for($i=$pagecount-8;$i<=$pagecount;$i++){ <BR>      $plfront.= " ".$i.""; <BR>  } <BR>} <br><br>$arr["pagelist"] = $plfront." "; <BR>$arr["nums"] = $num; <BR>   }<BR>

喜欢 (0)赏

[搞代码]

分享 (0)