Today, we are going to talk about CRUD Operation which means CREATE, READ, UPDATE and DELETE. It is the very first and basic thing which we need to deal with if we are thinking to create any application which will save users data into database. So, we will be using PHP as a server side scripting language and an open source database as MySQL for storing our data. By integrating both we will write a code that will perform the CRUD Operations. Before starting I am hoping that you are familiar with PHP and MySQL.

Download Script 88 downloads Live Demo

First, We will create a custome table, name "MyData" for storing our data

Creating Database and Table

First I have created a Database with name "inspire2code" and then i have created a "MyData" table in that database

CREATE TABLE `inspire2code`.`wall`
  ( `ID` INT(100) NOT NULL AUTO_INCREMENT ,
 `Name` VARCHAR(200) NOT NULL ,
 `Content` VARCHAR(200) NOT NULL ,
 `ProfileImg` VARCHAR(200) NOT NULL ,
  PRIMARY KEY (`ID`)) ENGINE = MyISAM;

index.php : We are Performing Insert & View Operation on the same page

Post Insertion Design

<div class="Main">
<h1 style="font-size:28px;" align="center">Implementing CRUD Operation on Wall Feed</h1>
<div class="InnerMain">
<div class="ProfileDiv" ><img src="profile.jpg" class="Profile" /></div>
<div class="ContentDiv">
<form method="post" action="">
<textarea class="TextArea" name="Content"></textarea>
<input type="submit" class="btn btn-outline-info" style="margin-top:10px;" name="Post" value="POST" />
</form>
</div>
</div>
</div>

We are creating a separate file for connection and then we will import in index.php using

 <?php

//defining name
define('SERVER', 'localhost');
define('USER', 'root');
define('PASSWORD', '');
define('DB', 'inspire2code');

//Establishing connection to mysql
$link = mysqli_connect(SERVER, USER, PASSWORD, DB)
        or die("Erro-> ".mysqli_connect_error());


?>   

These codes will come in action when you trigger the POST Button.

<?php
require('DbConfig.php');

if(isset($_POST['Post'])) {

$Content=trim($_POST['Content']);
$Content = mysqli_escape_string($link,$Content);
$Name="Rohit Sharma";
$ProfileImg = "Profile.jpg";
if(!empty($Content)) {
$Query= "INSERT INTO `wall` SET
         Name       = '$Name',
		 Content    = '$Content',
		 ProfileImg = '$ProfileImg'";

$Execute = mysqli_query($link,$Query);

if($Execute==true)
{

//Do Something

	}
                      }
                             }

?>  

index.php : Now, We are Performing View Operation on the same page

Post View Design integrated with PHP Code

<div class="display">
<h4>Showing inserted content</h4>
<?php
$Query  = "SELECT * FROM `wall` ORDER BY ID DESC";
$Execute = mysqli_query($link,$Query);
while($Result = mysqli_fetch_assoc($Execute))
{

?>
<div class="subdiv">
<div class="InnerMain" >
<div class="ProfileDiv" ><img src="<?php echo $Result['ProfileImg']; ?>"  class="ProfileWall" /></div>
<div class="ContentDiv border" >

<div class="container"><?php echo $Result['Content']; ?></div>
<div style="margin-top:27px;">
<a class="update" href="update.php?id=<?php echo $Result['ID']; ?>">Edit</a>
<a  href="delete_post.php?id=<?php echo $Result['ID']; ?>">Delete</a></div>
</div>

</div>
</div>
<?php } ?>
</div>

  <?php
if(isset($_POST['Update'])) {

$Content=trim($_POST['Content']);

$ID = trim($_GET['id']);
$Content= mysqli_escape_string($link,$Content);
if(!empty($Content)) {
$Query= "UPDATE `wall` SET
         Content    = '$Content'
		 WHERE ID='$ID'";


$Execute = mysqli_query($link,$Query);

if($Execute==true)
{

	header('location:index.php');

	}
                   }
                               }

?>
  

<?php
if(isset($_GET['id'])) {


$ID = trim($_GET['id']);
$ID = mysqli_escape_string($link,$ID);
if(!empty($ID) {
$Query= "DELETE FROM `wall` WHERE ID='$ID'";


$Execute = mysqli_query($link,$Query);

		}
          	        }

 ?>