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>
- 文章导航