一个基于mysql库函数的自动分页类

1、新建一个PHP文件，文件名为mysqlpage_class.php，将以下代码粘贴进去。



代码如下：



<?php

/**

 * 类名: MysqlPage 

 * 作者：谢声涛 shishengsoft@gmail.com

 * 描述: 封装mysql库函数，实现了自动分页功能，类似MS ADO组件的自动分页功能。

 */

//-------------开始-----------------------------------

class MysqlPage{

 public $RecordCount = 0;    // 记录集的记录总数

 public $AutoPage = false;   // 启用自动分页功能

 public $PageSize = 0;       // 每页的记录行数

 public $CurrentPage = 0;    // 当前页

 public $Pages = 0;          // 总页数

 public $BOF = false;        // 游标到记录集之前

 public $EOF = false;        // 游标到记录集之后

 

 private $RecordSet = null;  // 记录集

 private $mLink = null;     // 数据库连接号

 private $mCurrentRow = -1;  // 记录集中当前游标位置 

 private $Rows = 0;          //总记录数



 // 连接数据库

 public function __construct($HostName, $User, $Password, $Database){

  $this->mLink = @mysql_connect($HostName,$User,$Password) or die("警告：无法连接MySQL数据库。");

  $result = @mysql_query("use $Database;",$this->mLink);

 }

 // 关闭连接

 public function Close(){

  @mysql_close($this->mLink);

  unset($this);

 }

 // 分页查询

 public function QueryEx($SqlString=''){

  // 是否启用自动分页功能

  if($this->AutoPage){

   // 检查PageSize参数

   if ($this->PageSize <=0) die("警告：PageSize不能为负数或零。");

   // 计算总记录数   

   $r = @mysql_fetch_array(mysql_query($this->rebuildSqlString($SqlString),$this->mLink)) or die("警告：无法计算总记录数。");

   $this->Rows = $r[0];

   // 计算总页数 

   if ($this->Rows < $this->PageSize) {$this->Pages = 1;}

   elseif ($this->Rows % $this->PageSize) {$this->Pages = intval($this->Rows/$this->PageSize)+1;}

   else {$this->Pages = intval($this->Rows/$this->PageSize);}

   // 约束CurrentPage值，使之位于1到Pages之间。

   if($this->CurrentPage < 1) {$this->CurrentPage =1;}

   if($this->CurrentPage > $this->Pages) {$this->CurrentPage = $this->Pages;}  

   //计算偏移量

   $Offset = $this->PageSize * ($this->CurrentPage - 1);

   // 重组SQL语句,SqlString有分号则去掉

   $SqlString = str_replace(";","",$SqlString) . " LIMIT $Offset,$this->PageSize;";

  }

  // 查询并返回记录集

  $this->RecordSet = mysql_query($SqlString,$this->mLink); 

  $this->RecordCount = @mysql_num_rows($this->RecordSet) or die("警告：查询失败。");

  if(!$this->AutoPage){$this->Pages = (!$this->RecordCount)?0:1;}

  return $this->RecordCount;

 } 

 // 取得字段值

 public function FieldValue($FieldName=""){  

  return (@mysql_result($this->RecordSet,$this->mCurrentRow,$FieldName));

 } 

 //--------移动记录集游标---------------------------------------------

 public function Move($RowPos){

  if ($RowPos<0) $RowPos = 0;

  if ($RowPos > $this->RecordCount-1) $RowPos = $this->RecordCount-1;

  $this->mCurrentRow = $RowPos;

  $this->EOF = false;

  $this->BOF = false;  

 }

 public function MoveNext(){

  if($this->mCurrentRow < $this->RecordCount-1){

   $this->mCurrentRow++;

   $this->EOF = false;

   $this->BOF = false;

  }

  else{

   $this->EOF = true;

  }

 }

 public function MovePrev(){

  if($this->mCurrentRow > 0){

   $this->mCurrentRow--;

   $this->EOF = false;

   $this->BOF = false;

  }else{

   $this->BOF = true;

  } 

 }

 public function MoveFirst(){

  $this->mCurrentRow = 0;

  $this->EOF = false;

  $this->BOF = false;

 } 

 public function MoveLast(){

  $this->mCurrentRow = $this->RecordCount-1;

  $this->EOF = false;

  $this->BOF = false;

 }

 //--------------------------------------------------

 // 用于执行插入、修改、删除等操作

 public function Execute($SqlString){

  return @mysql_query($SqlString,$this->mLink);

 }

 //-----------------私有函数-----------------------------

 // 重新构造SQL语句，如将"select * from tb2"改写为"select count(*) from tb2"，旨在提高查询效率。

 private function rebuildSqlString($SqlString){

  if(preg_match("/select[ ,./w+/*]+ from/",$SqlString,$marr)){

   $columns = preg_replace("/select|from/","",$marr[0]); 

   $columns = preg_replace("//*/","/*",$columns);

   $result = preg_replace("/$columns/"," count(*) ",$SqlString);

   return $result;

  }

 } 

 //-------------结束-----------------------------------

}

//-------------结束-----------------------------------



?> 



 



2、使用示例：



请根据自己的情况修改MySQL用户名、密码、数据库名等信息。



<?php

include_once("./mysqlpage_class.php");



$db = new MysqlPage("localhost","root","123456","mydb");

$db->Execute("set character set gbk;");



$db->AutoPage = true;

$db->PageSize = 6;

$db->CurrentPage = 4;

$db->QueryEx("select * from tb2;");



$db->MoveFirst();

while (!$db->EOF) {

 echo  $db->FieldValue("id"),"/t",$db->FieldValue("name"),"/t",$db->FieldValue("age"),"/n";

 $db->MoveNext();

}



$db->Close();



?>