How can error handling be improved when using PDO in PHP?

When using PDO in PHP, error handling can be improved by setting the error mode to PDO::ERRMODE_EXCEPTION. This will cause PDO to throw exceptions when errors occur, allowing for easier and more structured error handling in your code. 

try {
    $pdo = new PDO("mysql:host=localhost;dbname=mydatabase", "username", "password");
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

Keywords

PDO error handling exceptions try-catch SQL queries

Related Questions