Problem Set 4: Product Catalog Management and Display

Requirements:	In this exercise, you will build the admin interface of an online product catalog. The catalog contains a number of products, which are organized into categories. For simplicity, each product belongs to one category. Required functionality for site administrators: View all products (view all, or filter by one category) Add a new category Category name (required) Category description (optional) Add a new product Product name (required) Product description (optional) Category (required) Product photo (required) Edit a Category Remove a Category Edit a Product Remove a Product You will need to generate a thumbnail version of the product photo of no more than 120px in height or width and use in product list. When the thumbnail is clicked on, open the full version photo in a new browser. For additional bonus, the new browser should just fit the size of the full version photo. You may use PHP or other scripting language. Preferred database is MySql.
Hints:	When design the user interface, use your best judgement for page layout. Be proactive and try to go extra miles to make your web pages easy to use.
Download:	Zip file [42KB] pset4.zip PHP sample code is included in this Zip file. If you opt to use other programming languages, you will need to buid the pages with similar structure.
Deliverable:	/admin/index.php: list all products /admin/add_category.php: add a new category /admin/edit_category.php: edit a category /admin/delete_category.php: remove a category /admin/add_product.php: add a new product /admin/edit_product.php: edit a product /admin/delete_product.php: remove a product /sql/data_model.sql Compress all files, included the database creation sql script, then submit.
Resources:	PHP documentation: http://www.php.net/docs.php