(1)分页原理:
所谓分页,就是将数据库的结果集一段一段的显示出来
(2)所需要的条件:
怎么分段,当前在第几段(每页有几条,当前再第几页)
前10条记录:select * from
table limit 0,10
第11至20条记录:select *
from table limit 10,10
第21至30条记录:select *
from table limit 20,10
(3)得到公式
(当前页数 - 1 )X 每页条数 , 每页条数
Select * from table
limit ($Page- 1) * $PageSize, $PageSize
实例:
conn.php
$connection = @mysql_connect("localhost","root","") or die("db
connect filed : ".mysql_error());
@mysql_select_db("test") or die("db select filed :
".mysql_error());
?>
add.php
action = "add.php" method="post">
用戶名:
=10>
留言內容:
=50>
value="submit">
include_once 'conn.php';
$sql = "insert into `mesage` (uname,message) values
('$_POST[uname]','$_POST[upass]')";
@mysql_query($sql,$connection) or die("插入数据库失败 :
".mysql_error());
echo "插入数据成功";
?>
list.php
include_once 'conn.php';
//分解url
$url = $_SERVER["REQUEST_URI"]; //获取服务器url
$url = parse_url($url); //分解url
$url = $_GET[path]; //得到url path
$pagesize=3;//每页显示条数
//数据总条数
$sql = "select * from `mesage`";
$numq = @mysql_query($sql,$connection) or die("data select filed :
".mysql_error());
$num = mysql_num_rows($numq);
if
($_GET[page]){
$pagevar = $_GET[page];
$page =
($pagevar - 1)*$pagesize.",";//处理一下page,让其适应下面的sql文
}
$sql = "select * from `mesage` limit $page $pagesize";
$result = @mysql_query($sql,$connection) or die("data select filed
: ".mysql_error());
//循环显示得到的信息
while ($row = mysql_fetch_array($result)){
?>
border=1>
width="100px">用户名:
=$row["uname"]?>信息: =$row["message"]?>echo "共".$num."条数据";
echo "
href=$url?page=".($pagevar-1).">上一页
href=$url?page=".($pagevar+1).">下一页
";
?>