摘要：<?php
//1.连接数据库
$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu;charset=utf8;','root','root');
//2.准备预处理语句
$stmt = $pdo->prepare('SELECT&
<?php
//1.连接数据库
$pdo = new PDO('mysql:host=127.0.0.1;dbname=php_edu;charset=utf8;','root','root');
//2.准备预处理语句
$stmt = $pdo->prepare('SELECT `name`,`password`,`create_time`,`email` FROM `user` WHERE id>=:id');
$id = 1;
$stmt->bindParam(':id',$id);//绑定参数，和bindValue区别在于它的第二个参数只能是变量，不能是字面量
if($stmt->execute()){//判断语句是否执行成功
//绑定列
$stmt->bindColumn(1,$name,PDO::PARAM_STR);
$stmt->bindColumn(2,$passwd,PDO::PARAM_STR);
$stmt->bindColumn(3,$createTime,PDO::PARAM_INT);
$stmt->bindColumn(4,$email,PDO::PARAM_STR);
while($stmt->fetch(PDO::FETCH_BOUND)){
$rows[] = compact('name','passwd','createTime','email');
}
}
?>
<table cellpadding="0" cellspacing="0" border="1" style="border:1px solid #333;width: 50%;margin:30px auto;">
<caption style="background: deepskyblue;">用户表</caption>
<tr>
<td>姓名</td>
<td>密码</td>
<td>邮箱</td>
<td>添加时间</td>
</tr>
<?php foreach($rows as $row):?>
<tr>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['passwd'];?></td>
<td><?php echo $row['email'];?></td>
<td><?php echo date('Y/m/d',$row['createTime']);?></td>
</tr>
<?php endforeach;?>
</table>
