Question 1:

First, make a MySQL database of 1 file with 5 products in it (product name, prod-number, price).

Zip-file all these files so I can check them out (making sure you provide all files needed).

Question2:

Produce the PHP script needed to access the 5 products (name, prod_number, price) from a My SQL database

to fill the form in question 3. This is the server-side dynamic.

If the cs2 server provides insufficient access to the outside world / Internet,

then make sure a localized WAMP server can emulate it (i.e. set up scripts, directories, and files

in a zip file, configured so I can run it easily. Describe how you want me to run it in a readme.txt file (also in the zip-file).

Question 3:

3) Create and test an HTML5 & JavaScript web form for the business assigned to you.

You need to have in this form support for data entry of a standard web-based check-out counter with the following form controls/input:

First name, middle initial, last name (as text fields)

Address (street, city, state, zip, all individually prompted)

Email

Phone number

Billing model radio button (check, COD, credit card, etc) giving as many options as possible

Credit card pull-down-menu or scroller based selection (Visa, MC, AE, Discover, Paypal) giving as many options as possible

Expiration date of the credit card, using a menu of 12 months Jan-Dec and a separate menu for the year using the 4 years 2009, 2010, 2011, and 2012 (after which Ragnorok J).

A comment field for special shipping instructions or customer satisfaction narrative (you decide which but it must be one of them)

a list of 5 textboxes whose labels are product-records, requested via initial PHP request (and drawn from the MySQL server). Each label is a product with (product name, product number, and price),

For each product's text field, the JavaScript/HTML5 form wants a quantity desired for purchase of that item.(a field for input of how many to purchase).

A submit button and a reset button, both fully functional.

The submit button computes a total bill/receipt with one line for each product (total cost of that product) as well as identifying that product, subtotals, tax, and grand total.

For this question, provide the source code (readable) for the HTML5 with JavaScript.

Note: Your JavaScript/HTML must not have the product data in the JavaScript or HTML.

It must access it from the Database through PHP requests.

Your 5 products must be relevant to your company (the one you were assigned to the table below.

Use Chrome to test final result.

Provide source code as readable HTML5 (using links to

web images rather than downloading images)

Question 4: Deployment

Setup the whole thing on cs2 in your account and make it internet accessible.

Once it all works on cs2, attach a .txt text file with the URL / weblink to run this on cs2.