PHP通用分页类

最新推荐文章于 2022-05-23 15:08:49 发布

IT回忆录

最新推荐文章于 2022-05-23 15:08:49 发布

阅读量5.1k

点赞数

分类专栏： PHP

本文链接：https://blog.csdn.net/vs2008ASPNET/article/details/8248641

版权

PHP 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

大多数程序都会用到分页这一功能，所以为了以后方便花了近一个小时封装了一个通用的PHP分页类。

<?php
	require_once "../PublicService/WebHelper.class.php";
?>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>测试</title>
<style type="text/css">
#diva a{ width:10px;height:10px; padding:10px;}

</style>
</head>
<body>
<div>
<a href="/php1/UI/empMain.php?loginid=<?php echo $name ?>">返回首页</a>
</div>
<table border="1" bordercolor="green" >
<tr>
<td>ID号</td>
<td>登录名</td>
<td>姓名</td>
<td>邮箱</td>
<td>操作</td>
</tr>
<?php 
		//创建分页类的对象实例(获得总记录数的SQL语句，生成的连接地址，每页显示行数，翻页索引数)
		$fenYe=new FenYe("select count(id) from users","/php1/UI/emplist.php",10,10);
		//定制显示(这里可以设置超链接的文字)
		$fenYe->setPageup_txt("上翻页*");
		$fenYe->setNextpage_txt("下翻页*");
		$fenYe->setFirstpage_txt("第一页*");
		$fenYe->setEndpage_txt("最后一页*");
		//传入分页SQL语句(getStrat()为占位符，内部生成替换的索引)
		$fenYe->fenye("select * from users limit {$fenYe->getStart()},{$fenYe->getEnd()}");
		//获得分页数据(关联数组)
		$arr=$fenYe->getData();
		for($i=0;$i<count($arr);$i++){
			echo "<tr><td>{$arr[$i]["id"]}</td><td>{$arr[$i]["loginid"]}</td><td>{$arr[$i]["name"]}</td><td>{$arr[$i]["email"]}</td><td><a herf='#'>其他操作</a>||<a href='#'>其他操作</a></td>";
		}
?>
</table>
<br/>
<span>
<?php  
echo $fenYe->getFristpage(); //第一页
?>
<<<
<?php 
	//上翻页   分页连接1,2,3,4   下翻页
	echo $fenYe->getPageup()."<div id='diva'>".$fenYe->getNavigation_bar()."</div>".$fenYe->getNextpage();
?>
>>>
<?php 
//最后一页
 echo $fenYe->getEndpage()
 
 ?>
<?php 
	echo "{当前:{$fenYe->getPagenow()},共:{$fenYe->getPagecount()}页}";
?>
</span>
</body>
</html>

一下是分页源代码：

class FenYe{
			private $pagecount;//总页数
			private $pagesize=10;//每页显示的记录数
			private $pagenow=1;//当前页
			private $pageindexcount;//总索引数
			private $pageindex=1;//当前索引页
			private $pageindexsize=10;//每页显示索引数
			private $navigation_bar;//导航条
			private $data;//数据
			private $sqlhelper;//数据库连接
			private $pagenowid="pagenow";//当前页url参数名
			private $pageindexid="pageindex";//当前索引页url参数名
			private $data_sql;//查询数据的SQL语句
			private $start="@start";//SQL语句limit占位符
			private $end="@end";//SQL语句limit占位符
			private $url;//连接的地址
			private $pageup;//上翻页连接
			private $nextpage;//下翻页连接
			private $fristpage;//第一页
			private $endpage;//最后一页
			
			private $pageup_txt="上翻页";//上翻页显示文本
			private $nextpage_txt="下翻页";//下翻页显示文本
			private $firstpage_txt="第一页";//第一页显示文本
			private $endpage_txt="最后一页";//最后一页显示文本
			
			/**
	 * @return the $pageup_txt
	 */
	public function getPageup_txt() {
		return $this->pageup_txt;
	}

