PHP實作資料庫的分頁類

PHP實作資料庫的分頁類別

最近在實作一個商品的管理專案,對商品的資料能進行分頁的輸出.
因此,實作了一個分頁類別運算,具體程式碼如下:

<code>class SepPage{
    <span>var</span><span>$rs</span>;
    <span>var</span><span>$pagesize</span>;
    <span>var</span><span>$nowpage</span>;
    <span>var</span><span>$array</span>;
    <span>var</span><span>$conn</span>;
    <span>var</span><span>$sqlarr</span>;
    function ShowData(<span>$sqlarr</span>,<span>$conn</span>,<span>$pagesize</span>,<span>$nowpage</span>){ <span>//定义方法</span><span>if</span>(<span>!</span>isset(<span>$nowpage</span>)<span>||</span><span>$nowpage</span><span>==</span><span>""</span>) <span>//判断变量值是否为空</span><span>$this</span><span>-></span>nowpage<span>=</span><span>1</span>;
        <span>else</span><span>$this</span><span>-></span>nowpage<span>=</span><span>$nowpage</span>;
        <span>$this</span><span>-></span>pagesize<span>=</span><span>$pagesize</span>;<span>//定义每页输出的记录数</span><span>$this</span><span>-></span>conn<span>=</span><span>$conn</span>;<span>//链接数据库返回的标识</span><span>$this</span><span>-></span>sqlstr<span>=</span><span>$strsql</span>;<span>//执行查询语句</span><span>$this</span><span>-></span>rs<span>=</span><span>$this</span><span>-></span>conn<span>-></span>PageExecute(<span>$this</span><span>-></span>sqlstr,<span>$this</span><span>-></span>pagesize,<span>$this</span><span>-></span>nowpage);
        @this<span>-></span><span>array</span><span>=</span><span>$this</span><span>-></span>rs<span>-></span>GetRows();<span>//获取记录数</span><span>if</span>(count(<span>$this</span><span>-></span><span>array</span>)<span>==</span><span>0</span><span>||</span><span>$this</span><span>-></span>rs<span>==</span><span>false</span>)
            <span>return</span><span>false</span>;
        <span>else</span><span>return</span><span>$this</span><span>-></span><span>array</span>;
    }
    function ShowPage(<span>$contentname</span>,<span>$utits</span>,<span>$anothersearchstr</span>,<span>$anothersearchstrs</span>,<span>$class</span>){
        <span>$allrs</span><span>=</span><span>$this</span><span>-></span>conn<span>-></span>Execute(<span>$this</span><span>-></span>sqlstr);<span>//执行查询语句</span><span>$record</span><span>=</span>count(<span>$allrs</span><span>-></span>GetRows());<span>//统计记录总数</span><span>$pagecount</span><span>=</span>ceil(<span>$record</span><span>/</span><span>$this</span><span>-></span>pagesize);<span>//计算共有几页</span><span>$str.</span><span>=</span><span>$contentname.</span><span>" "</span><span>.</span><span>$record.</span><span>"&
        nbsp;"</span><span>.</span><span>$utits.</span><span>" "</span>每
        页<span>&</span>nbsp;<span>".$this->pagesize."</span><span>&</span>nbsp;<span>".$utits."</span><span>&</span>nbsp;
        第<span>&</span>nbsp;<span>".$this->rs->AbsolutePage()."</span><span>&</span>nbsp;页<span>/</span>
        共<span>&</span>nbsp;<span>".$pagecount."</span><span>&</span>nbsp;页<span>";
        $str.="</span><span>&</span>nbsp;<span>&</span>nbsp;<span>&</span>nbsp;<span>&</span>nbsp;<span>";
        if(!$this->rs->AtFirstPage())
            $str.="</span><span><</span>a href<span>=</span><span>".$_SERVER['PHP_SELF']."</span><span>?</span>page<span>=</span><span>1</span><span>&</span>
            parameter1<span>=</span><span>".$anothersearchstr."</span><span>&</span>
            parameter2<span>=</span><span>".anothersearchsstrs."</span>class<span>=</span><span>".$class."</span><span>></span>
            首页<span><</span>/a<span>></span><span>";
        else
            $str.="</span><span><</span>font color<span>=</span><span>'#555555'</span><span>></span>首页<span><</span>/font<span>></span><span>";
        $str.="</span><span>&</span>nbsp<span>";

        if(!$this->rs->AtLastPage())
            $str.="</span><span><</span>a href<span>=</span><span>".$_SERVER['PHP_SELF']."</span><span>?</span>page<span>=</span>
            (<span>$this</span><span>-></span>rs<span>-></span>AbsolutePage()<span>+</span><span>1</span>)<span>.</span><span>"&
            parameter1="</span><span>.</span><span>$anothersearchstr.</span><span>"&
            parameter2="</span><span>.</span>anothersearchsstrs<span>.</span><span>"class="</span><span>.</span><span>$class.</span><span>">
            下一页</a>"</span>;
        <span>else</span><span>$str.</span><span>=</span><span>"<font color='#555555'>下一页</font>"</span>;
        <span>$str.</span><span>=</span><span>"&nbsp"</span>;

        <span>if</span>(<span>!</span><span>$this</span><span>-></span>rs<span>-></span>AtLastPage())
            <span>$str.</span><span>=</span><span>"<a 
            href="</span><span>.</span><span>$_SERVER</span><span>[</span><span>'PHP_SELF'</span><span>]</span><span>."?page=".$pagecount."&

            parameter1=".$anothersearchstr."&
            parameter2=".anothersearchsstrs."class=".$class.">
            尾页</a>";
        else
            $str.="<font color='#555555'>尾页</font>";
        if(count($this->array)==0 || $this->rs==false)
            return "";
        else
            return $str;

    }

}</span></code>

').addClass('pre-numbering').hide(); $(this).addClass('has-numbering').parent().append($numbering); for (i = 1; i ').text(i)); }; $numbering.fadeIn(1700); }); });

以上就介紹了 PHP實作資料庫的分頁類，包括了方面的內容，希望對PHP教學有興趣的朋友有幫助。