php+pdo实现分页类代码

<?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;

$str .= "，第<select name='toPg' onchange='window.location=\"?page=\"+this.value'>\n";

for ($i=1; $i<=$lastPg; $i++){

if ($i == $this->nowPg){

$str .= "<option value='$i' selected>$i</option>\n";

}else{

$str .= "<option value='$i'>$i</option>\n";

}

}

$str .= "</select>页/共&nbsp;".$lastPg."&nbsp;页";

$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;

}

}

?>

PDO：

$dsn = 'mysql:host=localhost;dbname=db_wym';

$user = 'root';

$pwd = 'root';

try{

$db = new PDO($dsn, $user, $pwd, array(PDO::ATTR_PERSISTENT => true));

$db->exec('set names utf8');

}catch (PDOException $e){

echo "Error message:".$e->getMessage();

die();

}