CIS393 Assignment 3
Due 05/01/2018

1. HTML/PHP Web pages

Design and develop Web pages with PHP to process the data from the winestore MySQL database on CS99. You must not assume that the user knows the SQL queries, so your GUI design can’t ask the user to enter the SQL commands.

a. You can create your MySQL account in CS99 using the script at https://cs99.bradley.edu/~firewall/register.pl

(You may need to use a version of IE or Firefox or Chrome that allows you to proceed and ignore the security warning, since CS99 HTTPS may still have some certificate issues at this time.)

b. Click the winestore.data link to download the SQL script to create the database. You can either create the winestore database use the phpMyAdmin or use the following commands:

$mysql –u username –p

>(type in password)

…

mysql> source winestore.data;

Finally you should add the WineStore web page on your club web site.

2.PHP Scripts

1. Develop a query PHP script query.php to do the following: (see code examples on the lecture notes.)
- Process user query inputs; the query should across the tables.
- Send query to winestore MySQL database; use try/catch to display the database and network error messages.
- Display the query results in HTML5 Tables.

2. (Extra Credit) Develop a write PHP script write.php to do the following: (see code examples on the lecture notes.)
- Process user inputs command to insert, update, or delete data in more than one data tables.
- Send the command to winestore MySQL database; use try/catch to display the database and network error messages.
- Display the write results in HTML5 Tables.

3. (Extra Credit) Email a message back to the user. (See code example on the class web site.)

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).
Submit your report and your PHP source code files in the drop box of the class Sakai web site before the midnight of the due day.

2. Present your web pages to the class on the due day.