pdo预处理

<?php
header('content-type:text/html;charset=utf-8');
try {
	$pdo = new PDO('mysql:host=127.0.0.1;dbname=other', 'root', 'root');
	$pdo -> exec('set names utf8');
} catch(PDOException $error) {
	echo $error -> getMessage();
}
/*
 * 增  1
 * */
$sql = 'insert into user (name,pwd) values(:name,:pwd)';
$stemt = $pdo -> prepare($sql);
$id = $stemt -> execute([':name'=>'网吧',':pwd'=>1000]); 
if($id){
	echo '执行成功最后插入的ID:',$pdo->lastInsertId();

}else{
	 exit("执行失败");

}
/*
 * 增  2
 * */
$sql = 'insert into user (name,pwd) values(:name,:pwd)';
$stemt = $pdo -> prepare($sql);
$stemt -> bindparam(":name", $name);
$stemt -> bindparam(":pwd", $pwd);
$name ='网吧';
$pwd = 1000;
$id=$stemt -> execute();
if($id){
	echo '执行成功最后插入的ID:',$pdo->lastInsertId();

}else{
	 exit("执行失败");

}
/*
 * 增  3
 * */
$sql = 'insert into user (name,pwd) values(?,?)';
$stemt = $pdo -> prepare($sql);
$stemt -> bindparam(1, $name);
$stemt -> bindparam(2, $pwd);
$name = '呵呵';
$pwd = 1000;
$id=$stemt -> execute();
if($id){
	echo '执行成功最后插入的ID:',$pdo->lastInsertId();

}else{
	 exit("执行失败");

}
/*
 * 增  4
 * */
$sql = 'insert into user (name,pwd) values(?,?)';
$stemt = $pdo -> prepare($sql);
$id = $stemt -> execute(['网',250]);
if($id){
	echo '执行成功最后插入的ID:',$pdo->lastInsertId();

}else{
	 exit("执行失败");

}
/*
 * 查询1
 * */
$sql ='select * from user where uid>=:uid';
$stemt = $pdo -> prepare($sql);
//设置模式 以关联输出
$stemt->setFetchMode(PDO::FETCH_ASSOC); 
$stemt -> execute([':uid'=>12]);
//fetch 取单条数据的
while($row=$stemt -> fetch()){
	var_dump($row);
}
/*
 * 查询2
 * */
$sql ='select * from user where uid>=:uid';
$stemt = $pdo -> prepare($sql);
$stemt -> execute([':uid'=>12]);
$stemt->setFetchMode(PDO::FETCH_ASSOC); 
$stemt = $stemt ->  fetchAll();
//fetchAll 取二维数组的形式
var_dump($stemt);
/*
 * */
 /* 
     * 其实$sql没有什么区别 我建议大家用:号占位符 
     * PDO预处理好处是
     * 节省带宽 把相应的sql语句准备好
     * 防止sql注入
     * 他会把占位符当做一个整体进行处理
     * 建议大家在插入成功是进行判断一下

*/