How can one properly handle error codes, such as Error 2, when executing PHP scripts for database operations?

When handling error codes like Error 2 in PHP scripts for database operations, it is important to use try-catch blocks to catch any exceptions that may occur during the execution of the script. Within the catch block, you can log the error message or display a user-friendly error message to inform the user of the issue.

try {
    // Database connection and query execution
} catch (Exception $e) {
    // Log the error message
    error_log($e->getMessage());
    
    // Display a user-friendly error message
    echo "An error occurred while processing your request. Please try again later.";
}