//定每页显示多少条 //count(*)查询总条数

//计算总页数ceil()

//判断$_GET 并赋值当前页数

//mysql查询 limit (当前页数-1)*每页条数,每页条数

//如果总条数不为空，进行循环mysql_fetch_array()

//$_SERVER[‘PHP_SELF’] //上一页?page=当前页-1 //下一页?page=当前页+1 <?php</p> <p>include("conn.php"); </p> <p>$perpagenum = 3;</p> <p>$total = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM message"));</p> <p>$Total = $total[0];</p> <p>$Totalpage =ceil($Total/$perpagenum);</p> <p>if(!isset($_GET['page'])||!intval($_GET['page'])||$_GET['page']>$Totalpage){</p> <pre><code>$page = 1;

}else{

$page = $_GET['page'];

}

$start = ($page-1)*$perpagenum;

$sql = “SELECT * FROM message ORDER BY id DESC LIMIT $start,$perpagenum”;

$result = mysql_query($sql);

$contents = mysql_fetch_array($result);

?>

<?php } while($contents=mysql_fetch_array($result)); $per = $page-1; $next= $page+1; echo " 共有”.$Total.”条留言，每页”.$perpagenum.”条，共”.$page.”/”.$Totalpage.”页。”; if($page!=1){ echo “首页“. “上一页“; } if($page!=$Totalpage){ echo “下一页“; echo “尾页“; } ?>

昵称：		发表于: