摘要：<?php $dsn = 'mysql:host=127.0.0.1;dbname=php_edu;charset=utf8'; //1、创建PDO对象 $pdo = new PDO($dsn, 'root', '137582'); $sql = &q
<?php
$dsn = 'mysql:host=127.0.0.1;dbname=php_edu;charset=utf8';
//1、创建PDO对象
$pdo = new PDO($dsn, 'root', '137582');
$sql = "SELECT `id`,`name`,`sex`,`email`,`create_time` FROM `user` WHERE `status`=:status";
//2、创建预处理对象stmt
$stmt = $pdo->prepare($sql);
//3、执行查询
$stmt->execute([':status' => 2]);
//4、解析结果集
$rows = [];
while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
$rows[] = $row;
}
//5、关闭连接，释放变量
$stmt = null;
$pdo = null;
?>
<style>
table,th,td{
border: 1px solid #666;
}
table{
border: 1px solid #666;
width: 50%;
margin: 30px auto;
text-align: center;
border-collapse: collapse;
}
table caption{
font-size: 20px;
font-weight: bold;
}
table tr:first-child{
background-color: lightblue;
}
</style>
<table>
<caption>用户数据表</caption>
<tr>
<th>用户id</th>
<th>姓名</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['sex'] ?></td>
<td><?php echo $row['email'] ?></td>
<td><?php echo date('Y/m/d', $row['create_time']) ?></td>
</tr>
<?php endforeach; ?>
</table>
批改老师：天蓬老师批改时间：2019-05-27 09:02:29
老师总结：代码抄的正确....... , 希望下次能写得自己的东西
