Home > Backend Development > PHP Tutorial > PHP implements database paging class

PHP implements database paging class

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-07-28 08:28:10
Original
1405 people have browsed it

PHP implements the paging class of the database

Recently implemented a product management project, which can output paging of product data.
Therefore, a paging class operation is implemented, the specific code is as follows:

<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>
Copy after login
').addClass('pre-numbering').hide(); $(this).addClass('has-numbering').parent().append($numbering); for (i = 1; i ').text(i)); }; $numbering.fadeIn(1700); }); });

The above has introduced the paging class of the PHP implementation of the database, including aspects of the content. I hope it will be helpful to friends who are interested in PHP tutorials.

Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
Why is this ID written like this?
From 1970-01-01 08:00:00
0
0
0
Small question about $this
From 1970-01-01 08:00:00
0
0
0
javascript - es6中this
From 1970-01-01 08:00:00
0
0
0
This file demo.mp4
From 1970-01-01 08:00:00
0
0
0
What's the use of this?
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template