Nice php+mysql paging class-PHP Tutorial-php.cn

Nice php+mysql paging class

WBOY

Release： 2016-07-25 08:52:45

Original

788 people have browsed it

/*****************************
* @Class name: page
* @Parameter: $myde_total - Total number of records
* $myde_size - The number of records displayed on one page
* $myde_page - the current page
* $myde_url - get the current url
* @Function: paging implementation
* @Author: Song Haige
*/
class page {
private $myde_total; //Total number of records
private $myde_size; //Number of records displayed on one page
private $myde_page; //Current page
private $myde_page_count; //Total number of pages
private $myde_i; //Number of starting pages
private $myde_en; //Number of ending pages
private $myde_url; //Get the current url
/*
* $show_pages
* The format of page display, the number of pages showing links is 2*$show_pages+1.
* 如$show_pages=2那么页面上显示就是[首页] [上页] 1 2 3 4 5 [下页] [尾页]
*/
private $show_pages;
public function __construct($myde_total=1,$myde_size=1,$myde_page=1,$myde_url,$show_pages=2){
$this->myde_total = $this->numeric($myde_total);
$this->myde_size = $this->numeric($myde_size);
$this->myde_page = $this->numeric($myde_page);
$this->myde_page_count = ceil($this->myde_total/$this->myde_size);
$this->myde_url = $myde_url;
if($this->myde_total<0) $this->myde_total=0;
if($this->myde_page<1) $this->myde_page=1;
if($this->myde_page_count<1) $this->myde_page_count=1;
if($this->myde_page>$this->myde_page_count) $this->myde_page=$this->myde_page_count;
$this->limit = ($this->myde_page-1)*$this->myde_size;
$this->myde_i=$this->myde_page-$show_pages;
$this->myde_en=$this->myde_page+$show_pages;
if($this->myde_i<1){
$this->myde_en=$this->myde_en+(1-$this->myde_i);
$this->myde_i=1;
}
if($this->myde_en>$this->myde_page_count){
$this->myde_i = $this->myde_i-($this->myde_en-$this->myde_page_count);
$this->myde_en=$this->myde_page_count;
}
if($this->myde_i<1)$this->myde_i=1;
}
//检测是否为数字
private function numeric($num){
if(strlen($num)){
if(!preg_match("/^[0-9]+$/",$num)){
$num=1;
}else{
$num = substr($num,0,11);
}
}else{
$num=1;
}
return $num;
}
//地址替换
private function page_replace($page){
return str_replace("{page}",$page,$this->myde_url);
}
//首页
private function myde_home(){
if($this->myde_page!=1){
return "page_replace(1)."" title="首页">首页";
}else{
return "
首页
";
}
}
//上一页
private function myde_prev(){
if($this->myde_page!=1){
return "page_replace($this->myde_page-1)."" title="上一页">上一页";
}else{
return "
上一页
";
}
}
//下一页
private function myde_next(){
if($this->myde_page!=$this->myde_page_count){
return "page_replace($this->myde_page+1)."" title="下一页">下一页";
}else{
return"
下一页
";
}
}
//尾页
private function myde_last(){
if($this->myde_page!=$this->myde_page_count){
return "page_replace($this->myde_page_count)."" title="尾页">尾页";
}else{
return "
尾页
";
}
}
//输出
public function myde_write($id='page'){
$str ="
";
$str.=$this->myde_home();
$str.=$this->myde_prev();
if($this->myde_i>1){
$str.="
...
";
}
for($i=$this->myde_i;$i<=$this->myde_en;$i++){
if($i==$this->myde_page){
$str.="page_replace($i)."" title="第".$i."页" class="cur">$i";
}else{
$str.="page_replace($i)."" title="第".$i."页">$i";
}
}
if( $this->myde_en<$this->myde_page_count ){
$str.="
...
";
}
$str.=$this->myde_next();
$str.=$this->myde_last();
$str.="
共".$this->myde_page_count.

"页".$this->myde_total."条数据
";
$str.="

return $str;

}

复制代码

php+mysql paging principle: limit ($curpage-1)*$showrow,$showrow

2, php display page code

require_once('./page.class.php'); //Paging class
$showrow = 3;//Number of rows displayed on one page
$curpage = empty($_GET ['page'])?1:$_GET['page'];//The current page should also handle non-numeric situations
$url = "?page={page}";//Paging address, if any Retrieval condition="?page={page}&q=".$_GET['q']
//The code linking mysql is omitted, add it yourself during testing
$sql = "SELECT * FROM table";
$query = mysql_query($sql);
$total = mysql_num_rows($query);//Total number of records
if(!empty($_GET['page']) && $total !=0 && $curpage > ceil($ total/$showrow))
$curpage = ceil($total_rows/$showrow);//The current page number is greater than the last page number, take the last page
//Get the data
$get_data = "select * from table limit ". ($curpage-1)*$showrow.",$showrow;";
...
?>
Simple and universal PHP paging class-bbs.it-home.org
< ;body>