			/**
	 * @return the $nextpage_txt
	 */
	public function getNextpage_txt() {
		return $this->nextpage_txt;
	}

			/**
	 * @return the $firstpage_txt
	 */
	public function getFirstpage_txt() {
		return $this->firstpage_txt;
	}

			/**
	 * @return the $endpage_txt
	 */
	public function getEndpage_txt() {
		return $this->endpage_txt;
	}

			/**
	 * @param field_type $pageup_txt
	 */
	public function setPageup_txt($pageup_txt) {
		$this->pageup_txt = $pageup_txt;
	}

			/**
	 * @param field_type $nextpage_txt
	 */
	public function setNextpage_txt($nextpage_txt) {
		$this->nextpage_txt = $nextpage_txt;
	}

			/**
	 * @param field_type $firstpage_txt
	 */
	public function setFirstpage_txt($firstpage_txt) {
		$this->firstpage_txt = $firstpage_txt;
	}

			/**
	 * @param field_type $endpage_txt
	 */
	public function setEndpage_txt($endpage_txt) {
		$this->endpage_txt = $endpage_txt;
	}

	/**
	 * @return the $pageup
	 */
	public function getPageup() {
		return $this->pageup;
	}

			/**
	 * @return the $nextpage
	 */
	public function getNextpage() {
		return $this->nextpage;
	}

			/**
	 * @return the $fristpage
	 */
	public function getFristpage() {
		return $this->fristpage;
	}

			/**
	 * @return the $endpage
	 */
	public function getEndpage() {
		return $this->endpage;
	}

	/**
	 * @return the $url
	 */
	public function getUrl() {
		return $this->url;
	}

			/**
	 * @param field_type $url
	 */
	public function setUrl($url) {
		$this->url = $url;
	}

	/**
	 * @return the $data_sql
	 */
	public function getData_sql() {
		return $this->data_sql;
	}

			/**
	 * @param field_type $data_sql
	 */
	public function setData_sql($data_sql) {
		$this->data_sql = $data_sql;
	}

	/**
	 * @return the $start
	 */
	public function getStart() {
		return $this->start;
	}

			/**
	 * @return the $end
	 */
	public function getEnd() {
		return $this->end;
	}

	/**
	 * @return the $pagenowid
	 */
	public function getPagenowid() {
		return $this->pagenowid;
	}

			/**
	 * @return the $pageindexid
	 */
	public function getPageindexid() {
		return $this->pageindexid;
	}

			/**
	 * @param string $pagenowid
	 */
	public function setPagenowid($pagenowid) {
		$this->pagenowid = $pagenowid;
	}

			/**
	 * @param string $pageindexid
	 */
	public function setPageindexid($pageindexid) {
		$this->pageindexid = $pageindexid;
	}

	/**
	 * @return the $pagecount
	 */
	public function getPagecount() {
		return $this->pagecount;
	}

			/**
	 * @return the $pagesize
	 */
	public function getPagesize() {
		return $this->pagesize;
	}

			/**
	 * @return the $pagenow
	 */
	public function getPagenow() {
		return $this->pagenow;
	}

			/**
	 * @return the $pageindexcount
	 */
	public function getPageindexcount() {
		return $this->pageindexcount;
	}

			/**
	 * @return the $pageindex
	 */
	public function getPageindex() {
		return $this->pageindex;
	}

			/**
	 * @return the $pageindexsize
	 */
	public function getPageindexsize() {
		return $this->pageindexsize;
	}

			/**
	 * @return the $navigation_bar
	 */
	public function getNavigation_bar() {
		return $this->navigation_bar;
	}

			/**
	 * @return the $data
	 */
	public function getData() {
		return $this->data;
	}

			/**
	 * @param field_type $pagecount
	 */
	public function setPagecount($pagecount) {
		$this->pagecount = $pagecount;
	}

