分页显示是一项基本的开发功能,有时候评论或者帖子太多,不可能一个页面就把所有的内容显示出来,所以需要设置每页显示的数量.这个常量pagesize设置在lib.php中.
comment.php
include('conn.php');
include('lib.php');
include('ChromePhp.php');
$aid=$_GET['a'];
//获取评论
//计算留言总数
$count_result = mysql_query("SELECT count(*) as count FROM comments where aid='$aid'");
$count_array = mysql_fetch_array($count_result);
//计算总的页数
$pagenum=ceil($count_array['count']/$pagesize);
//确定当前页数 $p 参数
$p = $_GET['p']?$_GET['p']:1;
//数据指针
$offset = ($p-1)*$pagesize;
//从评论表和用户表中提取评论和评论者的信息
$sql="select * from comments ,users where comments.aid = '$aid' and comments.uid = users.id ORDER BY addtime ASC LIMIT $offset, $pagesize";
$query=mysql_query($sql);
include('templates/comment.php')
?>templates/comment.php
<?php echo $article['title'] ?>
class="ui-btn-right ui-btn ui-btn-inline ui-mini ui-corner-all ui-btn-icon-right ui-icon-comment">评论