php mysql pdo 错误_PHP pdo 错误的三种模式

默认异常

通过if(!$affeected_row) 判断

$dsn = "mysql:host=localhost;dbname=test";

try{

$pdo =new PDO($dsn, $username, $passwd);

echo "连接成功";

}catch(PDOException $e){

echo "连接失败".$e->getMessage();

}

echo $pdo->getAttribute(PDO::ATTR_ERRMODE);

//$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

echo $pdo->getAttribute(PDO::ATTR_ERRMODE);

$statement="select * from test;";

$affeected_row= $pdo->exec($statement);

if(!$affeected_row)

{

echo $pdo->errorCode();

echo '
';

print_r($pdo->errorInfo());

}

经验 异常

打印到页面

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

抛出异常。

首先设置属性

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

try{

$statement="select * from tesst1";

$affeected_row= $pdo->exec($statement);

}

catch (PDOException $e)

{

echo  $e->getMessage();

echo "---
-"

}

echo "连接成ss功";