我的一个php_mysql分页类

答案：class RSPage {
  var $Debug    =  0;
  var $sqoe     =  1; // sqoe= show query on error
  var $Link_ID    = 0;
  var $Record    = array();
  var $Row;
  var $numRow;
  var $Parse;
  var $Error     = "";
  var $m_timeFmt = "YYYY-MM-DD HH24:MI:SS";

    var $m_num=-1;
    var $m_sql; 
    var $m_pageSize=10;
    var $m_cmt;
    var    $m_curPage=1;
    function open($DB_Link)
    {
        $this->Link_ID = $DB_Link;
    }

    function query($Query_String,$page=1,$cnt=-1,$size=10) {
      if($Query_String=="")
      {
          echo "执行语句不能为空！";
          return false;
      }
        if(!$page)
            $page = 1;
        if(!$cnt)
            $cnt = -1;
        $this->m_pageSize = $size;

      if($this->Parse){
          mysql_free_result($this->Parse);
      }

        if($cnt!=-1){
            $this->m_num = $cnt;
        }
        else{
            $result = mysql_query($Query_String, $this->Link_ID);
            if(!$result){
                $this->Error=mysql_error($this->Link_ID);
            }
            else{
                $this->m_num = mysql_num_rows($result);
            }
            /*
            $cntsql = "select count(*) max_num from ($Query_String)";
            $maxnum = 0;
            $result = mysql_query($sqlstr,$this->Link_ID);
            $ret = mysql_fetch_array($result);
            mysql_free_result($result);
            if(!$ret) {
                $this->Error=mysql_error($this->Link_ID);
            } 
            else {
                $this->m_num = $ret["max_num"];
            }
            */
            
        }
        $pageCount = $this->getPageCount();
        $pageSize = $this->getPageSize();
        if($page>$pageCount)$page=$pageCount;
        if($page<1)$page=1;
        $this->m_curPage=$page;
        $posBegin = ($page-1)*$pageSize;
        $posEnd = $posBegin + $pageSize;
        $Query_String = "$Query_String LIMIT $posBegin,$posEnd";
        $this->Parse=mysql_query($Query_String,$this->Link_ID);

      if(!$this->Parse) {
           $this->Error=mysql_error($this->Link_ID);
      }
      $this->Row=0;

      if($this->Debug) {
          printf("Debug: query = %s<br>\n", $Query_String);
      }

      if ($this->Error && $this->sqoe)
      echo "<BR><FONT color=red><B>".$this->Error["message"]."<BR>Query :\"$Query_String\"</B></FONT>";
      $numRow=mysql_num_rows($this->Parse);
      return $this->Parse;
  }
  function setTimeFormat($timestr){
    $this->m_timeFmt = $timestr;
  }
  function next_record() {
      if(!($row = mysql_fetch_array($this->Parse))) {
          mysql_free_result($this->Parse);
          $this->Parse = false;
          $stat=0;
      } 
      else {
          while(list($key,$val)=each($row)) {
              $colreturn=strtolower($key);
              $this->Record[ "$colreturn" ] = $val;
              if($this->Debug) echo"<b>[$key]</b>:".$val."<br>\n";
          }
          $stat=1;
      }

    return $stat;
  }
  
  function record_exist() {
    if(0 == mysql_num_rows($this->Parse)) {
                return 0;
          } else {
              &

上一个：将MySQL迁移到Microsoft SQL Server 2000 (二)
下一个：将MySQL迁移到Microsoft SQL Server 2000 (一)