			/**
	 * @param field_type $pagesize
	 */
	public function setPagesize($pagesize) {
		$this->pagesize = $pagesize;
	}

			/**
	 * @param field_type $pagenow
	 */
	public function setPagenow($pagenow) {
		$this->pagenow = $pagenow;
	}

			/**
	 * @param field_type $pageindexcount
	 */
	public function setPageindexcount($pageindexcount) {
		$this->pageindexcount = $pageindexcount;
	}

			/**
	 * @param field_type $pageindex
	 */
	public function setPageindex($pageindex) {
		$this->pageindex = $pageindex;
	}

			/**
	 * @param field_type $pageindexsize
	 */
	public function setPageindexsize($pageindexsize) {
		$this->pageindexsize = $pageindexsize;
	}

			/**
	 * @param field_type $navigation_bar
	 */
	public function setNavigation_bar($navigation_bar) {
		$this->navigation_bar = $navigation_bar;
	}

			/**
	 * @param field_type $data
	 */
	public function setData($data) {
		$this->data = $data;
	}

	public function __construct($sql,$url,$pagesize,$pageindexsize){
		$this->pagesize=$pagesize;
		$this->pageindexsize=$pageindexsize;
		$this->sqlhelper=new SqlHelper();
		$this->url=$url;
		$pagecount=$this->sqlhelper->Execute_DQL_Array($sql);
		//总页数
		$this->pagecount=ceil($pagecount[0][0]/$this->pagesize);
		//总索引数
		$this->pageindexcount=ceil($this->pagecount/$this->pageindexsize);
	}
	
	public function fenye($data_sql){
		$this->data_sql=$data_sql;
		//当前显示的页数
		if(!empty($_GET[$this->pagenowid])){
			$this->pagenow=$_GET[$this->pagenowid];
		}
		//当前显示索引
		if(!empty($_GET[$this->pageindexid])){
			$this->pageindex=$_GET[$this->pageindexid];
		}
		
		//生成查询语句
		$this->data_sql=str_replace($this->start, ($this->pagenow-1)*$this->pagesize, $this->data_sql);
		$this->data_sql=str_replace($this->end, $this->pagesize, $this->data_sql);
		
		//获得查询数据
		$this->data=$this->sqlhelper->Execute_DQL($this->data_sql);
		
		$index=$this->pageindexcount<=1?2:$this->pageindex+$this->pageindexsize;
		
		//生成导航条
		for($j=$this->pageindex;$j<$index;$j++){
			$this->navigation_bar.="<a href='{$this->url}?{$this->pagenowid}=$j&{$this->pageindexid}={$this->pageindex}'>$j</a>";
		}
		//生成上翻页与下翻页
		$pagetemp=$this->pageindex;
		if($this->pageindex>1){
			$this->pageindex=$this->pageindex-$this->pageindexsize;
		}
		if($pagetemp<$this->pageindexcount){
			$pagetemp=$pagetemp+$this->pageindexsize;
		}
		$this->pageup="<a href='{$this->url}?$this->pageindexid={$this->pageindex}'>{$this->pageup_txt}</a>";
		$this->nextpage="<a href='{$this->url}?$this->pageindexid={$pagetemp}'>{$this->nextpage_txt}</a>";
		//生成第一页与最后一页
		$this->fristpage="<a href='{$this->url}?{$this->pagenowid}=1'>{$this->firstpage_txt}</a>";
		$this->endpage="<a href='{$this->url}?{$this->pagenowid}={$this->pagecount}'>{$this->endpage_txt}</a>";
	}
			
			
			
}

IT回忆录

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
1
评论
PHP通用分页类

大多数程序都会用到分页这一功能，所以为了以后方便花了近一个小时封装了一个通用的PHP分页类。<?php require_once "../PublicService/WebHelper.class.php";?>测试#diva a{ width:10px;height:10px; padding:10px;}">返回首页
复制链接

扫一扫