<?php
//1.创建PDO对象，连接数据库
$pdo= new PDO('mysql:host=127.0.0.1;dbname=php_edu','root','root');
//2.创建预处理对象STMT
$sql="SELECT `id`,`name`,`email`,`create_time` FROM `user` WHERE `status`=:status";
$stmt =$pdo->prepare($sql);
//3.执行
$stmt->execute([':status'=>1]);
//4.遍历结果
$rows=[];
while ($row=$stmt->fetch(PDO::FETCH_ASSOC)){
$rows[]=$row;
}
//5.释放结果集
$stmt=null;
//6.关闭连接
$pdo=null;
//print_r($rows);
?>
<style>
table,th,td{
border: 1px solid #666;
}
table{
text-align: center;
border: 1px solid #666;
width: 50%;
margin: 30px auto;
border-collapse: collapse;
}
table caption{
font-size: 1.5em;
font-weight: bolder;
margin-bottom: 15px;
}
table tr:first-child{
background-color: chartreuse;
}
</style>
<table>
<caption>用户信息表</caption>
<tr>
<th>ID</th>
<th>姓名</th>
<th>邮箱</th>
<th>注册时间</th>
</tr>
<?php foreach ($rows as $row): ?>
<tr>
<td><?php echo $row['id'] ?></td>
<td><?php echo $row['name'] ?></td>
<td><?php echo $row['email'] ?></td>
<td><?php echo date('Y/m/d', $row['create_time']) ?></td>
</tr>
<?php endforeach; ?>
</table>
