<?php
include ('conn.php');

?>
<table width=500 border="0" bgcolor="#add3ef">
  <?php
 

  $pageSize = 3; //每页显示的条数
  $result = mysql_query("select * from message");//查询数据库
  echo $totalNum = mysql_num_rows($result); //数据总条数
  $totalPageCount = intval($totalNum/$pageSize); //总页数
  $nowPage = isset($_GET['page']) ? intval($_GET['page']) : 1;
  //上一页
  $prev = ($nowPage-1 <= 0) ? 1 : $nowPage-1;
  //下一页
  $next = ($nowPage+1 >= $totalPageCount) ? $totalPageCount : $nowPage+1;
  //偏移量
  $offset = ($nowPage-1)*$pageSize;
  $sql = "select * from messages limit $offset,$pageSize";
  $result = mysql_query($sql,$conn);
 
while($arr = mysql_fetch_array($result)){//总是提示我这里错了
?>
  <tr bgcolor="#eff3ff">
    <td>标题: <?= $arr['title']?>
                    用户：<?php echo $arr['user']?></td></tr>
   <tr bgColor="#ffffff">
    <td>内容：
      <?php echo $arr['content']?></td>
  </tr>
  <?php
  }
  echo "<a href=\"".$_SERVER['PHP_SELF']."?page=1\">首页</a>";
  echo "<a href=\"".$_SERVER['PHP_SELF']."?page=".$prev."\">上一页</a>";
  echo "<a href=\"".$_SERVER['PHP_SELF']."?page=".$next."\">下一页</a>";
  echo "<a href=\"".$_SERVER['PHP_SELF']."?page=".$totalPageCount."\">尾页</a>";
  ?>
</table>