关于我们

质量为本、客户为根、勇于拼搏、务实创新

< 返回

php+pdo分页类

发布时间:2022-07-27 13:54:42

<?php
class SepPage{
var $db; //pdo实例
var $sqlStr; //数据库查询语句
var $nowPg; //当前页
var $pageSize; //每页显示的记录数

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); //总的记录数
$lastPg = ceil($recordCount/$this->pageSize); //尾页,即总的页数
$lastPg = $lastPg ? $lastPg : 1; //没有显示条目,置最后页为1
$prePg = $this->nowPg - 1;
$nextPg = (($this->nowPg == $lastPg) ? 0 : ($this->nowPg + 1));

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

$str = "共有".$name."&nbsp;".$recordCount."&nbsp;".$unit.",每页显示&nbsp;".$this->pageSize."&nbsp;".$unit.",第&nbsp;".$this->nowPg."&nbsp;页/共&nbsp;".$lastPg."&nbsp;页,";
$str .= "到第<select name='toPg' onchange='window.location="?page="+this.value'> ";
for ($i=1; $i<=$lastPg; $i++){
if ($i == $this->nowPg){
$str .= "<option value='$i' selected>$i</option> ";
}else{
$str .= "<option value='$i'>$i</option> ";
}
}
$str .= "</select>页";

$str .= "&nbsp;&nbsp;&nbsp;&nbsp;";

if ($prePg){
$str .= "<a href=".$_SERVER['PHP_SELF']."?page=1"." class=".$class.">首页</a>";
$str .= "&nbsp;";
$str .= "<a href=".$_SERVER['PHP_SELF']."?page=".$prePg." class=".$class.">上一页</a>";
$str .= "&nbsp;";
}else{
$str .= "首页";
$str .= "&nbsp;";
$str .= "上一页";
$str .= "&nbsp;";
}

if ($nextPg){
$str .= "<a href=".$_SERVER['PHP_SELF']."?page=".$nextPg." class=".$class.">下一页</a>";
$str .= "&nbsp;";
$str .= "<a href=".$_SERVER['PHP_SELF']."?page=".$lastPg." class=".$class.">尾页</a>";
$str .= "&nbsp;&nbsp;&nbsp;&nbsp;";
}else{
$str .= "下一页";
$str .= "&nbsp;";
$str .= "尾页";
$str .= "&nbsp;&nbsp;&nbsp;&nbsp;";
}
return $str;
}
}
?>


/template/Home/Dawn/PC/Static

选择风纳云,也许是您成就一番大事业的开端

注册账号