list.php代码,css文件自行调整路径
<?php
$db=new mysqli('localhost','root','root','rencai') or die('连接失败');
$sql="select * from user";
$isok=$db->query($sql);
while($row = mysqli_fetch_array($isok, MYSQLI_ASSOC)){
$allrow[]=$row;
}
?>
<html>
<head>
<title></title>
<link rel="stylesheet" href="/style/css/niuguwen.css">
</head>
<body>
<h1 class="tc">用户管理</h1>
<table class="table">
<tr>
<td>用户名</td>
<td>邮箱</td>
<td>注册时间</td>
<td>操作</td>
</tr>
<?php foreach($allrow as $key=>$value){?>
<tr>
<td><?php echo $value['username'];?></td>
<td><?php echo $value['email'];?></td>
<td><?php echo date('Y-m-d H:i:s',$value['addtime']);?></td>
<td><a href="/edit.php?id=<?php echo $value['id'];?>">编辑</a></td>
</tr>
<?php }?>
</table>
</body>
</html>- 文章导航