PHP 学习 分页类

本文介绍了一种使用PHP实现的简单分页查询方法。通过自定义分页类Page,可以轻松地对数据库中的大量数据进行分页展示。该方法包括获取当前页数、设置SQL查询限制、生成页面导航链接等功能。

<?php
header("Content-Type:text/html;charset=utf-8");
include "page.class.php";

$link=mysql_connect("localhost", "root", "123456");


mysql_select_db("xsphpdb");




$result=mysql_query("select * from shops");




$total=mysql_num_rows($result);


$num=5;

$page=new Page($total, $num, "&cid=99");


$sql="select * from shops {$page->limit}";


$result=mysql_query($sql);


echo '<table align="center" border="1" width="960">';
echo '<caption><h1>SHOPS</h1></caption>';


while($row=mysql_fetch_assoc($result)){
echo '<tr>';
echo '<td>'.$row["id"].'</td>';
echo '<td>'.$row["name"].'</td>';
echo '<td>'.$row["price"].'</td>';
echo '<td>'.$row["num"].'</td>';
echo '<td>'.$row["desn"].'</td>';
echo '</tr>';
}


echo '<tr><td colspan="5" align="right">'.$page->fpage(array(8,3,4,5,6,7,0,1,2)).'</td></tr>';
echo '</table>';



===========================================

<?php

class Page {
private $total; //数据表中总记录数
private $listRows; //每页显示行数
private $limit;
private $uri;
private $pageNum; //页数
private $config=array('header'=>"个记录", "prev"=>"上一页", "next"=>"下一页", "first"=>"首 页", "last"=>"尾 页");
private $listNum=8;
/*
* $total 
* $listRows
*/
public function __construct($total, $listRows=10, $pa=""){
$this->total=$total;
$this->listRows=$listRows;
$this->uri=$this->getUri($pa);
$this->page=!empty($_GET["page"]) ? $_GET["page"] : 1;
$this->pageNum=ceil($this->total/$this->listRows);
$this->limit=$this->setLimit();
}


private function setLimit(){
return "Limit ".($this->page-1)*$this->listRows.", {$this->listRows}";
}


private function getUri($pa){
$url=$_SERVER["REQUEST_URI"].(strpos($_SERVER["REQUEST_URI"], '?')?'':"?").$pa;
echo $url;
$parse=parse_url($url);





if(isset($parse["query"])){
parse_str($parse['query'],$params);
unset($params["page"]);
$url=$parse['path'].'?'.http_build_query($params);

}


return $url;
}


private function __get($args){
if($args=="limit")
return $this->limit;
else
return null;
}


private function start(){
if($this->total==0)
return 0;
else
return ($this->page-1)*$this->listRows+1;
}


private function end(){
return min($this->page*$this->listRows,$this->total);
}


private function first(){
if($this->page==1)
$html.='';
else
$html.="&nbsp;&nbsp;<a href='{$this->uri}&page=1'>{$this->config["first"]}</a>&nbsp;&nbsp;";


return $html;
}


private function prev(){
if($this->page==1)
$html.='';
else
$html.="&nbsp;&nbsp;<a href='{$this->uri}&page=".($this->page-1)."'>{$this->config["prev"]}</a>&nbsp;&nbsp;";


return $html;
}


private function pageList(){
$linkPage="";

$inum=floor($this->listNum/2);

for($i=$inum; $i>=1; $i--){
$page=$this->page-$i;


if($page<1)
continue;


$linkPage.="&nbsp;<a href='{$this->uri}&page={$page}'>{$page}</a>&nbsp;";


}

$linkPage.="&nbsp;{$this->page}&nbsp;";



for($i=1; $i<=$inum; $i++){
$page=$this->page+$i;
if($page<=$this->pageNum)
$linkPage.="&nbsp;<a href='{$this->uri}&page={$page}'>{$page}</a>&nbsp;";
else
break;
}


return $linkPage;
}


private function next(){
if($this->page==$this->pageNum)
$html.='';
else
$html.="&nbsp;&nbsp;<a href='{$this->uri}&page=".($this->page+1)."'>{$this->config["next"]}</a>&nbsp;&nbsp;";


return $html;
}


private function last(){
if($this->page==$this->pageNum)
$html.='';
else
$html.="&nbsp;&nbsp;<a href='{$this->uri}&page=".($this->pageNum)."'>{$this->config["last"]}</a>&nbsp;&nbsp;";


return $html;
}


private function goPage(){
return '&nbsp;&nbsp;<input type="text" onkeydown="javascript:if(event.keyCode==13){var page=(this.value>'.$this->pageNum.')?'.$this->pageNum.':this.value;location=\''.$this->uri.'&page=\'+page+\'\'}" value="'.$this->page.'" style="width:25px"><input type="button" value="GO" onclick="javascript:var page=(this.previousSibling.value>'.$this->pageNum.')?'.$this->pageNum.':this.previousSibling.value;location=\''.$this->uri.'&page=\'+page+\'\'">&nbsp;&nbsp;';
}
function fpage($display=array(0,1,2,3,4,5,6,7,8)){
$html[0]="&nbsp;&nbsp;共有<b>{$this->total}</b>{$this->config["header"]}&nbsp;&nbsp;";
$html[1]="&nbsp;&nbsp;每页显示<b>".($this->end()-$this->start()+1)."</b>条,本页<b>{$this->start()}-{$this->end()}</b>条&nbsp;&nbsp;";
$html[2]="&nbsp;&nbsp;<b>{$this->page}/{$this->pageNum}</b>页&nbsp;&nbsp;";

$html[3]=$this->first();
$html[4]=$this->prev();
$html[5]=$this->pageList();
$html[6]=$this->next();
$html[7]=$this->last();
$html[8]=$this->goPage();
$fpage='';
foreach($display as $index){
$fpage.=$html[$index];
}


return $fpage;


}



}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值