Ìṩһ¸öPHPͨÓ÷ÖÒ³Function¸ø´ó¼Ò

function mysql_conn(){
$conn=mysql_pconnect('localhost','root','root');
mysql_select_db('liuyan');
mysql_query('set names utf8');
return $conn;
}
//$sqlΪSQLÓï¾ä£»$pageΪµÚ¼¸Ò³£¬$pagesizeΪһҳÏÔʾ¶àÉÙÌõ
//×îºó½«·µ»ØÒ»¸öarrayµÄÊý¾ÝÀàÐÍ,ÀïÃæ°üº¬$arr['result']£¬$arr['fypage']
function page($sql,$page=0,$pagesize=0){

$arr = array();

if($page != 0 && $pagesize != 0){ //no fanye
$conn=mysql_conn();
$result2 = mysql_query($sql);
$sql .= " limit ".($page-1)*$pagesize.','.$pagesize;
$result = mysql_query($sql);
$num=mysql_num_rows($result2); //the total num
mysql_close($conn);
$pagecount = 0;
if($num){
if($num<$pagesize){
$pagecount=1;
}
if($num%$pagesize){
$pagecount=(int)($num/$pagesize)+1;
}else{
$pagecount=($num/$pagesize);
}
}else{
$pagecount=0;
}
$fypage = '';
if($page==1){
$fypage.=' first | previous |';
}else{
$fypage.="<a href="\" mce_href="\""?page=1\">first</a> | <a href="\" mce_href="\""?page=".($page-1)."\">previous</a> |";
}
if($page==$pagecount||$pagecount==0){
$fypage.=" next | last page:$page/$pagecount";
}else{
$fypage.=" <a href="\" mce_href="\""?page=".($page+1)."\">next</a> | <a href="\" mce_href="\""?page=$pagecount\">last</a> page:$page/$pagecount";
}

$arr['result'] = $result; //Õâ¸öÊÇÊý¾Ý¼¯
$arr['fypage'] = $fypage; //Ò³½ÅµÄ[ÉÏÒ»Ò³],[ÏÂÒ»Ò³],[µÚÒ»Ò³]µÈ

}else {
$conn=mysql_conn();
$result=mysql_query($sql);
mysql_close($conn);
$arr['result'] = $result;
}

return $arr;

}