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; }