Home » MySQL, PHP5 March 2008

Very simple add, edit, delete, view in PHP & MySQL

In this article, I will be presenting simple PHP & MySQL code to add, edit, delete and view data. This kind of system is also referred to CRUD (Create, Read, Update, Delete).

Here is a step-by-step guide on creating a CRUD system using PHP & MySQL:

First of all, we will create a new MySQL database. Let us name the database as ‘test‘.

create database test;

Then, we will create a new table in database ‘test’. Let us name the table as ‘users‘.

use test;

CREATE TABLE users (
id int(11) NOT NULL auto_increment,
name varchar(100) NOT NULL,
age int(3) NOT NULL,
email varchar(100) NOT NULL,
PRIMARY KEY (id)
);

Now, we will create a config.php file which contains database connection code. This code connects to the MySQL database. This file is included in all PHP pages where database connection is necessary.

config.php

In below code, the database host name is localhost where username=root and password=root. The database test has been selected.

To add data into database, we need an html form.

add.html

Form action on add.html is add.php. It means that the submitted form data will go to add.php. In add.php, we do a simple validation of checking if the entered name, email & age are empty or not. If they are all filled then the data will be inserted into database table.

add.php

Data from database is fetched and displayed in index.php file. This is our homepage. This file also contains a link to add data. On every row of displayed data, there is also a link to edit and delete data. Below is a sample image of our homepage:

CRUD PHP MySQL

index.php

Each row of data can be edited separately. Row ID is passed in the URL of edit.php. ID uniquely identifies the data entry.

While adding data, we had two files: add.html and add.php. While editing data, I have kept the entire thing in a single edit.php file. Edit form in HTML and database update code in PHP are present in the same file.

In the code below, at first a single row entry of data is fetched based on the id. The fetched data is displayed in the edit form. When user edits the data and submits the form, then some simple validation is done for empty data. When everything is correct, then that particular entry of data is updated in database.

edit.php

Each row of data can be deleted separately. Row ID is passed in the URL of delete.php. ID uniquely identifies the data entry. After deletion, the user is redirected to homepage (index.php).

delete.php

Download Full Source Code: Simple Create, Read, Update, Delete in PHP & MySQL

Hope this helps.
Thanks.

From Mukesh Chapagain's Blog, post Very simple add, edit, delete, view in PHP & MySQL

php magento mukesh chapagain

Get New Post by Email

Find me on

Facebook Twitter Google+ LinkedIn RSS Feed
  • Michael

    Thanks for your help sir….

  • Jsquad2008

    thak you sir for your kind!…

  • Bulbul4u_only

    thanks

  • Avinash Powar

    This is very good but how can i edit if my data type is TEXT & textarea control ?

  • Thalhah Amir

    thanks

  • Trebor

    many thanks for posting this tutorial. Question please, for me Edit page only displays first six or so characters in name, age and email fields. Is there a way to display more or all characters?

  • Trebor

    many thanks for posting this tutorial. Question please, for me Edit page only displays first six or so characters in name, age and email fields. Is there a way to display more or all characters?

  • Priyanshu Mittal

    hey thts a coll example thnk you helped me alot

  • Cindie Kato

    tnx dude

  • Ravi

    Thanks Mukesh,
    Your code is very helpful , I am creating a small client server application with database.
    Users(with different login) can submit their daily data and can see and edit them .
    admin can see all the users and generate report.

    I am still in process , but your code has help me a lot in user page development.
    thanks
    Ravi

  • Srinivas4146

    good tutorial for learners

  • Pingback: Very simple add, edit, delete, display in PHP « PHP MySQL()

  • Lucky

    Thx So much ………..u r great…..

  • Beng Ngim

    Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:wwwcrud-simpleindex.php on line 24

    How to fix it? Plz…

  • User

    How can I add pagination please help.

  • http://blog.chapagain.com.np/ Mukesh

    It should work without warning. Have you already added data into the database table? You may use mysql_fetch_assoc instead of mysql_fetch_array and test as well.

  • Tef Fy

    Thank you for the tutorial. Simple tutorial like this it’s very appreciated. Please keep posting.

  • Manda Mirza

    helo can you help me in this task tef ?

  • Hwaiting 93

    thank you so much .. great tutorial