mysql 数据库分页类

简单实用的数据库分页类 该类需要继承我的博客中的数据库操作类：https://blog.csdn.net/liyuxing114/article/details/80574427

 

<?php
class page_class extends db_class{
	public $page; //当前页
	public $page_size;  //每页条数
	public $page_rcount;  //总条数
	public $page_count;	  //总页数
	public $page_type;    //分页类型 可自己编写喜欢的类型

	public function page_setvalue($page,$page_size,$page_type=1){	//设置属性
		$this->page=$page;
		$this->page_size=$page_size;
		$this->page_type=$page_type;
		$this->page_getrcount();
		$this->page_getcount();
	}
	
	public function page_limit(){		//设置分页条件
		$arr=array();
		$start=($this->page-1)*$this->page_size;
		$end=$this->page_size;
	    $this->db_setlimit($start, $end);
	    $arr[0]=$this->db_select();
	    $str="page_type".$this->page_type;
	    $arr[1]=$this->$str();
	    return	$arr;
	}
	
	public function page_getrcount(){  //获取总条数
		$this->page_rcount=count($this->db_select());
	}
	
	public function page_getcount(){  //计算总页数
		$this->page_count=ceil($this->page_rcount/$this->page_size);
	}
	
	public function page_type1(){  //分页类型一
		$pre=$this->page-1;
		$nex=$this->page+1;
		$end=$this->page_count;
		return "<a href='?page=1'>home</a> <a href='?page=$pre'>pre</a> <a href='?page=$nex'>nex</a> <a href='?page=$end'>end</a>";
	}
	
	public function page_type2(){  //分页类型二
		$str="";
		for($i=1;$i<=$this->page_count;$i++){
			$str.="<a href='?page=$i'>$i</a>  ";
		}
		return $str;
	}
}