1、PDO 链接数据库
<?php
echo "<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />";
try{
$pdo = new PDO('mysql:host=localhost;dbname=test','root','root'); //第四个参数用来设置数据库的属性
//设置错误异常
$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
}catch(PDOException $e){
echo "失败".$e->getMessage();
exit;
}
2、插入数据
try{
$result=$pdo->exec("insert into aaa (name,sex,age) values('王宝江','1','17')");
//var_dump($pdo->lastinsertid()); 获取最后插入的id
}catch(PDOException $e){
echo "失败".$e->getMessage();
}
3、查询操作
try{
$result=$pdo->query('explain select name from aaa where id = 0');
$result->setFetchMode(PDO::FETCH_ASSOC); //设置返回结果为关联数组
print_r($result->fetchAll()); //输出全部结果
}catch(PDOException $e){
echo $e->getMessage();
}
4预编译(防止sql注入、提高运行效率)
try{
//给服务器只编译不执行
$result=$pdo->prepare("insert into aaa (name,sex,goods) values(:name,:sex,:goods)");
//绑定参数
$result->bindParam("name",$name,PDO::PARAM_STR);
$result->bindParam("sex",$sex);
$result->bindParam("goods",$goods);
//给变量赋值
$name = 222;
$sex = 1;
$goods = 5;
//执行
$result->execute();
$result->execute(array('name'=>'wbj',sex'666','888'));
}catch(PDOException $e){
echo $e->getMessage();
}