CRUD (Create, Read, Update, Delete) operations are fundamental when working with databases. In this guide, we'll explore how to perform these operations using PHP and PDO (PHP Data Objects), a database abstraction layer that provides a consistent interface for database interactions.

Connecting to the Database

To get started with PDO, you need to establish a database connection. Here's an example of how to connect to a MySQL database:

        <?php
        $host = 'localhost';
        $dbname = 'your_database';
        $username = 'your_username';
        $password = 'your_password';
        try {
         $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
         echo "Connected to the database";
        } catch (PDOException $e) {
         die("Error: " . $e->getMessage());
        }
        ?>
    

Creating Records (Create - INSERT)

To insert data into the database, you can use the

INSERT

        <?php
        $name = 'John Doe';
        $email = 'john@example.com';
        $stmt = $pdo->prepare("INSERT INTO users (name, email) VALUES (?, ?)");
        $stmt->execute([$name, $email]);
        echo "Record created successfully";
        ?>
    

Reading Records (Read - SELECT)

To retrieve data from the database, you can use the

SELECT

        <?php
        $stmt = $pdo->query("SELECT * FROM users");
        while ($row = $stmt->fetch()) {
         echo "Name: " . $row['name'] . ", Email: " . $row['email'] . "<br>";
        }
        ?>
    

Updating Records (Update - UPDATE)

To modify existing data, you can use the

UPDATE

        <?php
        $newEmail = 'new_email@example.com';
        $userId = 1;
        $stmt = $pdo->prepare("UPDATE users SET email = ? WHERE id = ?");
        $stmt->execute([$newEmail, $userId]);
        echo "Record updated successfully";
        ?>
    

Deleting Records (Delete - DELETE)

To remove data from the database, you can use the

DELETE

        <?php
        $userId = 1;
        $stmt = $pdo->prepare("DELETE FROM users WHERE id = ?");
        $stmt->execute([$userId]);
        echo "Record deleted successfully";
        ?>
    

Conclusion

PHP CRUD operations with PDO provide a powerful way to interact with databases. Whether you're creating, reading, updating, or deleting records, PDO simplifies the process while maintaining security and reliability in your database interactions.