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