CS500 01                                       Assignment 2
Due 03/25/2008

1. HTML/PHP Web pages

Design and develop Web pages with PHP to process the data from the winestore MySQL database on cs3.

1. The Web pages should have all the major GUI elements such as Text and password fields,
    Checkboxes, Radio buttons, Submit and reset buttons, List and scrolling box, and (optional) Filefield.

2. PHP Scripts

Develop PHP scripts to accept and process the requests from the above Web pages.

1. Develop a login PHP script login.php to do the following:
    - Authenticate the user. The passwords should be encrypted and stored in a database table.

2. Develop a query PHP script query.php to do the following:
    - Process user query inputs
    - Send query to winestore MySQL database
    - Display the query results.

3. (Optional) Develop a write PHP script write.php to do the following:
    - Process user inputs command to insert, update, or delete data
    - Send the command to winestore MySQL database
    - Display the write results.

4. (Optional) Display the query and write results in a report format.

Homework Hand in Policy:

1. Write a MS word report that describes your development process, any problems that you have solved, and run results (with screen shots).
    Email the instructor the report and your PHP source code files before the due day.

2. Give a 20-minute presentation for your assignment to the class on the due day.