分页显示
今天学会了用PHP如何分页,挺欣慰,功夫不负有心人!
limit 起了关键作用,limit 0,10,表示从0条记录开始,显示10条记录
<?php $host='localhost'; $user_name='root'; $password='123'; $conn=mysql_connect($host,$user_name,$password); if(!$conn) { die('数据库连接失败:'.mysql_error()); } mysql_select_db('mydatabase'); if(isset($_GET['page'])) { $page=$_GET['page']; } else { $page=1; } $pagesize=2; $sql='select *from liuyan'; $result=mysql_query($sql); $total=mysql_num_rows($result); if($total) { if($total<$pagesize) $page_count=1; if($total%$pagesize) { $page_count=(int)($total/$pagesize)+1; } else { $page_count=$total/$pagesize; } } else { $page_count=0; } $turn_page=''; if($page==1) { $turn_page.='首页|上一页'; } else { $turn_page='<a href=13-8.php?page=1>首页</a>|<a href=13-8.php?page='.($page-1).'>上一页</a>|'; } if($page==$page_count||$page_count==0) { $turn_page.='下一页|尾页'; } else { $turn_page.='<a href=13-8.php?page='.($page+1).'>下一页</a>|<a href=13-8.php?page='.$page_count.'>尾页</a>'; } $sql='select time ,content from liuyan limit '.($page-1)*$pagesize.','.$pagesize; $result=mysql_query($sql); ?>