首先设置每页显示的记录数为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 } ?>
如果 p a g e + 1 < = page+1<= 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 } ?>