Introduction to PHP CRUD Operations

In web development, managing data is a fundamental aspect of creating dynamic and interactive applications. CRUD operations, which stand for Create, Read, Update, and Delete, are the basic functions that enable you to interact with a database. These operations allow you to handle data in a systematic and organized way.

PHP, a popular server-side scripting language, is well-suited for implementing CRUD operations due to its powerful database interaction capabilities and ease of use. Whether you’re developing a small web application or a large-scale enterprise system, mastering CRUD operations in PHP is essential.

What is CRUD?

  • Create: Adding new records to the database.
  • Read: Retrieving and displaying existing records from the database.
  • Update: Modifying existing records in the database.
  • Delete: Removing records from the database.

Why Learn CRUD Operations?

  1. Core Functionality: CRUD operations form the backbone of many web applications, enabling data management and manipulation.
  2. Database Interaction: Understanding CRUD operations helps you efficiently interact with databases like MySQL, PostgreSQL, and others.
  3. Real-World Applications: Most real-world applications require data storage and retrieval, making CRUD operations essential.
  4. Foundation for Advanced Concepts: Mastering CRUD operations provides a solid foundation for learning more advanced topics in web development.

Complete Source Code for PHP CRUD Operations:

index.php

<?phpinclude 'backend/database.php';?><!DOCTYPE html><html lang="en"><head>	<meta charset="utf-8">	<meta http-equiv="X-UA-Compatible" content="IE=edge">	<meta name="viewport" content="width=device-width, initial-scale=1">	<title>User Data</title>	<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto|Varela+Round">	<link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">	<link rel="stylesheet" href="css/style.css">	<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>	<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>	<script src="ajax/ajax.js"></script></head><body>    <div class="container">	<p id="success"></p>        <div class="table-wrapper">            <div class="table-title">                <div class="row">                    <div class="col-sm-6">	<h2>Manage <b>Users</b></h2>		</div>	<div class="col-sm-6">	<a href="#addEmployeeModal" class="btn btn-success" data-toggle="modal"><i class="material-icons"></i> <span>Add New User</span></a>	<a href="JavaScript:void(0);" class="btn btn-danger" id="delete_multiple"><i class="material-icons"></i> <span>Delete</span></a>							</div>              </div>            </div>            <table class="table table-striped table-hover">                <thead>                    <tr>				<th>				<span class="custom-checkbox">				<input type="checkbox" id="selectAll">				<label for="selectAll"></label>				</span>				</th>		<th>SL NO</th>                        <th>NAME</th>                        <th>EMAIL</th>		<th>PHONE</th>                        <th>CITY</th>                        <th>ACTION</th>                    </tr>                </thead>	<tbody>			<?php	$result = mysqli_query($conn,"SELECT * FROM crud");	$i=1;	while($row = mysqli_fetch_array($result)) {	?>	<tr id="<?php echo $row["id"]; ?>">	<td>	<span class="custom-checkbox"><input type="checkbox" class="user_checkbox" data-user-id="<?php echo $row["id"]; ?>">	<label for="checkbox2"></label>	</span>	</td>	<td><?php echo $i; ?></td>      	<td><?php echo $row["name"]; ?></td><td><?php echo $row["email"]; ?></td>	<td><?php echo $row["phone"]; ?></td>	<td><?php echo $row["city"]; ?></td>	<td>	<a href="#editEmployeeModal" class="edit" data-toggle="modal">	<i class="material-icons update" data-toggle="tooltip" data-id="<?php echo     $row["id"]; ?>"	data-name="<?php echo $row["name"]; ?>"	data-email="<?php echo $row["email"]; ?>"	data-phone="<?php echo $row["phone"]; ?>"	data-city="<?php echo $row["city"]; ?>"	title="Edit"></i>	</a><a href="#deleteEmployeeModal" class="delete" data-id="<?php echo $row["id"]; ?>" data-toggle="modal"><i class="material-icons" data-toggle="tooltip"  title="Delete"></i></a>      </td></tr><?php$i++;	}	?></tbody></table>			        </div>    </div>
PHP

backend/database.php

<?php$servername = "localhost";$username = "root";$password = "";$dbname = "user";$conn = mysqli_connect($servername, $username, $password, $dbname);if (!$conn) {    die("Connection failed: " . mysqli_connect_error());}?>
PHP

backend/save.php

<?phpinclude 'database.php';if(count($_POST)>0){	if($_POST['type']==1){		$name=$_POST['name'];		$email=$_POST['email'];		$phone=$_POST['phone'];		$city=$_POST['city'];		$sql = "INSERT INTO `crud`( `name`, `email`,`phone`,`city`) 		VALUES ('$name','$email','$phone','$city')";		if (mysqli_query($conn, $sql)) {			echo json_encode(array("statusCode"=>200));		} 		else {			echo "Error: " . $sql . "<br>" . mysqli_error($conn);		}		mysqli_close($conn);	}}if(count($_POST)>0){	if($_POST['type']==2){		$id=$_POST['id'];		$name=$_POST['name'];		$email=$_POST['email'];		$phone=$_POST['phone'];		$city=$_POST['city'];		$sql = "UPDATE `crud` SET `name`='$name',`email`='$email',`phone`='$phone',`city`='$city' WHERE id=$id";		if (mysqli_query($conn, $sql)) {			echo json_encode(array("statusCode"=>200));		} 		else {			echo "Error: " . $sql . "<br>" . mysqli_error($conn);		}		mysqli_close($conn);	}}if(count($_POST)>0){	if($_POST['type']==3){		$id=$_POST['id'];		$sql = "DELETE FROM `crud` WHERE id=$id ";		if (mysqli_query($conn, $sql)) {			echo $id;		} 		else {			echo "Error: " . $sql . "<br>" . mysqli_error($conn);		}		mysqli_close($conn);	}}if(count($_POST)>0){	if($_POST['type']==4){		$id=$_POST['id'];		$sql = "DELETE FROM crud WHERE id in ($id)";		if (mysqli_query($conn, $sql)) {			echo $id;		} 		else {			echo "Error: " . $sql . "<br>" . mysqli_error($conn);		}		mysqli_close($conn);	}}?>
PHP