Home >Backend Development >PHP Tutorial >php sqlite分页。

php sqlite分页。

WBOY
WBOYOriginal
2016-06-23 13:40:26837browse

操作数据库文件使用的是上一个操作类。可以参考上一篇文章。本人文采很差,废话不说,直接上代码:

<meta charset="utf-8"><?php class SqlitePage{	public function __construct()	{			$this->table_name='';		$this->tj='';		$this->page_size='';		$this->current_page='';		$this->total_page='';		include_once 'sqlite_db.php';		$this->db=new SqliteDB();//可以调用他的操作方法了	}	function entrance($table_name,$page_size,$tj='')//sql中不包含limit   page_size为每页显示条数	{		// 首先获取当前页		// sql = "select * from tab where "+条件+" order by "+排序+" limit "+要显示多少条记录+" offset "+跳过多少条记录;		$this->page_size=$page_size;		$this->table_name=$table_name;		$this->tj=$tj;		$this->total_page=ceil($this->db->total($this->table_name,$this->tj)/$this->page_size);		if (!isset($_GET['page'])) {			$this->current_page=1;//如果没有page,则设置为默认第一页		}		else{			$this->current_page=$_GET['page'];		}		if ($this->current_page>$this->total_page) {//当当前页数目大于总页数,则设置当前页数为总页数			$this->current_page=$this->total_page;		}		if ($this->current_pagecurrent_page=1;		}		$tj=$this->tj.' limit '.$this->page_size.' offset '.($this->current_page-1)*$this->page_size;		$result=$this->db->query($this->table_name,$tj);		return $result;			}	function page_bar()	{		$old_url = $_SERVER["REQUEST_URI"]; 		$check = strpos($old_url, '?'); 		$pre_urls='test';		if ($check) {//如果urls中有?			if(substr($old_url, $check+1) == '') 			{ //有问号,但是后面没有跟任何参数				$first_urls=$old_url.'page=1';//首页				$pre_urls=$old_url.'page='.($this->current_page-1);//上一页;				$next_urls=$old_url.'page='.($this->current_page+1);//下一页;				$end_urls=$old_url.'page='.$this->total_page;//末页			} 			else {//有问号,并且有参数				if (isset($_GET['page'])) {//如果参数中包含page参数,则注销这个参数					unset($_GET['page']);					$old_url='http://'.$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF'].'?'.http_build_query($_GET);				}				$first_urls=$old_url.'&page=1';//首页				$pre_urls=$old_url.'&page='.($this->current_page-1);//上一页;				$next_urls=$old_url.'&page='.($this->current_page+1);//下一页;				$end_urls=$old_url.'&page='.$this->total_page;//末页			}		}		else{// 如果没有问号(也就是说后面没有任何参数,则直接跟)			$first_urls=$old_url.'?page=1';			$first_urls=$old_url.'?page=1';//首页			$pre_urls=$old_url.'?page='.($this->current_page-1);//上一页;			$next_urls=$old_url.'?page='.($this->current_page+1);//下一页;			$end_urls=$old_url.'?page='.$this->total_page;//末页		}				// echo $this->table_name.'table_name';					return '		<div class="page">			<a>【共'.$this->total_page.'页,第'.$this->current_page.'页】</a>			<a href="'.%24first_urls.'">首页</a>			<a href="'.%24pre_urls.'">上一页</a>			<a href="'.%24next_urls.'">下一页</a>			<a href="'.%24end_urls.'">末页</a>		</div>		';	}		public function get_total_page()	{			return ceil($this->total_record/$this->page_size);	}}// $page=new PrePage();// $res=$page->entrance('log',10);// echo "<hr>";// foreach ($res as $key => $row) {// 	echo $row['urls'].'<br>';// }// echo $page->page_bar();?>


Statement:
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