PDO异常报错处理

<strong><span style="font-size:14px;">代码1：</span></strong>

<?php
try{
	$pdo = new PDO("mysql:host=localhost;dbname=test","root","");
}catch(PDOException $e){
	die("数据库连接失败".$e->getMessage());
}
$sql = "insert into stu11 values(1,'aa',11)";
$res = $pdo->exec($sql);
if($res){
	echo "OK";
}else{
	echo $pdo->errorCode();

<span style="white-space:pre">	</span>echo "<br>";
	print_r($pdo->errorinfo());
}

<strong><span style="font-size:14px;">代码2：</span></strong>

<pre name="code" class="php"><?php
/* PDO::ATTR_ERRMODE
1)PDO::ATTR_ERRMODE 默认不报错误 0
2)PDO::ERRMODE_WARNING 警告 1
3)PDO::ERRMODE_EXCEPTION 异常 2 */
// setAttribute() getAttribute()
try{
	$pdo = new PDO("mysql:host=localhost;dbname=test","root","");
	$pdo->setAttribute(PDO::ATTR_ERRMODE,1);
}catch(PDOException $e){
	die("数据库连接失败".$e->getMessage());
}

$sql = "insert into stu values(3,'cc',33)";
/* try{
	$res = $pdo->exec($sql);
}catch(PDOException $e){
	echo $e->getMessage();
} */ //这种写法也能报错，但是我更喜欢下面这种
$res = $pdo->exec($sql);
if($res){
	echo "OK";
}