Maison >développement back-end >tutoriel php >PHP实现数据库的分页类

PHP实现数据库的分页类

WBOY
WBOYoriginal
2016-07-28 08:28:101356parcourir

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>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>/a<span>></span><span>";
        else
            $str.="</span><span>font color<span>=</span><span>'#555555'</span><span>></span>首页<span>/font<span>></span><span>";
        $str.="</span><span>&</span>nbsp<span>";

        if(!$this->rs->AtLastPage())
            $str.="</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>">
            下一页"</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>%24_SERVER</span><span>%5B</span><span>'PHP_SELF'</span><span>%5D</span><span>." 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></span></span></span></span></span></code>
').addClass('pre-numbering').hide(); $(this).addClass('has-numbering').parent().append($numbering); for (i = 1; i ').text(i)); }; $numbering.fadeIn(1700); }); });

以上就介绍了 PHP实现数据库的分页类,包括了方面的内容,希望对PHP教程有兴趣的朋友有所帮助。

Déclaration:
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn
Article précédent:PHP current 函数Article suivant:linux多进程可伸缩模型探索