PHP PDO:显示错误 [英] PHP PDO: Displaying errors

问题描述

我是否需要使用try and catch块来显示PHP的PDO扩展错误?

Do I need to use the try and catch block to display errors with PHP's PDO extension?

例如，使用mysql，您通常可以执行以下操作:

For example, with mysql you can usally do something like:

if ( ! $query)
{
    die('Oh noes!');
}

推荐答案

public static function qry($sql) {
    try {
    $statement = $db_handle->prepare($sql);
    $retval = $statement->execute();
    if($statement->rowCount() >= 1) { 
        //do something               
    }else {
    $errors = $statement->errorInfo();
    echo $errors[2] . ", " . $errors[1] . " ," . $errors[0];
}
} catch (Exception $e) {
echo $e->getMessage();
}        
}

这篇关于PHP PDO:显示错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！