分页函数

60 阅读 0 评论 40 点赞

我是靠谱客的博主漂亮饼干，最近开发中收集的这篇文章主要介绍分页函数，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

<?php
function getList($table,$offset,$per_page)
{
	// $sql = 'select * from news';
	$sql = "select * from $table order by id desc limit $offset,$per_page";
	// print_r($sql);
	// die;
	$query = mysql_query($sql);
	// $row = mysql_fetch_assoc($query); 
	// print_r($row);
	while($row = mysql_fetch_assoc($query) )
	{	
		$rout[] = $row; 
	}
	return $rout;
}
function page($table,$url,$cur_page=1,$per_page=3,$page_num = 5)
{
	//中间五页
// 控制页码的数目，因此更改页码的循环，而且当前页要在中间，得到前后的页码数 固定页数/2的向下取整
$floor_page = floor($page_num/2);   
// echo $floor_page;  //  值为2
$sql = "select count(*) as totle from $table";
$query = mysql_query($sql);
$row = mysql_fetch_assoc($query);
// print_r($row);
$totle = $row['totle'];
$total_page = ceil($totle/$per_page);  //向上取整   总的页数
$start_page = $cur_page - $floor_page;
$end_page = $cur_page + $floor_page;
if($start_page<1)
{
	$start_page = 1;
	$end_page  = $page_num;
}
if($end_page>$total_page)
{
	$end_page = $total_page;
	$start_page = $total_page - $page_num + 1;
}
if($total_page < $page_num)
{
	$start_page = 1;
	$end_page = $total_page;
	
}
$page = "";
$page .= '<a href="'.$url.'&p=1" title="First Page">首页</a>';
if($cur_page !=1)
{
  $prev_page = $cur_page - 1;
  $page .= '<a href="'.$url.'&p='.$prev_page.'" title="'.$prev_page.'">上一页</a>';
  }
for($i=$start_page;$i<=$end_page;$i++)
{
	 if($i == $cur_page )
	 {
	$page .= ' <a href="'.$url.'&p='.$i.'" class="number current" title="'.$i.'">'.$i.'</a> ';
	 }
	else
	{
	$page .= ' <a href="'.$url.'&p='.$i.'" class="number" title="'.$i.'">'.$i.'</a> ';
	}
}
if($cur_page !=$total_page)
{
	 $next_page = $cur_page + 1;
	 $page .= ' <a href="'.$url.'&p='.$next_page.'" title="'.$next_page.'">下一页</a>';
 }
$page .= '  <a href="'.$url.'&p='.$total_page.'" title="'.$total_page.'">尾页</a> ';
return $page;
}