This assignment involves dynamic programming with MySQL and PHP (ch 18 and 19 Internet and world wide web 5th edition). The main activities you need to implement is to create a database connected web application. In this project, you will do listing, deletion, and insertion to a table in a MySQL database. This link http://mycoursework.mywebcommunity.org/p3/ shows a solution for this project using Student table (also a video is attached) In your project, you will use another table of your choice.
Project Description: Choose a data table similar to Student table. You cannot use Student table for this project. The data table could be about anything you want, such as movie, book, business, companies, song, cars, etc. Create this table in your MySQL database. You can use phpMyAdmin or your can use MySQL command. The data table will have at least 10 rows, and 5 columns. Note that my example of Student has 14 rows, and 6 columns.
Second step is implementations of the web applications in five steps:
#1 Implement a html page as index.html. This is main (landing) page listing all four operations (list, list with condition, search, insert).
Requirements about search box (#4): This is a form action without new line. The form action method is POST.
Hint: