PDO获取sql错误代码 - 必须是整数类型

Question

How to get the error code from MYSQL via PDO as integer?

try{
    ...
}
catch(PDOException $e){
    throw new Fatal($e->getMessage(), $e->getCode());
}

$e->getCode() will return something like HY000

Argument 2 passed to Fatal::__construct() must be of the type integer, string given ...

... Fatal->__construct('SQLSTATE[HY000]...', 'HY000')

Answer 1

Take a look at $e->errorInfo.

http://php.net/manual/en/class.pdoexception.php says:

errorInfo

• Corresponds to PDO::errorInfo() or PDOStatement::errorInfo()

http://php.net/manual/en/pdostatement.errorinfo.php documents the fields returned by errorInfo().

Example:

try {
        $stmt = $pdo->query("Bogus Query");
} catch (PDOException $e) {
        echo "Caught exception!
";
        var_dump($e->errorInfo);
}

Output:

Caught exception!
array(3) {
  [0]=>
  string(5) "42000"
  [1]=>
  int(1064)
  [2]=>
  string(157) "You have an error in your SQL syntax; check the manual that corresponds to
      your MySQL server version for the right syntax to use near 'Bogus Query' at line 1"
}

You can see that the [1] element is an integer.