$conn=mysql_connect("localhost","root","");
//$result2=mysql_db_query("hello_world", "insert into hello_table values ('add1',8)",$conn);
// $result2=mysql_db_query("hello_world", "delete from hello_table where hello_column='add1'",$conn);
$resultNum=mysql_db_query("hello_world","select count(*) from hello_table order by hello_column" ,$conn);
$RSS=mysql_fetch_array($resultNum);
$num=$RSS[0];
if(empty($_GET['page'])){
$page=0;
}else{
$page=$_GET['page'];
if($page<0){
$page=0;
}
if($page>=ceil($num/5)){
$page=ceil($num/5)-1;
}
}
$excute="select * from hello_table order by hello_column limit ".($page*5).",5 ";
$result=mysql_db_query("hello_world",$excute ,$conn);
$row=mysql_fetch_row($result);
for($i=0;$i echo mysql_field_name($result, $i)." "; } echo " while($row=mysql_fetch_row($result)){ for($i=0;$i echo $row[$i]." "; } echo " } mysql_free_result($result); mysql_close($conn); ?> < a href="test.php?page=0">FirstPagea> < a href="test.php?page==($page-1) ?>">PrevPagea> < a href="test.php?page==($page+1) ?>">NextPagea> < a href="test.php?page==ceil($num/5)-1 ?>">LastPagea> ===================================================================== 怎么分段,当前在第几段 (每页有几条,当前再第几页) 前10条记录:select * from table limit 0,10 第11至20条记录:select * from table limit 10,10 第21至30条记录:select * from table limit 20,10 (当前页数 - 1 )X 每页条数 , 每页条数 Select * from table limit ($Page- 1) * $PageSize, $PageSize
";
";
下一篇:PHP的设计模式