CS500 01                                       Assignment 2
Due 07/05/2007

Part I: Group Report of Lecture Notes and Textbook studied on Web Development using PHP/MySQL

Write a Microsoft report to summarize your group PHP/MySQL study activities. The report must have the following.

1. The time and date of your group study and the topics covered in each study session.

2. The group discussion summary of each topic studied.

3. Questions and answers and any issues discussed in each study session.

4. Conclusions of knowledge learned.

Email the report to the instructor on the due day.

Part II: PHP/MySQL Programming Project on cs3

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 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 excrypted 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. 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. (Extra Credit) 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 (screen shots).
    Email the instructor the report and your PHP source code files on the due day.

2. Instructor may ask you to demonstrate your project to the instructor if needed.