In this blog, you’ll discover a step-by-step guide on creating a CRUD app in PHP, complete with MySQL integration. When learning a new programming language, mastering CRUD operations is fundamental. But what exactly does CRUD mean?

• • Create
  • Read
  • Update
  • Delete

The first step towards this is to make a database in your local server such as XAMPP. Type localhost/phpmyadmin in your browser URL. After this below screen will appear.

Create a new database for the CRUD app here or if you want to use an existing database click on the name of the database. Create a new table in the database. After the creation of the database and table, the next step is to create a folder inside xampp/htdocs with the name “crud-app” or you can choose a name according to your choice, next create a database connection between the database and your PHP code.

How to Create a MySQL Database Connection?

Create a file name db-conn.php.

The following code acts as the connection between the webpage and the database where the data from the webpage will be stored.

Change the username, password, and database name according to the name of them in your system.

How to Create Records?

The first operation in PHP CRUD Operations, Create, is responsible for creating tables or new records into an existing table. To do that, first, you must write the code for the webpage to create an entry in the database.

Create a file named create.php and insert the following code which will insert the form data to the backend.

How to Update Records?

The third operation i.e., ‘update’ is used to change or modify the already existing data present in the database.

To do this, you need to create another page to update the details in the database. Here, name the file as update.php

<?php
include "./db-conn.php";

$id = $_POST['id'];
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];

$sql= "UPDATE contacts SET name = ? email = ? phone = ?  WHERE id = ?";

<?php include "./db-conn.php"; $id = $_GET['id']; $sql = "DELETE FROM contacts WHERE id = ?"; $stmt = $conn->prepare($sql);
$stmt->bind_param("i", $id);
$stmt->execute();

if ($stmt->affected_rows > 0) {
    header("Location: /crud/");
    exit(); // Ensure no further execution of the script
} else {
    echo "Error deleting contact: " . $conn->error;
}

$stmt->close();
$conn->close();