分页显示

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

?>