php_curd_demo

The “CRUD” means Create, Read, Update, Delete and is the most frequent functions used in daily operation. Here shows a simple CRUD app in PHP for reference. Let’s follow the methods explained in the article of my blog “Building PHP Web Apps Without Framework” and start to build a product list web site.

Seven Basic Operations

There are seven operations need to identified. They are:

• 1. list_products: get and show all products.
• 2. show_product: get product data for a specific prod_id.
• 3. new_product: get a new form to enter product data.
• 4. create_product: create a product and save to database.
• 5. edit_product: get and edit product data for a specific prod_id.
• 6. update_product update product data of a specific prod_id to database.
• 7. delete_product delete product for a specific prod_id.

The operations 3 and 4 are consecutive steps, which mean when a user creates a product by finishing product data entry (operation 3), the system save product data to database at once (operation 4).

Likewise, operation 5 and 6 have the same situation. The system gets and shows the product data on the screen (operation 5), then it saves the data back to database while data has been edited by a user (operation 6).

This demo application is also described in A Simple CRUD App in PHP.

Demo site at Heroku: php_crud_demo