分页显示

今天学会了用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);
?>