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

Question

This question already has an answer here:

• My PDO Statement doesn't work 1 answer

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>

Answer 1

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