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>" "</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>以上就介绍了 PHP实现数据库的分页类，包括了方面的内容，希望对PHP教程有兴趣的朋友有所帮助。
