#### What Will I Learn? In This Tutorial , we will learn the php CRUD Operation . First of All, We have to know What is CRUD . CRUD means Create , Retrieve, Update and Delete. - You will learn from this Tutorial, How to Create, Update, delete a Person Information on database. - Also Learn How to search a Person Information retrieve from the database. - See the details information of a person. #### Requirements There are Some requirements to learn this tutorial in the given below : - basic php programming concepts. - Establish database connection. #### Difficulty There is no difficulty in this tutorial. It is easy to learn - Intermediate #### Tutorial Contents Actually, In This Tutorial, php CRUD Operation ( 2 layer Architecture ) that means php CRUD Operation Performs on App Layer and Service Layer . ![10.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518265354/mreqmlv62oxqbpl79kx2.png) #### In App Layer - Create, Delete, Update, Retrieve,Detail php files are included . ![11.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518265772/bqygvjygtrl7exvtmmxx.png) #### In Service Layer- data_access,person_service, .htaccess files are included. ![12.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518265986/l9buc9kwejx9jtqnta2p.png) #### Here See the person_db structure given below- ![15.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518266849/lzelox7vqb8zsjkz0ihp.png) #### In Create php file , we can easily create a person Information and store on the database. Let's see the example - ```

HOME

"; die(); } } ?>

CREATE

``` After Running the program, we get the following results- ![13.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518266534/swfw9mkxvninncdjg0sl.png) If We Click the Save Button , We can get the following results- ![14.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518266648/okdf1ywz8ouus78yotq8.png) ![16.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518267027/fvhotjhjcnkzr3nayvah.png) #### In Update php file , we can easily Update a person Information on the database. Let's See the Example - ```

HOME

"; } } $personId = $_REQUEST['id']; $person = getPersonById($personId); ?>

UPDATE

``` After running the program, We get the following results- ![17.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518267591/kycem4pfw597cm2atomv.png) If We Click the Save Button , It Will be updated on the database- ![18.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518267760/a137p11c1xtg2ixcs1qo.png) ![19.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518267838/xruxrboeoatgbnsdtpma.png) #### In Delete php file , we can easily Delete a person Information from the database. Let's See the Example - ```

HOME

DELETE

``` After running the following program- We can delete Name : Bob Kent Information from the database : ![20.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518268559/rowcw6mf7lahhmcwq07l.png) There is no name Bob Kent on the database- ![21.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518268740/eua1iwd57rdolc5wuudm.png) #### In Detail php file , we can easily get the details of a person Information from the database. Let's See the Example - ```

HOME EDIT DELETE

DETAIL

NAME:
EMAIL:

``` #### After running the program, we get the following reults of the Name : mcplexer details from the database- ![22.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518270303/j7jqgxwfegz4l85hglrp.png) #### In Retrieve php file , we can easily get the person_db table Information from the database through the search. Let's See the Example - ```

NEW

RETRIEVE

NO RECORD FOUND
	detail	edit	delete

``` After running the following program- we search specific person from the database and we can see the detail of the person , Also Update and Delete their Information. ![23.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518271314/b8mcwr01czt6ukr26vx7.png) In Service Layer , We see the following codes- Database Connection Code : ``` ``` Person Service code with person_db connection : ``` ``` In The Last part , Index.php - we can run the whole program through this code : ``` ```

Posted on Utopian.io - Rewarding Open Source Contributors