php pdo分页同时支持mysql和access

access是不支持limit分页的，想同的关键，问题马上就解决了。

看注释应该很容易理解，access的分页sql从asp json 的google code上来的 

<?php/** //分页类 */class Page{ //字段属性 public $param; //分页参数 public $pagesize; //每页大小 public $sql;//当数据库为access，无效 public $conn; //设置数据库类型 public $dbtype; //当数据库为access配置项 public $tbname;//表名 public $prikey;//主键 //public $url; public function __set($name,$value){  $this->$name = $value; } //初始化 public function __construct(){  //$this->conn=new mysqli("localhost","root","147258","empirecms");  //$this->conn->set_charset('utf8'); } //销毁 public function __destruct(){ } //开始 public function getStart(){  //$param=$this->param;  $param=(isset($_GET[$this->param])) ? $_GET[$this->param] : 1;  return ($param-1) * $this->pagesize; } //生成SQL语句 //mysql public function getMysqlSql(){  return $this->sql . " limit " . $this->getStart() ."," .$this->pagesize . "";  //return "test"; } //access的查询语句,参考json asp google public function getAccessSql(){  $end_n=$this->getStart() + $this->pagesize;  if($end_n>$this->pagesize){   $accsql = "SELECT TOP ". $this->pagesize ." * FROM [" . $this->tbname . "] as a where Not Exists(Select * From (Select Top ". $this->getStart() ." * From [" . $this->tbname . "] order by [" . $this->prikey . "] DESC) b Where b.[" . $this->prikey . "]=a.[" . $this->prikey . "] ) ORDER BY a.[" . $this->prikey . "] DESC" ;  }else{   $accsql = "SELECT TOP ". $this->pagesize ." * FROM [" . $this->tbname . "] ORDER BY [" . $this->prikey . "] DESC" ;  }  return $accsql; } //获取记录 public function getRecordSet(){  switch($this->dbtype){   case "ACCESS":    $ssql=$this->getAccessSql();    break;   case "MYSQL":    $ssql=$this->getMysqlSql();    break;  }  $rs1=$this->conn->query($ssql);  return $rs1; } //获取总页数 public function getPageCount(){  return $this->getRecordCount() / $this->pagesize; } //获取总记录数 public function getRecordCount(){  $rs=$this->conn->query("select count(*) from [" .$this->tbname ."]");  $row=$rs->fetchColumn();  return $row; } //获取分页导航 public function getPageTool(){  $pagecount= round($this->getPageCount());  $param=(isset($_GET[$this->param])) ? $_GET[$this->param] : 1;  if($param<=1){   echo "首页 上一页 ";  }else{   echo "<a href='?".$this->param."=1'>首页</a> <a href='?".$this->param."=".($param-1)."'>上一页</A> ";  }  if($param>=$pagecount){   echo "下一页 尾页";  }else{   echo "<A href='?".$this->param."=".($param+1)."'>下一页</A> <A href='?".$this->param."=".$pagecount."'>尾页</A>";  } }}?>