pdoException.php
<?php
//默认是不提示的 需要用 errorCode() errorInfo() 查看错误信息;
try{
$pdo = new PDO("mysql:host=localhost;dbname=数据库名","root","密码");
//$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_WARNING); //以警告形式报错
//$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION ); //以异常形式报错
$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_SILENT); //默认是该方式,不提示错误
}catch(PDOException $e){
die("数据库连接失败".$e->getMessage());
}
$sql = "insert into stuu values(null,'jike','w',55)"; //错误的sql语句
try{
$res = $pdo->exec($sql);
}catch(PDOException $e){
echo $e->getMessage();
}
/* if($res){
echo "OK";
}else{
//echo $pdo->errorCode();
//print_r($pdo->errorInfo());
} */