Default exception
Judging by if (! $affeected _row)
$DSN = "Mysql:host=localhost;dbname=test";
try{
$pdo =new PDO ($DSN, $username, $passwd);
echo "Connected successfully";
}catch (Pdoexception $e) {
echo "Connection failed". $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 ' <br> ';
Print_r ($pdo->errorinfo ());
}
Experience anomalies
Print to Page
$pdo->setattribute (Pdo::attr_errmode, pdo::errmode_warning);
Throws an exception.
Set Properties First
$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 "---<br>-"
}
echo "Connected to SS work";
PHP PDO errors in three modes