Learn how to manipulate MySQL database records using PHP and PDO securely and efficiently.
🧩 Why Learn CRUD Operations?
CRUD stands for Create, Read, Update, and Delete — the four basic functions of persistent storage. In PHP, performing these actions with a MySQL database is essential for building dynamic applications.
📝 Insert Data
<?php $pdo = new PDO("mysql:host=localhost;dbname=demo", "user", "pass"); $stmt = $pdo->prepare("INSERT INTO users (username, email) VALUES (:username, :email)"); $stmt->execute([ 'username' => 'john_doe', 'email' => '[email protected]' ]); echo "Data inserted successfully."; ?>🔁 Update Data
<?php $stmt = $pdo->prepare("UPDATE users SET email = :email WHERE username = :username"); $stmt->execute([ 'username' => 'john_doe', 'email' => '[email protected]' ]); echo "Data updated successfully."; ?>🗑️ Delete Data
<?php $stmt = $pdo->prepare("DELETE FROM users WHERE username = :username"); $stmt->execute(['username' => 'john_doe']); echo "Data deleted successfully."; ?>✅ Best Practices
- Use prepared statements to avoid SQL injection
- Always validate and sanitize user input
- Check affected rows with
rowCount()if needed - Log changes if you're performing sensitive updates or deletions
🧾 Summary
Performing insert, update, and delete operations in PHP using PDO is both secure and efficient. These CRUD operations are the backbone of most PHP-based web applications. Mastering them is key to becoming a confident backend developer.