php【基础学习二十】PDO

具体参考：http://blog.csdn.net/leo115/article/details/7538983

明天再来自己写，先写个标题

PDO对象初始化
		PDO __construct( string dsn 
			[, string username 
			[, string password 
			[, array driver_options]]] );
	         dsn数据库连接信息如“mysql:host=localhost;dbname=库名”
driver_options：	//配置选项

PDO对象成员方法
	1 ) query($sql);  	//用于执行查询SQL语句。返回PDOStatement对象
	2 ) exec($sql);  		//用于执行增、删、改操作，返回影响行数；
	3 ) setAttribute(); 	//设置一个"数据库连接对象"属性。
         4 ) fetchAll();		//解析数据

<?php
//$mysqli = new mysqli("localhost","user","password","dbname");
try{
	//1.$pdo = new PDO("mysql:host=localhost;dbname=hyerp","root","");
	//2.$pdo = new PDO("uri:mysqlPdo.ini","root","");
	//3.$pdo = new PDO("mysqlpdo","root","");
	$pdo = new PDO("mysqlpdo","root","");
	$pdo->setAttribute(PDO::ATTR_AUTOCOMMIT,0);
}catch(PDOException $e){
	die("数据库连接失败".$e->getMessage());
}
echo $pdo->getAttribute(PDO::ATTR_AUTOCOMMIT );

//print_r($pdo);

<?php
//1.连接数据库
try{
	$pdo = new PDO("mysql:host=localhost;dbname=jikexueyuan","root","");
}catch(PDOException $e){
	die("数据库连接失败".$e->getMessage());
}


//2.执行query(查询)返回的是一个预处理对象
	$sql = "select * from stu";
	$stmt = $pdo->query($sql);
	$list = $stmt->fetchAll(PDO::FETCH_ASSOC);
	
//3.解析数据（一次把所有的数据解析完）
	foreach($list as $val){
		echo $val['id']."-------".$val['name']."<br>";
	}
	

//4.释放资源
	$stmt = null;
	$pdo = null;

<?php
//1.连接数据库
try{
	$pdo = new PDO("mysql:host=localhost;dbname=jikexueyuan","root","");
}catch(PDOException $e){
	die("数据库连接失败".$e->getMessage());
}

//这是一种快捷的方法
/* $sql = "select * from stu";
foreach($pdo->query($sql) as $val){
	echo $val['id']."-----".$val['name']."<br>";
} */

//$sql = "insert into stu values(null,'oracle','w',44)";
//$sql = "delete from stu where id=11";
$sql = "update stu set name='js' where id=3";
$res = $pdo->exec($sql);
if($res){
	echo "success";
}