要使用bootstrap,首先要引入bootstrap中的js和css;
<head>
<meta charset="UTF-8">
<title>Document</title>
<link rel="stylesheet" type="text/css" 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/bootstrap.min.js"></script>
</head>
创建数据库myschool:
id(int Primary Key) | user(varchar(50)) | create_time(varchar(100)) |
创建表单
<div class="container">
<div class="panel panel-primary">
<div class="panel-heading">用户注册</div>
<table class="table table-bordered table-striped table-hover">
<tr>
<th>用户名</th>
<th>创建日期</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>
</div>
</div>
响应式表格:table-responsive;表格边框:table-bordered;鼠标悬停:table-hover;隔行换色:table-striped;画板:panel;
分页:
<nav aria-label='...'>
<ul class='pager'>
<li><a href="#">上一页</a></li>
<li><a href="#">下一页</a></li>
</ul>
</nav>
设置时区date_default_timezone_set('PRC');设置北京时间
<?php
//设置时区
date_default_timezone_set('PRC');
//连接数据库
$conn=@new mysqli('localhost','root','','myschool');
if($conn->connect_error){
die('连接数据库失败');
}
//设置编码格式
$conn->set_charset('utf8');
//执行sql
$sql="select id,user,create_time from user";
$result=$conn->query($conn);
$arr=array();
while($row=$result->fetch_assoc()){
$arr[]=$row;
}
//释放结果集
$result->free();
//关闭连接数据库
$conn->close();