php新分页代码

<?php
    /*
    * 文件名：datagridclass.php
    * 作者：感染源
    * 时间：2007-07-25
    * 描述：分页类
    */
error_reporting(0);
class datagridclass
{
    private $conn;
    private $result;
    private $resultArr = array();
    
    public $beginrecord = 0;
    public $totalrecords = 0;
    public $totalpages = 0;
    public $currentpage = 0;
    public $maxline = 0;
    public $maxlist = 0;
    
    
    function __construct($pHost, $pName, $pPwd, $pDbName, $pMaxLine = 15, $pMaxList = 8)
    {
        $this->conn = mysql_connect($pHost, $pName, $pPwd) or die('DataBase connecting false...');
        mysql_select_db($pDbName, $this->conn) or die('Choice database false...');
        
        $this->maxline = $pMaxLine;
        $this->maxlist = $pMaxList;
    }//function __construct();
    
    
    function __set($property_name, $value)
    {
        $this->$property_name = $value;
    }//function __set();
    
    
    function __destruct()
    {
        mysql_free_result($this->result);
        mysql_close($this->conn);
    }//function __destruct();
    
    
    function readdata($pSql)
    {
        $this->result = mysql_query($pSql, $this->conn) or die('Select false...');
        $this->totalrecords = mysql_num_rows($this->result);
        if (!$this->totalrecords)
        {
            return false;
        }
        else 
        {
            $this->totalpages   = ceil($this->totalrecords / $this->maxline);
            $pSql .= ' LIMIT '.$this->beginrecord.','.$this->maxline;
            $this->result = mysql_query($pSql, $this->conn) or die('Select false...');
            
            $i = 0;
            while ($row = mysql_fetch_array($this->result))
            {
                $this->resultArr[$i] = $row;
                $i++;
            }//while
        }//if
        
        return $this->resultArr;
    }//function readdata();
    
    
    function navigate()
    {
        if ($this->totalrecords)
        {
            $this->currentpage = ($this->beginrecord / $this->maxline) + 1;
            
            $firstpage    = 0;
            $prevpage    = $this->beginrecord - $this->maxline;
            $nextpage    = $this->beginrecord + $this->maxline;
            $lastpage    = ($this->totalpages - 1)*$this->maxline;
            
            if ($this->beginrecord == 0)
            {
                echo '[首页]&nbsp;[上一页]&nbsp;';
            }
            else 
            {
                echo "<a href='".$_SERVER['PHP_SELF']."?beginrecord=$firstpage'>[首页]</a>&nbsp;";
                echo "<a href='".$_SERVER['PHP_SELF']."?beginrecord=$prevpage'>[上一页]</a>&nbsp;";
            }
            
            if ($this->currentpage <= $this->maxlist)
            {
                for ($i=1; $i<=$this->maxlist; $i++)
                {
                    $pagerecord = ($i - 1)*$this->maxline;
                    if ($this->currentpage == $i)
                    {
                        echo "<a href='".$_SERVER['PHP_SELF']."?beginrecord=$pagerecord'>[$i]</a>&nbsp;";
                    }
                    else 
                    {
                        echo "<a href='".$_SERVER['PHP_SELF']."?beginrecord=$pagerecord'>$i</a>&nbsp;";
                    }//if
                }//for
            }
            elseif ($this->currentpage > ($this->totalpages-$this->maxlist))
            {
                for ($i=($this->maxlist); $i>0; $i--)
                {
                    $pagerecord = ($this->totalpages - $i)*$this->maxline;
                    if ($this->currentpage == ($this->totalpages-$i+1))
                    {
                        echo "<a href='".$_SERVER['PHP_SELF']."?beginrecord=$pagerecord'>[".($this->totalpages - $i +1)."]</a>&nbsp;";
                    }
                    else 
                    {
                        echo "<a href='".$_SERVER['PHP_SELF']."?beginrecord=$pagerecord'>".($this->totalpages - $i+1)."</a>&nbsp;";
                    }//if
                }//for
            }
            else 
            {
                $j = ceil($this->maxlist / 2);
                for ($i = $j; $i>=0; $i--)
                {
                    if ($this->currentpage == ($this->currentpage-$i))
                    {
                        echo "<a href='".$_SERVER['PHP_SELF']."?beginrecord=".(($this->currentpage-$i-1)*$this->maxline)."'>[".($this->currentpage-$i)."]</a>&nbsp;";
                    }
                    else 
                    {
                        echo "<a href='".$_SERVER['PHP_SELF']."?beginrecord=".(($this->currentpage-$i-1)*$this->maxline)."'>".($this->currentpage-$i)."</a>&nbsp;";
                    }
                }
                for ($i = 1; $i<=$j; $i++)
                {
                    echo "<a href='".$_SERVER['PHP_SELF'].'?beginrecord='.(($this->currentpage+$i-1)*$this->maxline)."'>".($this->currentpage+$i)."</a>&nbsp;";
                }
            }
            
            if ($this->beginrecord == $lastpage)
            {
                echo '[下一页]&nbsp;[末页]';
            }
            else 
            {
                echo "<a href='".$_SERVER['PHP_SELF']."?beginrecord=$nextpage'>[下一页]</a>&nbsp;";
                echo "<a href='".$_SERVER['PHP_SELF']."?beginrecord=$lastpage'>[末页]</a>";
            }
        //echo "$this->currentpage / $this->totalpages,共有记录数：$this->totalrecords";
        }
    }
}


/*/test
$dg = new datagridclass('localhost','root','root','test',2,5);
if (isset($_GET['beginrecord']))
{
    $dg->__set('beginrecord', $_GET['beginrecord']);
}
else 
{
    $dg->__set('beginrecord', 0);
}
$rs = $dg->readdata('select * from testuser');
if(!$rs)
{
    echo '暂无数据……';
}
else 
{
    $i=0;
    echo "<table width='40%' border='1'>";
    echo "<tr><td>id</td><td>name</td></tr>";
    while($i<count($rs))
    {
        echo "<tr><td>";
        echo $rs[$i]['id'];
        echo "</td><td>".$rs[$i]['uname'];
        echo "</td></tr>";
        $i++;
    }
    echo "</tale>";
}
$dg->navigate();
$dg = NULL;
*/
?>