pdo预处理

<?php

//链接数据库

$dsn="mysql:host=127.0.0.1;dbname=jq";

$pdo=new PDO($dsn,"root","root");

//防乱码

$pdo->exec("set names utf8");

//准备语句

$sql="select * from lianxi1 where name=:name";

$stem=$pdo->prepare($sql);

//绑定参数

$stem->execute(array(":name"=>"李四"));

//执行

$list=$stem->fetchAll(PDO::FETCH_ASSOC);
?>
<table border="1">
<th>编号</th>
<th>名字</th>
<th>密码</th>
<th>邮箱</th>
<th>状态</th>
<?php foreach($list as $k=>$v){ ?>
<tr>
<td><?php echo $v["id"]?></td>
<td><?php echo $v["name"]?></td>
<td><?php echo $v["pwd"]?></td>
<td><?php echo $v["mail"]?></td>
<td><?php echo $v["status"]?></td>
</tr>
<?php } ?>
</table>