Unit 11: Developing CRUD Applications

Learning Outcomes

Students will:

  • Be able to build a MP3 CRUD (create, read, update and delete) application that stores and plays MP3 sound files.
  • Be able to add user authentication using PHP/Mysql.
  • Be able to secure a database.


A sample CRUD application can be coded together with the students before they attempt the MP3 CRUD term project application alone.


Step 1: Create the Database.
Step 2: Create the Database Table.
Step 3: Dump Sample Data On The Table.
Step 4: Create Database Connection PHP File.
Step 5: Create Basic HTML Code Structure For create.php.
Step 6: HTML Form To Input New Record Data.
Step 7: Code To Save Submitted Data and Create A New Record.
Step 8: Create Basic HTML Code Structure For read.php.
Step 9: Read The Records From The Database.
Step 10: Create Basic HTML Code Structure For update.php.
Step 11: Read A Record Based On Given ID Parameter.
Step 12: Create The HTML Form To Update A Record.
Step 13: Connect To The Database And Update The Record.
Step 14: Tell The User If Record Was Deleted.
Step 15: JavaScript To Verify Record Deletion.
Step 16: Delete Record From The Database.

References: https://www.codeofaninja.com/2011/12/php-and-mysql-crud-tutorial.html

Term Project

A client would like a website that can be used to manage an MP3 collection. Develop a Crud (Create, Read, Update, Delete) application on the web that allows the client to manage an MP3 collection. The client must be able to upload and play MP3 files. The client would also like the website to be responsive and hidden from the general public. This means that there must be a login page.

Basic Requirements

  • Validate your pages.
  • Must be responsive.
  • Test your application.
  • You will be evaluated according to the rubric