分页类
<?php
/** ******************************************************************************
* brophp.com 分页类,可以自定义分页显示内容。 *
* *******************************************************************************
* 许可声明:专为《细说PHP》读者及LAMP兄弟连学员提供的“学习型”超轻量级php框架。*
* *******************************************************************************
* 版权所有 (C) 2011-2013 北京易第优教育咨询有限公司,并保留所有权利。 *
* 网站地址: http://www.lampbrother.net (LAMP兄弟连) *
* *******************************************************************************
* $Author: 高洛峰 ([email protected]) $ *
* $Date: 2011-07-18 10:00:00 $ *
* ******************************************************************************/
class Page {
private $total; //数据表中总记录数
private $listRows; //每页显示行数
private $limit; //SQL语句使用limit从名
private $uri; //url地址
private $pageNum; //页数
//在分页信息中显示内容,可以自己设置
private $config=array('head'=>"条记录", "prev"=>"上一页", "next"=>"下一页", "first"=>"首页", "last"=>"末页");
private $listNum=10; //默认分页列表显示的个数/**
* 构造方法,可以设置分页类的属性
* @param int $total 计算分页的总记录数
* @param int $listRows 可选的,默认每页需要显示的记录数
* @param string $pa 可选的,为向目标页面传递参数
*/
public function __construct($total, $listRows=25, $pa=""){
$this->total=$total;
$this->listRows=$listRows;
$this->uri=$this->getUri($pa);
$page=!empty($_GET["page"]) ? $_GET["page"] : 1;
if($total > 0) {
if(preg_match('/\D/', $page) ){
$this->page=1;
}else{
$this->page=$page;
}
}else{
$this->page=0;
}
$this->pageNum=ceil($this->total/$this->listRows);
$this->limit=$this->setLimit();
}/**
* 用于设置显示分页的信息,可以连贯操作
* @param string $param 是数组config的下标
* @param string $value 用于设置config下标对应的元素值
* @return object 返回本对象自己$this
*/
function set($param, $value){
if(array_key_exists($param, $this->config)){
$this->config[$param]=$value;
}
return $this;
}private function setLimit(){
if($this->page > 0)
return ($this->page-1)*$this->listRows.", {$this->listRows}";
else
return 0;
}private function getUri($pa){
if($pa=="")
return $GLOBALS["url"].$_GET["a"].'/';
else
return $GLOBALS["url"].$_GET["a"].'/'.trim($pa, "/").'/';
}private function __get($args){
if($args=="limit")
return $this->limit;
else
return null;
}private function start(){
if($this->total==0)
return 0;
else
return ($this->page-1)*$this->listRows+1;
}private function end(){
return min($this->page*$this->listRows,$this->total);
}private function firstprev(){
if($this->page > 1) {
$str=" <a href='{$this->uri}page/1'>{$this->config["first"]}</a>";
$str.=" <a href='{$this->uri}page/".($this->page-1)."'>{$this->config["prev"]}</a> ";
return $str;
}}
private function pageList(){
$linkPage=" <b>";$inum=floor($this->listNum/2);for($i=$inum; $i>=1; $i--){
$page=$this->page-$i;if($page>=1)
$linkPage.="<a href='{$this->uri}page/{$page}'>{$page}</a> ";}if($this->pageNum > 1)
$linkPage.="{$this->page} ";
for($i=1; $i<=$inum; $i++){
$page=$this->page+$i;
if($page<=$this->pageNum)
$linkPage.="<a href='{$this->uri}page/{$page}'>{$page}</a> ";
else
break;
}
$linkPage.='</b>';
return $linkPage;
}private function nextlast(){
if($this->page != $this->pageNum) {
$str=" <a href='{$this->uri}page/".($this->page+1)."'>{$this->config["next"]}</a> ";
$str.=" <a href='{$this->uri}page/".($this->pageNum)."'>{$this->config["last"]}</a> ";
return $str;
}}private function goPage(){
if($this->pageNum > 1) {
return ' <input style="width:20px;height:17px !important;height:18px;border:1px solid #CCCCCC;" type="text" onkeydown="javascript:if(event.keyCode==13){var page=(this.value>'.$this->pageNum.')?'.$this->pageNum.':this.value;location=\''.$this->uri.'page/\'+page+\'\'}" value="'.$this->page.'"><input style="cursor:pointer;width:25px;height:18px;border:1px solid #CCCCCC;" type="button" value="GO" onclick="javascript:var page=(this.previousSibling.value>'.$this->pageNum.')?'.$this->pageNum.':this.previousSibling.value;location=\''.$this->uri.'page/\'+page+\'\'"> ';
}
}private function disnum(){
if($this->total > 0){
return $this->end()-$this->start()+1;
}else{
return 0;
}
}
/**
* 按指定的格式输出分页
* @param int 为0-7的数字,每个数字作为一个参数,可以自定义输出分页结构和调整结构的顺序
* @return string 分页信息内容
*/
function fpage(){
$arr=func_get_args();$html[0]=" 共<b> {$this->total} </b>{$this->config["head"]} ";
$html[1]=" 本页 <b>".$this->disnum()."</b> 条 ";
$html[2]=" 本页从 <b>{$this->start()}-{$this->end()}</b> 条 ";
$html[3]=" <b>{$this->page}/{$this->pageNum}</b>页 ";
$html[4]=$this->firstprev();
$html[5]=$this->pageList();
$html[6]=$this->nextlast();
$html[7]=$this->goPage();$fpage='<div style="font:12px \'\5B8B\4F53\',san-serif;">';
if(count($arr) < 1)
$arr=array(0, 1,2,3,4,5,6,7);
for($i=0; $i<count($arr); $i++)
$fpage.=$html[$arr[$i]];$fpage.='</div>';
return $fpage;
}
}index.php
include_once('global.php');
include_once('page.class.php');
$mysqli=new MySQLi("localhost","root","123456","bbs")or die(mysqli_connect_error());
@mysqli_query("set names utf8");
$query=$mysqli->query("select * from message");
$page=new Page($query->num_rows,5);
$query=$mysqli->query("select * from message order by times 在这里不知道怎么写");
$date=array();
while($row=$query->fetch_assoc()){
$date[]=$row;
}
$smarty->assign("title",$date);
$smarty->assign("fpage",$page->fpage());
或者也可以給我一个分页类,,但要指明怎么调用,,谢谢!
<?php
/** ******************************************************************************
* brophp.com 分页类,可以自定义分页显示内容。 *
* *******************************************************************************
* 许可声明:专为《细说PHP》读者及LAMP兄弟连学员提供的“学习型”超轻量级php框架。*
* *******************************************************************************
* 版权所有 (C) 2011-2013 北京易第优教育咨询有限公司,并保留所有权利。 *
* 网站地址: http://www.lampbrother.net (LAMP兄弟连) *
* *******************************************************************************
* $Author: 高洛峰 ([email protected]) $ *
* $Date: 2011-07-18 10:00:00 $ *
* ******************************************************************************/
class Page {
private $total; //数据表中总记录数
private $listRows; //每页显示行数
private $limit; //SQL语句使用limit从名
private $uri; //url地址
private $pageNum; //页数
//在分页信息中显示内容,可以自己设置
private $config=array('head'=>"条记录", "prev"=>"上一页", "next"=>"下一页", "first"=>"首页", "last"=>"末页");
private $listNum=10; //默认分页列表显示的个数/**
* 构造方法,可以设置分页类的属性
* @param int $total 计算分页的总记录数
* @param int $listRows 可选的,默认每页需要显示的记录数
* @param string $pa 可选的,为向目标页面传递参数
*/
public function __construct($total, $listRows=25, $pa=""){
$this->total=$total;
$this->listRows=$listRows;
$this->uri=$this->getUri($pa);
$page=!empty($_GET["page"]) ? $_GET["page"] : 1;
if($total > 0) {
if(preg_match('/\D/', $page) ){
$this->page=1;
}else{
$this->page=$page;
}
}else{
$this->page=0;
}
$this->pageNum=ceil($this->total/$this->listRows);
$this->limit=$this->setLimit();
}/**
* 用于设置显示分页的信息,可以连贯操作
* @param string $param 是数组config的下标
* @param string $value 用于设置config下标对应的元素值
* @return object 返回本对象自己$this
*/
function set($param, $value){
if(array_key_exists($param, $this->config)){
$this->config[$param]=$value;
}
return $this;
}private function setLimit(){
if($this->page > 0)
return ($this->page-1)*$this->listRows.", {$this->listRows}";
else
return 0;
}private function getUri($pa){
if($pa=="")
return $GLOBALS["url"].$_GET["a"].'/';
else
return $GLOBALS["url"].$_GET["a"].'/'.trim($pa, "/").'/';
}private function __get($args){
if($args=="limit")
return $this->limit;
else
return null;
}private function start(){
if($this->total==0)
return 0;
else
return ($this->page-1)*$this->listRows+1;
}private function end(){
return min($this->page*$this->listRows,$this->total);
}private function firstprev(){
if($this->page > 1) {
$str=" <a href='{$this->uri}page/1'>{$this->config["first"]}</a>";
$str.=" <a href='{$this->uri}page/".($this->page-1)."'>{$this->config["prev"]}</a> ";
return $str;
}}
private function pageList(){
$linkPage=" <b>";$inum=floor($this->listNum/2);for($i=$inum; $i>=1; $i--){
$page=$this->page-$i;if($page>=1)
$linkPage.="<a href='{$this->uri}page/{$page}'>{$page}</a> ";}if($this->pageNum > 1)
$linkPage.="{$this->page} ";
for($i=1; $i<=$inum; $i++){
$page=$this->page+$i;
if($page<=$this->pageNum)
$linkPage.="<a href='{$this->uri}page/{$page}'>{$page}</a> ";
else
break;
}
$linkPage.='</b>';
return $linkPage;
}private function nextlast(){
if($this->page != $this->pageNum) {
$str=" <a href='{$this->uri}page/".($this->page+1)."'>{$this->config["next"]}</a> ";
$str.=" <a href='{$this->uri}page/".($this->pageNum)."'>{$this->config["last"]}</a> ";
return $str;
}}private function goPage(){
if($this->pageNum > 1) {
return ' <input style="width:20px;height:17px !important;height:18px;border:1px solid #CCCCCC;" type="text" onkeydown="javascript:if(event.keyCode==13){var page=(this.value>'.$this->pageNum.')?'.$this->pageNum.':this.value;location=\''.$this->uri.'page/\'+page+\'\'}" value="'.$this->page.'"><input style="cursor:pointer;width:25px;height:18px;border:1px solid #CCCCCC;" type="button" value="GO" onclick="javascript:var page=(this.previousSibling.value>'.$this->pageNum.')?'.$this->pageNum.':this.previousSibling.value;location=\''.$this->uri.'page/\'+page+\'\'"> ';
}
}private function disnum(){
if($this->total > 0){
return $this->end()-$this->start()+1;
}else{
return 0;
}
}
/**
* 按指定的格式输出分页
* @param int 为0-7的数字,每个数字作为一个参数,可以自定义输出分页结构和调整结构的顺序
* @return string 分页信息内容
*/
function fpage(){
$arr=func_get_args();$html[0]=" 共<b> {$this->total} </b>{$this->config["head"]} ";
$html[1]=" 本页 <b>".$this->disnum()."</b> 条 ";
$html[2]=" 本页从 <b>{$this->start()}-{$this->end()}</b> 条 ";
$html[3]=" <b>{$this->page}/{$this->pageNum}</b>页 ";
$html[4]=$this->firstprev();
$html[5]=$this->pageList();
$html[6]=$this->nextlast();
$html[7]=$this->goPage();$fpage='<div style="font:12px \'\5B8B\4F53\',san-serif;">';
if(count($arr) < 1)
$arr=array(0, 1,2,3,4,5,6,7);
for($i=0; $i<count($arr); $i++)
$fpage.=$html[$arr[$i]];$fpage.='</div>';
return $fpage;
}
}index.php
include_once('global.php');
include_once('page.class.php');
$mysqli=new MySQLi("localhost","root","123456","bbs")or die(mysqli_connect_error());
@mysqli_query("set names utf8");
$query=$mysqli->query("select * from message");
$page=new Page($query->num_rows,5);
$query=$mysqli->query("select * from message order by times 在这里不知道怎么写");
$date=array();
while($row=$query->fetch_assoc()){
$date[]=$row;
}
$smarty->assign("title",$date);
$smarty->assign("fpage",$page->fpage());
或者也可以給我一个分页类,,但要指明怎么调用,,谢谢!
$result=$mysqli->query("select * from message order by id limit $start,$pagesize");错误提示:
Fatal error: Call to a member function fetch_assoc() on a non-object in E:\AppServ\www\PHP\phpnew\Untitled-1.php on line 28
function multi($num, $perpage, $curpage, $mpurl, $maxpages = 0, $page = 10, $autogoto = TRUE, $simple = FALSE) {
global $maxpage;
$ajaxtarget = !empty($_GET['ajaxtarget']) ? " ajaxtarget=\"".dhtmlspecialchars($_GET['ajaxtarget'])."\" " : ''; if(defined('IN_ADMINCP')) {
$shownum = $showkbd = TRUE;
$lang['prev'] = '‹‹';
$lang['next'] = '››';
} else {
$shownum = $showkbd = FALSE;
$lang['prev'] = ' ';
$lang['next'] = $GLOBALS['dlang']['nextpage'];
} $multipage = '';
$mpurl .= strpos($mpurl, '?') ? '&' : '?';
$realpages = 1;
if($num > $perpage) {
$offset = 2; $realpages = @ceil($num / $perpage);
$pages = $maxpages && $maxpages < $realpages ? $maxpages : $realpages; if($page > $pages) {
$from = 1;
$to = $pages;
} else {
$from = $curpage - $offset;
$to = $from + $page - 1;
if($from < 1) {
$to = $curpage + 1 - $from;
$from = 1;
if($to - $from < $page) {
$to = $page;
}
} elseif($to > $pages) {
$from = $pages - $page + 1;
$to = $pages;
}
} $multipage = ($curpage - $offset > 1 && $pages > $page ? '<a href="'.$mpurl.'page=1" class="first"'.$ajaxtarget.'>1 ...</a>' : '').
($curpage > 1 && !$simple ? '<a href="'.$mpurl.'page='.($curpage - 1).'" class="prev"'.$ajaxtarget.'>'.$lang['prev'].'</a>' : '');
for($i = $from; $i <= $to; $i++) {
$multipage .= $i == $curpage ? '<strong>'.$i.'</strong>' :
'<a href="'.$mpurl.'page='.$i.($ajaxtarget && $i == $pages && $autogoto ? '#' : '').'"'.$ajaxtarget.'>'.$i.'</a>';
} $multipage .= ($to < $pages ? '<a href="'.$mpurl.'page='.$pages.'" class="last"'.$ajaxtarget.'>... '.$realpages.'</a>' : '').
($curpage < $pages && !$simple ? '<a href="'.$mpurl.'page='.($curpage + 1).'" class="next"'.$ajaxtarget.'>'.$lang['next'].'</a>' : '').
($showkbd && !$simple && $pages > $page && !$ajaxtarget ? '<kbd><input type="text" name="custompage" size="3" onkeydown="if(event.keyCode==13) {window.location=\''.$mpurl.'page=\'+this.value; return false;}" /></kbd>' : ''); $multipage = $multipage ? '<div class="pages">'.($shownum && !$simple ? '<em> '.$num.' </em>' : '').$multipage.'</div>' : '';
}
$maxpage = $realpages;
return $multipage;
}
"SELECT * FROM message ORDER BY id LIMIT ". $page->setLimit(); // 你的SQL语句