class SepPage{
var $db; //pdo實(shí)例
var $sqlStr; //數(shù)據(jù)庫(kù)查詢語(yǔ)句
var $nowPg; //當(dāng)前頁(yè)
var $pageSize; //每頁(yè)顯示的記錄數(shù)

function ShowPage($db, $sqlStr, $pageSize, $nowPg){
$this->db = $db;
$this->sqlStr = $sqlStr;
$this->pageSize = $pageSize;
if (!isset($nowPg) || ($nowPg == '') || ($nowPg == 0)){
$nowPg = 1;
}
$this->nowPg = $nowPg;
$start = $pageSize * ($nowPg - 1);
$sqlStr .= " limit ".$start." , ".$pageSize;
$rst = $db->query($sqlStr);
if ($db->errorCode() != '00000'){
print_r($db->errorInfo());
exit();
}
$rstArr = $rst->fetchAll();
return $rstArr;
}

function PageNav($name, $unit, $class){
$rst = $this->db->query($this->sqlStr);
if ($this->db->errorCode() != '00000'){
print_r($this->db->errorInfo());
exit();
}
$rstArr = $rst->fetchAll();
$recordCount = count($rstArr); //總的記錄數(shù)
$lastPg = ceil($recordCount/$this->pageSize); //尾頁(yè)，即總的頁(yè)數(shù)
$lastPg = $lastPg ? $lastPg : 1; //沒(méi)有顯示條目，置最后頁(yè)為1
$prePg = $this->nowPg - 1;
$nextPg = (($this->nowPg == $lastPg) ? 0 : ($this->nowPg + 1));

if ($lastPg <= 1){
return false;
}

$str = "共有".$name." ".$recordCount." ".$unit."，每頁(yè)顯示 ".$this->pageSize." ".$unit."，第 ".$this->nowPg." 頁(yè)/共 ".$lastPg." 頁(yè)，";
$str .= "到第 ";
for ($i=1; $i<=$lastPg; $i++){
if ($i == $this->nowPg){
$str .= "$i ";
}else{
$str .= "$i ";
}
}
$str .= "頁(yè)";

$str .= "    ";

if ($prePg){
$str .= "首頁(yè)";
$str .= " ";
$str .= "上一頁(yè)";
$str .= " ";
}else{
$str .= "首頁(yè)";
$str .= " ";
$str .= "上一頁(yè)";
$str .= " ";
}

if ($nextPg){
$str .= "下一頁(yè)";
$str .= " ";
$str .= "尾頁(yè)";
$str .= "    ";
}else{
$str .= "下一頁(yè)";
$str .= " ";
$str .= "尾頁(yè)";
$str .= "    ";
}
return $str;
}
}
?>

在弋江等地區(qū)，都構(gòu)建了全面的區(qū)域性戰(zhàn)略布局，加強(qiáng)發(fā)展的系統(tǒng)性、市場(chǎng)前瞻性、產(chǎn)品創(chuàng)新能力，以專注、極致的服務(wù)理念，為客戶提供網(wǎng)站設(shè)計(jì)制作、成都網(wǎng)站設(shè)計(jì) 網(wǎng)站設(shè)計(jì)制作按需網(wǎng)站策劃,公司網(wǎng)站建設(shè),企業(yè)網(wǎng)站建設(shè),品牌網(wǎng)站制作,成都全網(wǎng)營(yíng)銷,外貿(mào)營(yíng)銷網(wǎng)站建設(shè),弋江網(wǎng)站建設(shè)費(fèi)用合理。
當(dāng)前文章：php+pdo分頁(yè)類-創(chuàng)新互聯(lián)
鏈接分享：http://weahome.cn/article/jdidi.html