PHP CRUD Operations

PHP CRUD Operations – Create, Read, Update, Delete 🛠️

Every dynamic website needs CRUD operations to manage data. Whether it’s users, posts, or even your collection of cat memes 🐱, CRUD allows you to Create, Read, Update, and Delete records from a database.

In this tutorial, we will use MySQLi to perform CRUD operations in PHP.

🔹 1. Connecting to MySQL Database

Before we start CRUD operations, we need to connect to our database.

📝 Example: Database Connection

<?php
$servername = "localhost";
$username = "root";
$password = "";
$database = "crud_db";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully!";
?>

Try It Now

🔹 2. Creating a Table

Let’s create a users table to store user details.

📝 Example: Creating Table

<?php
$conn = new mysqli("localhost", "root", "", "crud_db");

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Create table
$sql = "CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL
)";

if ($conn->query($sql) === TRUE) {
    echo "Table 'users' created successfully!";
} else {
    echo "Error creating table: " . $conn->error;
}

$conn->close();
?>

Try It Now

🔹 3. Create (Insert Data)

Use INSERT INTO to add new users.

📝 Example: Inserting Data

<?php
$conn = new mysqli("localhost", "root", "", "crud_db");

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Insert data
$sql = "INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')";

if ($conn->query($sql) === TRUE) {
    echo "New user added successfully!";
} else {
    echo "Error: " . $conn->error;
}

$conn->close();
?>

Try It Now

🔹 4. Read (Retrieve Data)

Use SELECT to fetch user records.

📝 Example: Retrieving Data

<?php
$conn = new mysqli("localhost", "root", "", "crud_db");

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Retrieve data
$sql = "SELECT id, name, email FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "ID: " . $row["id"] . " - Name: " . $row["name"] . " - Email: " . $row["email"] . "<br>";
    }
} else {
    echo "No records found!";
}

$conn->close();
?>

Try It Now

🔹 5. Update (Modify Data)

Use UPDATE to modify user details.

📝 Example: Updating Data

<?php
$conn = new mysqli("localhost", "root", "", "crud_db");

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Update user data
$sql = "UPDATE users SET email='john.doe@example.com' WHERE name='John Doe'";

if ($conn->query($sql) === TRUE) {
    echo "User details updated!";
} else {
    echo "Error updating user: " . $conn->error;
}

$conn->close();
?>

Try It Now

🔹 6. Delete (Remove Data)

Use DELETE to remove a user from the database.

📝 Example: Deleting Data

<?php
$conn = new mysqli("localhost", "root", "", "crud_db");

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Delete user
$sql = "DELETE FROM users WHERE name='John Doe'";

if ($conn->query($sql) === TRUE) {
    echo "User deleted!";
} else {
    echo "Error deleting user: " . $conn->error;
}

$conn->close();
?>

Try It Now

🎯 Summary of CRUD Operations

  • Create – Add new data (INSERT)
  • Read – Retrieve existing data (SELECT)
  • Update – Modify existing data (UPDATE)
  • Delete – Remove data (DELETE)

Now it’s your turn! Experiment with different values and build your own CRUD-based applications. 🚀