You are given a task to develop a simple web database application for a computer shop. The system will store the information of all the branded laptops in the shop. Below are the information needed for the database.
Database server information : server address=localhost, username=root, no password
Database name: COMPUTERSHOP
Table name : Laptops
Fields in table Movies : CompID, CompModel, Manufacturer, Processor, RAMCapacity, HarddiskCapacity, Price.
1. Create the database and table as stated above (using MySQL through phpMyAdmin).
2. Develop the web page by using the combination of HTML and PHP scripts to search and display the laptop information by CompModel.
(Create two different pages)
3. Develop a HTML form for the user to insert a record of a new laptop computer. Save the new record in the table Laptops.
Send the code to me by 12pm, 25Feb 2009, by email to firstname.lastname@example.org…