网站地图
【www.gdgbn.com--php常用代码】
这个类适用于配合数据库教程查询分页，和数组分页。下面有使用方法。
[php教程]
/*
* 名称: 分页类
* 介绍: 适用于数组分页和配合sql查询的分页
* 作者: idlion || moonfly (id_lion@hotmail.com)
* 创建时间: 2006-02-18
* 最后修改: 2007-05-24
*/
class pagebreak {
private $mtotalrowsnum = 0; // 总信息行数
private $mcurpagenumber = 1; // 当前所在页
private $mtotalpagesnum = 1; // 总页数
private $mquerystring; // 页面传递的数据(url?后的字符串)
private $mpagerowsnum = 20; // 每页显示行数
private $mindexbarlength = 5; // 索引条的页数
private $mindexbar = ""; // 页码索引条
private $mpageinfo = ""; // 分页信息
// 页码索引条样式
private $mnextbutton = "8";
private $mprebutton = "7";
private $mfirstbutton = "9";
private $mlastbutton = ":";
private $mcss教程indexbarcurpage = "font-weight:bold;color:#ff0000";
private $mcssindexbarpage = "";
// 分页信息样式
private $mcsspageinfonumfont = "color:#ff0000";
private $mcsspageinfofont = "";// 构造方法
public function __construct(&$rsqlquery, $userpagerowsnum="") {
if( !is_array($rsqlquery) ) {
$this->setdbpagebreak($rsqlquery, $userpagerowsnum);
}
else {
$this->setarraypagebreak($rsqlquery, $userpagerowsnum);
}
}// 设置数据库型分页
private function setdbpagebreak(&$rsqlquery, $userpagerowsnum="") {
$this->setdbtotalrowsnum($rsqlquery);
$this->settotalpagesnum($userpagerowsnum);
if( $this->mtotalpagesnum > 1 ) {
$this->setcurpagenumber();
$this->setsqlquery($rsqlquery);
$this->setquerystring();
$this->setindexbar();
$this->setpageinfo();
}
}// 设置数组型分页
private function setarraypagebreak(&$rarray, $userpagerowsnum="", $usertotalrowsnum="") {
$this->setarraytotalrowsnum($rarray, $usertotalrowsnum);
$this->settotalpagesnum($userpagerowsnum);
if( $this->mtotalpagesnum > 1 ) {
$this->setcurpagenumber();
$this->setarray($rarray);
$this->setquerystring();
$this->setindexbar();
$this->setpageinfo();
}
}// 数据库型计算总行数
private function setdbtotalrowsnum($rsqlquery) {
$this->mtotalrowsnum = mysql教程_num_rows( mysql_query($rsqlquery) );
}// 数组型计算总行数
private function setarraytotalrowsnum($array) {
$this->mtotalrowsnum = count($array);
}// 计算总页数
private function settotalpagesnum($userpagerowsnum="") {
if( $userpagerowsnum ) {
$this->mpagerowsnum = $userpagerowsnum;
}
$this->mtotalpagesnum = (int)( floor( ($this->mtotalrowsnum-1)/$this->mpagerowsnum )+1 );
}// 计算当前页数
private function setcurpagenumber() {
if( $_get["cur_page"] ) {
$this->mcurpagenumber = $_get["cur_page"];
}
}// 修正sql截取语句
private function setsqlquery(&$rsqlquery) {
$start_number = ($this->mcurpagenumber-1)*$this->mpagerowsnum;
$rsqlquery .= " limit ".$start_number.",".$this->mpagerowsnum;
}// 修正截取后的array
private function setarray(&$rarray) {
$start_number = ($this->mcurpagenumber-1)*$this->mpagerowsnum;
$rarray = array_slice($rarray, $start_number, $this->mpagerowsnum);
}// 修正 $_get 传递数据
private function setquerystring() {
$query_string = $_server["query_string"];
if ( $query_string == "" ) {
$this->mquerystring = "?cur_page=";
}
else {
$this->mquerystring = preg_replace("/&?cur_page=d+/", "", $query_string);
$this->mquerystring = "?".$this->mquerystring."&cur_page=";
}
}// 设置页码索引条
private function getpageindex() {
if( $this->mtotalpagesnum <= $this->mindexbarlength ) {
$first_number = 1;
$last_number = $this->mtotalpagesnum;
}
else {
$offset = (int)floor($this->mindexbarlength/2);
if( ($this->mcurpagenumber-$offset) <= 1 ) {
$first_number = 1;
}
elseif( ($this->mcurpagenumber+$offset) > $this->mtotalpagesnum ) {
$first_number = $this->mtotalpagesnum-$this->mindexbarlength+1;
}
else {
$first_number = $this->mcurpagenumber-$offset;
}
$last_number = $first_number+$this->mindexbarlength-1;
}
$last_number;
for( $i=$first_number; $i<=$last_number; $i++ ) {
if( $this->mcurpagenumber == $i ) {
$page_index .= "mcssindexbarcurpage."">".$i." ";
}
else {
$page_index .= "mquerystring.$i."" style="".$this->mcssindexbarpage."">".$i." ";
}
}
return $page_index;
}// 设置页码索引条
private function setindexbar() {
$this->mindexbar = $this->getnavfirstbutton();
$this->mindexbar .= $this->getnavprebutton();
$this->mindexbar .= $this->getpageindex();
$this->mindexbar .= $this->getnavnextbutton();
$this->mindexbar .= $this->getnavlastbutton();
}// 得到页码索引条 首页按钮
private function getnavfirstbutton() {
return "mquerystring."1">".$this->mfirstbutton." ";
}// 得到页码索引条 上一页按钮
private function getnavprebutton() {
if( $this->mcurpagenumber>1 ) {
$pre_number = $this->mcurpagenumber-1;
}
else {
$pre_number = 1;
}
return "mquerystring.$pre_number."">".$this->mprebutton." ";
}// 得到页码索引条 下一页按钮
private function getnavnextbutton() {
if( $this->mcurpagenumber<$this->mtotalpagesnum ) {
$next_number = $this->mcurpagenumber+1;
}
else {
$next_number = $this->mtotalpagesnum;
}
return "mquerystring.$next_number."">".$this->mnextbutton." ";
}// 得到页码索引条 末页按钮
private function getnavlastbutton() {
return "mquerystring.$this->mtotalpagesnum."">".$this->mlastbutton." ";
}// 设置分页信息
private function setpageinfo() {
$this->mpageinfo ="mcsspageinfofont."">";
$this->mpageinfo .= "共 mcsspageinfonumfont."">".$this->mtotalrowsnum." 条信息 | ";
$this->mpageinfo .= "mcsspageinfonumfont."">".$this->mpagerowsnum." 条/页 | ";
$this->mpageinfo .= "共 mcsspageinfonumfont."">".$this->mtotalpagesnum." 页 | ";
$this->mpageinfo .= "第 mcsspageinfonumfont."">".$this->mcurpagenumber." 页";
$this->mpageinfo .= "";
}// 取出页码索引条
public function getindexbar() {
return $this->mindexbar;
}// 取出分页信息
public function getpageinfo() {
return $this->mpageinfo;
}}
?>
[/php]
用法1: 配合数据库使用(例子中配合的是我自己的数据库操作类和模版类)
// 这是一个sql查询语句，我们来对它的查询结果作出分页
$sql = "select * from member";
// 读取分页类
require_once("pagebreak.php");
// 分页初始化
// $sql就是上面的查询语句
// 20是每页显示的数量
// 通过分页类的初始化，这个查询语句就被加上" limit ...... "
$pagebreak = new pagebreak($sql, 20);
// 生成分页索引导航条
$navbar = $pagebreak->getpageinfo().$pagebreak->getindexbar();
// 查询的结果(这里用我自己的类，不多说了)
$result = $db->getfieldsarray($sql)
// 输出查询结果
var_dump($result);
// 输出分页索引导航条
echo $navbar;
用法2: 配合要输出的数组
// 这是一个sql查询语句，并得到查询结果
$sql = "select * from member";
$result = $db->getfieldsarray($sql);
// 读取分页类
require_once("pagebreak.php");
// 分页初始化
// $result就是上面的查询后得到的结果
// 20是每页显示的数量
// 通过分页类的初始化，这个结果数组被自动截取成相应页的信息内容
$pagebreak = new pagebreak($result, 20);
// 生成分页索引导航条
$navbar = $pagebreak->getpageinfo().$pagebreak->getindexbar();
// 输出查询结果
var_dump($result);
// 输出分页索引导航条
echo $navbar;
下面是输出样式，
前半部分信息条，是$pagebreak->getpageinfo()
后半部分分页索引导航，是$pagebreak->getindexbar()