CRUD Operation in PHP With Live Example!

Table of Contents

What is CRUD?

CRUD operations are basic information manipulation for databases. We’ve already learned a way to perform produce (i.e. insert), read (i.e. select), update, and delete operations in previous chapters. during this tutorial, we’ll produce a straightforward PHP application to perform these operations on a MySQL information table in one place.

What’s CRUD Full Form?

CRUD is a word form for Create, Read, Update, and Delete.

CRUD operation in PHP MySQL

Well, let’s begin by making the table that we’ll use all told of our examples.

Create new Database
Create new table
Create index.php file
Create server.php file
Create style.css file

1.Create new Database

create new database ( crud ). crud is database name.

2.Create new table

create new table ( info ). info is table name.

3.Create index.php file

create an index.php file on your computer and create a form now add PHP in your index.php file and include your server.php file also.

<?php 
include('server.php');

// fetch the record to be updated
	if (isset($_GET['edit'])) {
		$id = $_GET['edit'];
		$edit_state = true;
		$rec = mysqli_query($db, "SELECT * FROM info WHERE  id='$id'" );
		$record =mysqli_fetch_array($rec);
		$name = $record['name'];
		$address = $record['address'];
		$id = $record['id'];
	}

?>

<!DOCTYPE html>
<html>
<head>
	<title>crud one page</title>
	<link rel="stylesheet" type="text/css" href="style.css">
	<style type="text/css">
		
.msg{
	margin:30px auto;
	padding: 10px;
	border-radius: 5px;
	color: yellow;
	background:blue;
	width: 50%;
	text-align: center;

	</style>
</head>
<body>
<?php if (isset($_SESSION['msg'])): ?>
<div class="msg">
	<?php 
		echo $_SESSION['msg'];
		unset($_SESSION['msg']);
	?>
</div>
<?php endif ?>

<table>
	<thead>
	<tr>
		</tr>
		<th>name</th>
		<th>address</th>
		<th colspan="2">action</th>
	</tr>
	</thead>
	<tbody>
<?php while ($row = mysqli_fetch_array($results)) {  ?>
 		<tr>
		<td><?php echo $row['name']; ?></td>
		<td><?php echo $row['address']; ?></td>
		<td>
			<a href="index.php?edit=<?php echo $row['id']; ?>">edit</a>
		</td>
		<td>
			<a href="server.php?del=<?php echo $row['id']; ?>">delete</a>
		</td>
	</tr>
 <?php	
}
?>

	
	</tbody>
</table>

<form method="post" action="">
	<input type="hidden" name="id" value="<?php echo $id; ?>">
	<div class="input-group">
		<label>Name</label>
		<input type="text" name="name" value="<?php echo $name; ?>" >
	</div>
	<div class="input-group">
		<label>Address</label>
		<input type="text" name="address" value="<?php echo $address; ?>">
	</div>
	<div class="input-group">
		<?php if ($edit_state == false) : ?>
		<button type="submit" name="save" class="btn">save</button>
		<?php else: ?>
		<button type="submit" name="update" class="btn">update</button>
		<?php endif ?>
	</div>
</form>


</body>
</html>

output:-

4.Create server.php file

now create server.php file in computer and PHP code written first insert query, second view query, third update query, and last four delete query insert in server.php

<?php 
	session_start();

// initialize variables
	$name = "";
	$address = "";
	$id = 0;
	$edit_state = false;

// connect to database

// if save btn is click
$db = mysqli_connect('localhost','root','','crud');


if (isset($_POST['save'])) {
	$name = $_POST['name'];
	$address = $_POST['address'];

	$query = "INSERT INTO info (name,address) VALUES ('$name','$address')";
	mysqli_query($db,$query);
	$_SESSION['msg']  = "address delete";
			header('location:index.php');//redirect to index page after inserting 
}

//update record
		if (isset($_POST['update'])) {
			$name = mysqli_real_escape_string($db, $_POST['name']);
			$address = mysqli_real_escape_string($db, $_POST['address']);
			$id = mysqli_real_escape_string($db, $_POST['id']);

			$data= mysqli_query($db, "UPDATE info SET name='$name', address='$address' WHERE id='$id' ");
			if ($data) {
					echo "<script>alert('update')</script>";
				}
		}

// delete record

	if (isset($_GET['del'])) {
		$id = $_GET['del'];
		mysqli_query($db, "DELETE FROM info WHERE id='$id'");
				$_SESSION['msg']  = "address delete";
			header('location:index.php');

	}

//retrieve records
	$results = mysqli_query($db, "SELECT * FROM info");

?>

5.Create style.css file

You add steel.css to make your crud table look good.

body{
	font-size: 20px;
}
table{
	width: 50%;
	margin:30px auto;
	border-collapse: collapse;
	text-align: left;
}
tr{
	border-bottom: 1px solid black;
}
tr, td{
	border: none;
	height: 30px;
	padding: 3px;
}
tr:hover {
	background:#f5f5f5;
}
form{
	width: 50%;
	margin: 50px auto;
	text-align: left;
	padding: 20px;
	border: 1px solid black;
	border-radius: 5px;
}
.input-group{
	margin: 10px 0px 10px 0px;
}
.input-group label{
	display: block;
	text-align: left;
	margin: 3px;
}
.input-group input{
	height: 30px;
	width: 93%;
	padding: 5px 10px;
	font-size: 16px;
	border-radius: 5px;
	border: 1px solid gray;
}
.btn{
padding: 10px;
font-size: 15px;
color: white;
background:#5F9EA0;
border:none;
border-radius: 5px; 
}

}

How to Create CRUD ??

CRUD means is Create, Read, Update, and Delete.

CRUD ( Insert, Show, Update and delete ) in PHP zip.file here Download link.

Click here download zip file