thinkphp 数据库内容分页展示

1.thinkphp代码 

 每次读取固定行数的记录  采用limit 当然thinkphp中也可以使用page

页面显示50条记录

// 读出alterlog
	public function show_alertlog($page_id) {
		// echo "I am in /Home /alertlog controller/show_alertlog";
		$step=50; //步长每页显示的行数
		$page_start=($page_id-1)*$step;
		$logDB = M ( 'log_alert' );
		return $logDB->limit($page_start,$step)->select();
	}

翻页导航 页码

	public function page_nav($page_id)
	{
		// 总记录条数 页数统计
		$logCount = M ( 'log_alert' )->count ();
		$page_num = ( int ) ($logCount / 50) + ($logCount % 50 > 0);

		//前一页
		$page_previous=1;
		if($page_id>1)
		{
			$page_previous = $page_id-1;
		}
		
		//下一页
		$page_next = $page_num;
		if($page_id<$page_num)
		{
			$page_next = $page_id+1;
		}
		
		//起始页  尾页
		$page_1st = 1;
		$page_end = $page_num;
		
		// 动态页码生成 页码列表
		if ($page_id < ($page_num - 1) and $page_id > 2) {
			$page_id_array = array ($page_id - 2,$page_id - 1,$page_id,$page_id + 1,$page_id + 2);
		} elseif ($page_id < 3) {
			$page_id_array = array (1,2,3,4,5);
		} elseif ($page_id > $page_num - 2) {
			$page_id_array = array ($page_num-4,$