php中分页代码解决方案

php中分页代码






include "sql_class.php" ;
$mysql=new Db_Mysql() ;
$mysql->dbConnect() ;
//$error=new Script() ;

$pageSize=2 ;
$page_string = "";
$totalpage="" ;
if( isset($_GET['page']) ){
$page = intval( $_GET['page'] );
}
else{
$page = 1;
}
$sql="select count(*) as amount from $mysql->table order by id desc" ;
$result = mysql_query($sql);
$amount = mysql_result($result , 0 , "amount");
if($amount){
if($amount < $pageSize){
$totalpage = 1;
}
if( $amount % $pageSize ){
$totalpage = intval($amount / $pageSize) + 1;
}else{
$totalpage = $amount / $pageSize;
}
}
else{
$totalpage = 1;
}
?>

添加留言












$select="select * from $mysql->table limit (($page - 1) * $pageSize) , $pageSize " ;
$num=mysql_query($select) ;
第五十五行：while($info=mysql_fetch_array($num)){
?>









}
if( $page >1 AND $page<$totalpage ){
$page_string = "当前是第 $page 页|＜a href= ?page=1＞第一页＜/a＞|＜a href= ?page=($page-1)＞上一页＜/a＞| ＜a href=?page=($page+1)＞下一页＜/a＞|＜a href=?page=$totalpage＞尾页＜/a＞";
}
else if($page < 1){
$page_string ="当前是第 $page 页|第一页|上一页" ;
}
else if($page > $totalpage){
$page_string = "当前是第 $page 页|下一页|尾页";
}
?>

编号	留言者	主题	内容	日期	编辑	删除
		">			">编辑	">删除