• By Prashant Dasnur
• March 22, 2025
• Web Development

Building a Simple CRUD App with PHP & MySQL

Creating a CRUD (Create, Read, Update, Delete) application is fundamental in web development. In this guide, we’ll build a simple CRUD app using PHP and MySQL.

1. Setting Up the Environment

Prerequisites:

• Install XAMPP or WAMP to set up a local server.
• Create a database in phpMyAdmin.

2. Creating the Database

CREATE DATABASE crud_app;
USE crud_app;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL UNIQUE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

3. Connecting PHP to MySQL

Create a db.php file for the database connection:

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

$conn = new mysqli($servername, $username, $password, $database);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
?>

4. Creating the CRUD Operations

Create (Insert Data)

<?php
include 'db.php';
if (isset($_POST['submit'])) {
    $name = $_POST['name'];
    $email = $_POST['email'];
    $sql = "INSERT INTO users (name, email) VALUES ('$name', '$email')";
    $conn->query($sql);
}
?>

Read (Display Data)

<?php
include 'db.php';
$result = $conn->query("SELECT * FROM users");
while ($row = $result->fetch_assoc()) {
    echo "ID: " . $row['id'] . " - Name: " . $row['name'] . " - Email: " . $row['email'] . "<br>";
}
?>

Update (Edit Data)

<?php
include 'db.php';
if (isset($_POST['update'])) {
    $id = $_POST['id'];
    $name = $_POST['name'];
    $email = $_POST['email'];
    $sql = "UPDATE users SET name='$name', email='$email' WHERE id=$id";
    $conn->query($sql);
}
?>

Delete (Remove Data)

<?php
include 'db.php';
if (isset($_GET['delete'])) {
    $id = $_GET['delete'];
    $sql = "DELETE FROM users WHERE id=$id";
    $conn->query($sql);
}
?>

5. Creating the User Interface

Create a simple index.php page with an HTML form to interact with the CRUD operations:

<form action="create.php" method="POST">
    <input type="text" name="name" placeholder="Enter Name" required>
    <input type="email" name="email" placeholder="Enter Email" required>
    <button type="submit" name="submit">Add User</button>
</form>

6. Conclusion

This simple PHP & MySQL CRUD app demonstrates the core functionalities of database interaction. You can expand it with better UI, validation, and security measures like prepared statements.

Happy coding! 🚀