摘要：<?php // 数据库连接信息 $type = 'mysql'; $host = '127.0.0.1'; $dbName&nbs
<?php
// 数据库连接信息
$type = 'mysql';
$host = '127.0.0.1';
$dbName = 'php_io';
$charset = 'utf8';
$user = 'root';
$password = 'root';
$dsn = $type.':host='.$host.';dbname='.$dbName.';charset='.$charset;
$pdo = new PDO($dsn,$user,$password);
//预定义语句
$sql = "SELECT `id`,`name`,`sex`,`age`, `email`,`create_time` FROM `user` WHERE `age`>:age LIMIT :num";
$stmt = $pdo->prepare($sql);
//设置显示记录条数
$num = 6;
//筛选条件
$age = 65;
//参数绑定
$stmt ->bindParam(':num',$num,$pdo::PARAM_INT);
$stmt ->bindValue(':age',$age,$pdo::PARAM_INT);
//执行预定义语句
$stmt->execute();
//解析遍历
$res = $stmt->fetchAll($pdo::FETCH_ASSOC);
// 关闭连接
$stmt = null;
$pdo = null;
?>
<!----------------------------表格样式------------------------------------------------->
<style>
.table{
margin:50px auto;
width: 80%;
}
.table,th,td{
border: 1px solid #ccc;
border-collapse: collapse;
text-align: center;
}
.table caption{
font-size: 1.5em;
font-weight: bold;
background-color: lightblue;
}
</style>
<!----------------------------------------------表格模板--------------------------------------------->
<table class="table">
<caption>梁山英雄榜</caption>
<tr>
<th>工号</th>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
<th>邮箱</th>
<th>上山时间</th>
</tr>
<?php foreach ($res 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['age']?></td>
<td><?php echo $row['email']?></td>
<td><?php echo date('Y-m-d',$row['create_time'])?></td>
</tr>
<?php endforeach;?>
</table>
经过本章节的学习练习对PDO操作数据库技术基本掌握。数据库技术过多强大，后续更加深入学习才能掌握得更加得心应手
批改老师：天蓬老师批改时间：2019-04-14 21:52:25
老师总结：数据表的操作, 也前端密不可分的, 其实你的这个作业, 已经有点MVC的特点了
