douxunchen3498 2017-11-23 05:58
浏览 20
已采纳

生产服务器上的Php PDO错误处理[重复]

This question already has an answer here:

Should i use try catch for every conn statements and do i need to set this every time during query execution

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

Can some one please tell me the better approach to execute queries using pdo in a better way with general error displaying to user

</div>
  • 写回答

1条回答 默认 最新

  • dougu1990 2017-11-23 06:03
    关注

    Never echo out your errors in production. Use a try catch statement and then log it to a file.

    try {
    //your whole application code here
    } catch( Exception $e)  {
    error_log($e);//log the actual error
    echo 'an unexpected error occurred';//send generic error message 
    exit; 
    }
    

    Also you don't need to set attribute for every query. I assume you're not initializing the connection everytime. You can always initialize the connection in a file and include it where you need it. Thereby setting attribute once

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?