Make index.php Drive Your Entire Site (40 points)

Use PHP to make your index.php file the only URL that will ever need to be entered by users. Pages should be displayed by your index file using PHP logic.

Web Database Dev with PHP

At a minimum, each page in your site should have a header, a menu, and a footer with some form of copyright information and correctly implemented content.

Your site should have, at a minimum, 3 pages in your menu: the home (or introductory) page, a contact page, and a catalog page.

The home page of the site should contain an introduction to your store.

Store all of your products and customer information in separate MySQL tables so that this version of your site can function for testing. You must have at least a few customers and inventory items for testing.

Customer records should be able to store a customer ID number, name, an address, a phone number, some notes, and anything else related about the customer.

Product records should store an item number, an item name, an item description, an item price, and an item quantity.

The contact page should contain a form that allows users to enter information about themselves and a brief message. When submitted, your site must display a confirmation that indicates a successful transmission and displays all of the information the user entered.

Your catalog page must provide a list of the products in your products table. Table rows should alternate colors for readability. The table should contain labels. The columns that should appear in the list should include the number, the name, and the price. The item number will eventually appear as a link that, when clicked, takes the user to a detail view for that item which will contain all information about it. That is where the item would be added to the cart

You must use external CSS for all formatting and appearance. It is important to be in the habit of separating content and layout, so make sure that you do not use tags or attributes that modify appearance in the markup.

Your source (PHP, markup, and CSS) must be neatly organized and formatted with appropriate tabbing, comments, and adherence to the standards we discuss in class

For additional points, you can add logic to your site the functionality that will have the product page created dynamically. This should be one single page that has the potential to show any product in the database. This would be done based on information passed to it from the catalog or home page.