isset检测$_GET里面存的page是否存在
<?php
//设置北京时间
date_default_timezone_set('PRC');
const PAGE_SIZE = 2;//每页多少条记录
$page=1;//默认为第一页
if(isset($_GET['page'])){ //预定义变量$_GET,该数组存储的是以get方式请求的数据
$page = $_GET['page'];
}
数据库连接
$data = $result->fetch_row();//因为只有一条记录
记录总数用count(*)
//总页数,取整数(ceil,floor,round)
ceil:向上取整法;floor:向下取整法;round:对浮点数进行四舍五入
$conn = @new mysqli('sqld-gz.bcehost.com','a88737246e62417b88d1fa3f4afffe76','3bf273457be54d639fc3359865c1eb65','ZawnWyVCWPJiMvHeXyjX');
if($conn->connect_error){
die('连接数据库失败');
}
$conn->set_charset('utf8');
//就算记录总数
$sql = "select count(*) from user";
$result = $conn->query($sql);
$data = $result->fetch_row();//因为只有一条记录
$count = $data[0];//总记录数
// echo $count;
// exit;
$page_count = ceil($count/PAGE_SIZE);
分页查询用limit(x,y) x = (页号-1)*每页的行数
PAGE_SIZE不能写在sql指令里面,在字符串里面不能直接写常量
//page =1,$index=0;page=2,$index=2,page=3,index=4;
$index=($page-1)*PAGE_SIZE;
$sql="select id,user,create_time from user limit $index," . PAGE_SIZE;
$result = $conn->query($sql);
$arr=[];
while($row = $result->fetch_assoc()){
$arr[] = $row;
}
//释放结果集
$result->free();
$conn->close();
利用bootstrap引入css样式
<link rel="stylesheet" href="./bootstrap-3.3.7-dist/css/bootstrap.min.css">
<script type="text/javascript" src="./bootstrap-3.3.7-dist/js/jquery-3.3.1.min.js"></script>
<script type="text/javascript" src="./bootstrap-3.3.7-dist/js/"></script>
</head>
<body>
<div class="container">
<div class="panel panel-primary"><!--面板颜色-->
<div class="panel-heading">用户列表</div><!--标题-->
<div class="table-responsive">
<!-- table-striped各行换色 -->
<table class="table table-bordered table-striped table-hover">
<tr>
<th>用户名</th>
<th width="200">创建日期</th>
</tr>
<?php foreach($arr as $row){ ?>
<tr>
<td><?php echo $row['user'] ?></td>
<td><?php echo date('Y-m-d H:i:s',$row['create_time']) ?></td>
</tr>
<?php } ?>
</table>
$page-1>0 避免出现页数为负数
p
a
g
e
+
1
<
=
page+1<=
page+1<=page_count 指最后一页 = 总页数
PHP_SELF 当前执行脚本的文件名
<nav aria-label="...">
<ul class="pager">
<?php if($page-1>0){ ?>
<li><a href="<?php echo $_SERVER['PHP_SELF'] ?>? page=<?php echo $page-1 ?>">上一页</a></li>
<?php } ?>
<?php if($page+1<=$page_count){ ?>
<li><a href="<?php echo $_SERVER['PHP_SELF'] ?>? page=<?php echo $page+1 ?>">下一页</a></li>
<?php } ?>
</ul>
</nav>
</div>
</div>
</div>