<?php
class Page{
var $sql ;
var $pages ;
var $pageSize ;
var $totalPage ;
var $amount ;
var $content ;
var $utits ;
function __construct($sql , $pageSize , $pages , $content , $utits){
$this->sql=$sql ;
$this->pages=$pages ;
$this->content=$content ;
$this->utits=$utits ;
$this->pageSize=$pageSize ;
}
function ery(){
if(!isset($this->pages) || $this->pages=="" || $this->pages==0){
$this->pages = 1 ;
}
else{
$this->pages=$this->pages ;
}
$mysql=mysql_query($this->sql . "limit" . (($this->pages - 1) * $this->pageSize) . ", $this->pageSize") ;
第25行 return mysql_fetch_object($mysql) ;
}
function show(){
$result=mysql_query($this->sql) ;
$this->amount=mysql_num_rows($result) ;
if($this->amount==0){
return false ;
}
else{
if(($this->amount % $this->pageSize)==0){
$this->totalPage=intval($this->amount / $this->pageSize) ;
}
else if($this->amount <= $this->pageSize){
$this->totalPage=1 ;
}
else{
$this->totalPage=ceil($this->amount / $this->pageSize) ;
}
}
$string .="共有" . $this->content . " " . $this->amount . " " . $this->utits . " 每页显示 " . $this->pageSize . " " . $this->utits . " 第 " . $this->pages . " 页/共 " . $this->totalPage . " 页 " ; $string .= "<a href=" . $_SERVER['PHP_SELF'] . "?page=1> 首页 </a>" ;
$string .=" " ; if(($this->pages - 1) <=0){
$string .= "<a href=" . $_SERVER['PHP_SELF'] . "?page=1> 上一页 </a>" ;
}
else{
$string .= "<a href=" . $_SERVER['PHP_SELF'] . "?page=" .($this->pages - 1). "> 上一页 </a>" ;
} if(($this->pages + 1) >=$this->totalPage){
$string .= "<a href=" . $_SERVER['PHP_SELF'] . "?page=".$this->totalPage."> 下一页 </a>" ;
}
else{
$string .= "<a href=" . $_SERVER['PHP_SELF'] . "?page=" .($this->pages + 1). "> 下一页 </a>" ;
} $string .= "<a href=" . $_SERVER['PHP_SELF'] . "?page=" .$this->totalPage. "> 尾页 </a>" ;
return $string ;
}
}$sql=new Page("select * from forum order by talkid desc" , 3 , $_GET["pages"] , "公告" , "条") ;
var_dump($sql->ery()) ;
?>出现的问题:
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in D:\www\demo\forum\Page.php on line 25
bool(false)
class Page{
var $sql ;
var $pages ;
var $pageSize ;
var $totalPage ;
var $amount ;
var $content ;
var $utits ;
function __construct($sql , $pageSize , $pages , $content , $utits){
$this->sql=$sql ;
$this->pages=$pages ;
$this->content=$content ;
$this->utits=$utits ;
$this->pageSize=$pageSize ;
}
function ery(){
if(!isset($this->pages) || $this->pages=="" || $this->pages==0){
$this->pages = 1 ;
}
else{
$this->pages=$this->pages ;
}
$mysql=mysql_query($this->sql . "limit" . (($this->pages - 1) * $this->pageSize) . ", $this->pageSize") ;
第25行 return mysql_fetch_object($mysql) ;
}
function show(){
$result=mysql_query($this->sql) ;
$this->amount=mysql_num_rows($result) ;
if($this->amount==0){
return false ;
}
else{
if(($this->amount % $this->pageSize)==0){
$this->totalPage=intval($this->amount / $this->pageSize) ;
}
else if($this->amount <= $this->pageSize){
$this->totalPage=1 ;
}
else{
$this->totalPage=ceil($this->amount / $this->pageSize) ;
}
}
$string .="共有" . $this->content . " " . $this->amount . " " . $this->utits . " 每页显示 " . $this->pageSize . " " . $this->utits . " 第 " . $this->pages . " 页/共 " . $this->totalPage . " 页 " ; $string .= "<a href=" . $_SERVER['PHP_SELF'] . "?page=1> 首页 </a>" ;
$string .=" " ; if(($this->pages - 1) <=0){
$string .= "<a href=" . $_SERVER['PHP_SELF'] . "?page=1> 上一页 </a>" ;
}
else{
$string .= "<a href=" . $_SERVER['PHP_SELF'] . "?page=" .($this->pages - 1). "> 上一页 </a>" ;
} if(($this->pages + 1) >=$this->totalPage){
$string .= "<a href=" . $_SERVER['PHP_SELF'] . "?page=".$this->totalPage."> 下一页 </a>" ;
}
else{
$string .= "<a href=" . $_SERVER['PHP_SELF'] . "?page=" .($this->pages + 1). "> 下一页 </a>" ;
} $string .= "<a href=" . $_SERVER['PHP_SELF'] . "?page=" .$this->totalPage. "> 尾页 </a>" ;
return $string ;
}
}$sql=new Page("select * from forum order by talkid desc" , 3 , $_GET["pages"] , "公告" , "条") ;
var_dump($sql->ery()) ;
?>出现的问题:
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in D:\www\demo\forum\Page.php on line 25
bool(false)
$mysql=mysql_query($this->sql . " limit " . (($this->pages - 1) * $this->pageSize) .
", {$this->pageSize}" );
var $sql ;将楼上的SQL语句输出来看看是什么就知道错哪了$SQL=$this->sql . " limit " . (($this->pages - 1) * $this->pageSize) .
", {$this->pageSize}";echo $SQL;
我这有一个php的通用分页类,你可以看看:http://www.phpnewer.com/index.php/Ymgx/detail/id/5