Simple Crud operations in php using mysql Example

Today, We want to share with you crud operation in php.In this post we will show you creating a complete PHP PDO CRUD Create, edit, update and delete posts with MySQL database, hear for how to make the beginnings of a very simple database app, using PHP and MySQL. we will give you demo and example for implement.In this post, we will learn about Select Insert Update Delete in PHP MySQLi with an example.

PHP MySQL CRUD Application

PHP and MySqli CRUD Operation Tutorial
PHP and MySqli CRUD Operation Tutorial

What is CRUD?

CRUD stands for Create, Read, Update, Delete operations with database table records. Most online web applications as well as Company projects perform some kind of CRUD functionality, you need to multiple time the CRUD Operations for every object in your system.

Files includes in this tutorials

  • members_app.sql: Contain the database table structure.
  • config_database.php: Used for database connection.
  • index.php: Used to Get the member from database.
  • list.php: Used to Get the member of particular member.
  • edit.php: Used to edit the member.
  • member_store.php: Used to insert the new member.
PHP - MySQLi Insert Update Delete CRUD Operation using AngularJS
PHP – MySQLi Insert Update Delete CRUD Operation using AngularJS

Step 1– Create a database

We’ll create a database with a “members_table” table, we’ll be able to manipulate these members_table in our CRUD app, the “members_table” table will contain names, emails, Mobile numbers, etc.

CREATE TABLE `members_table` (
  `ID` int(10) NOT NULL,
  `member_name` varchar(200) DEFAULT NULL,
  `member_fullname` varchar(200) DEFAULT NULL,
  `conatct_no` bigint(10) DEFAULT NULL,
  `Email` varchar(200) DEFAULT NULL,
  `mem_location` mediumtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

Step 2– Create a database connection


Step 3– Create a HTML form for data insertion

Fill Data

Fill below form.

Step 4– data insertion


alert('You have successfully inserted the data');";
    echo "";
      echo "";

Step 5– List / Fetch the record from the database


while ($row=mysqli_fetch_array($ret)) {

# Name Email Mobile Number Created Date Action
No Record Found

Step 6 – List / Fetch the particular record


Member Name Last Name
Email Address Mobile Number
Location Creation Date

Step 7 –Edit/ Update the particular record



Update your info.

Step 7.1 Update the Member record.


alert('You have successfully update the Member');";
    echo "";
      echo "";

Step 8 – Member deletion from the database

alert('Data deleted');"; 
	echo "";     

I hope you get an idea about how to create CRUD operation using PHP and MySQLi..
I would like to have feedback on my blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

Leave a Comment