php分页

首先设置每页显示的记录数为2

const PAGE_SIZE = 2;

计算出记录的总数

$sql = "select count(*) from user";
$result = $conn->query($sql);
$data = $result->fetch_row();
$count = $data[0];

计算出总共的页数

$page_count = ceil($count/PAGE_SIZE);

需要执行的sql指令 用limit分页

$index = ($page-1)*PAGE_SIZE; 
$sql = "select id,user,create_time from user limit $index," . PAGE_SIZE;

如果$page-1>执行

<?PHP if($page-1>0){ ?>
      <li><a href="<?php echo $_SERVER['PHP_SELF'] ?>?page=<?php echo $page-1 ?>">上一页</a></li>
      <?php } ?>

如果$page+1<=$page_count 执行

      <?php } ?>
      <?PHP if($page+1<=$page_count){ ?>
      <li><a href="<?php echo $_SERVER['PHP_SELF'] ?>?page=<?php echo $page+1 ?>">下一页</a></li>
      <?php } ?>