pdo捕获并输出mysql错误 [英] pdo catch and output mysql errors

问题描述

仍然试图让我了解pdo.

Still trying to get my head around pdo.

我有一个用pdo执行的插入语句.插入效果很好，但是如果出现错误，我希望向用户显示.

I have an insert statement that is executed with pdo. insert works great however if there is an error I would like it displayed to the user.

我有下面的try catch块.

I have the below try catch block.

try{ 
        $insertuser = $db->prepare('INSERT INTO `she_she`.`Persons` (`idnumber`,`addedby`,`firstname`, `middlename`, `surname`, `fullname`, `gender`, `birthdate`, `homelanguage`, `department`, `employeetype`, `employeestatus`) VALUES  (?,?,?,?,?,?,?,?,?,?,?,?)'); 
        $insertuser->execute(array($idnumber,$user,$firstname, $middlename, $surname, $fullname, $gender, $birthdate, $language, $department, $employmenttype, $personstatus));  
    } 
    catch(PDOException $exception){ 
        return $exception; 
    } 

如果查询失败，或者说重复的IDNumber，我希望向用户显示.

If the query fails, or lets say a duplicate IDNumber, I want this displayed to the user.

如果我只是尝试回显变量$ exception，它将不起作用.

If I simply try echo the variable $exception it does not work.

我想将mysql错误返回给用户.

I want to return the mysql error to the user.

任何建议一如既往.

谢谢， 瑞安

更新

根据建议的答案的新代码:

new code as per proposed answers:

   try{ 
        $insertuser = $db->prepare('INSERT INTO `she_she`.`Persons` (`idnumber`,`addedby`,`firstname`, `middlename`, `surname`, `fullname`, `gender`, `birthdate`, `homelanguage`, `department`, `employeetype`, `employeestatus`) VALUES  (?,?,?,?,?,?,?,?,?,?,?,?)'); 
        $insertuser->execute(array($idnumber,$user,$firstname, $middlename, $surname, $fullname, $gender, $birthdate, $language, $department, $employmenttype, $personstatus));  
    } 
    catch(PDOException $exception){ 
       return $exception->getMessage(); 
    } 
echo "exception: ".$exception;

推荐答案

默认情况下，PDO处于不会显示错误的状态.您需要在数据库连接中提供以下内容

By default PDO is not in a state that will display errors. you need to provide the following in your DB connection

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

更多信息可见此处

这篇关于pdo捕获并输出mysql错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！