PHP PDO Error Handling 🎯

Welcome to the PHP PDO Error Handling tutorial! In this lesson, we'll explore how to handle errors effectively when using PHP Data Objects (PDO) for database interactions.

What is PDO? 📝

PDO, or PHP Data Objects, is a PHP extension for accessing databases. It provides a consistent interface for working with different database systems like MySQL, PostgreSQL, Oracle, etc.

Importance of Error Handling 💡

Error handling is crucial when working with databases. It helps us understand and fix issues that may arise during the execution of our code. In this tutorial, we'll learn how to handle errors using PDO exceptions.

Getting Started with PDO 📝

First, let's include the PDO library in our PHP script:

php

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

In the above code, we're creating a new PDO instance, connecting to our testdb database on localhost using a username and password. If an error occurs during the connection process, it will be caught and an error message will be displayed.

PDO Error Modes 📝

PDO offers three error modes:

PDO::ERRMODE_SILENT (suppress errors)
PDO::ERRMODE_WARNING (display warnings)
PDO::ERRMODE_EXCEPTION (throw exceptions for errors and warnings)

In our example, we're using PDO::ERRMODE_EXCEPTION to throw exceptions for both errors and warnings.

Handling Queries 📝

Now, let's write a simple query and see how PDO handles errors:

php

try {
    $stmt = $db->query('SELECT * FROM users WHERE id = 999');
    $result = $stmt->fetchAll();
    echo "<pre>";
    print_r($result);
    echo "</pre>";
} catch (PDOException $e) {
    echo "Query failed: " . $e->getMessage();
}

In this example, we're executing a query to fetch all records from the users table where id is 999. If such a user doesn't exist, PDO will throw an exception, and we'll display an error message.

Advanced Error Handling 📝

Sometimes, we might want to handle specific errors differently. We can use the getCode() and getMessage() methods of PDOException to get more details about the error:

php

try {
    // some code that may throw an exception
} catch (PDOException $e) {
    if ($e->getCode() == 23000) {
        echo "Unique constraint violation.";
    } else {
        echo "Generic database error: " . $e->getMessage();
    }
}

In the above example, we're checking if the error code is 23000, which indicates a unique constraint violation. If it is, we display a specific error message. Otherwise, we display a generic error message.

PHP PDO Error Handling 🎯

PHP PDO Error Handling 🎯

What is PDO? 📝

Importance of Error Handling 💡

Getting Started with PDO 📝

PDO Error Modes 📝

Handling Queries 📝

Advanced Error Handling 📝

Quiz 🎯