simple shopping cart sql/php

[epispiral]

All,

I am taking an intro course online on sql/php and have cruised through it a little too fast for my own good, so I haven't practiced much of what i have learned. The last part of the course, where I am stuck, consists of the following project:

 

The shopping cart will have  products, prices, registration, and a checkout area, and also a "manager's" area in which products, customers, and purchases can be viewed, and new products can be entered. Make this shopping cart work any way you wish.

 

Part I:

For the first portion of this project, you will need to design and create your SQL tables for the cart's products, registered customers, and purchases. Be sure to think carefully about how the tables will relate to one another for the purposes of your cart. When you are finished creating your tables, hand them in.

 

Part II:

Now it's time to create your shopping cart and manager's area. Although how you implement this is up to you, here are some elements that should be included:

For the shopping cart:

 

A way for the customers to view the products from the database, along with prices.

A way to add each product to the customer's shopping cart.

A way to view the shopping cart.

Finally, a way to register and checkout.

For the manager's area:

A way to view, update, and add products and prices.

A way to view customers and their purchases.

 

 

Hand in two php files: The first file should be the starting point for your customers, and the second file should be the starting point for managers.

 

So, all in all, I need to create three tables and two php files, and I need all the help I can get. Any tips are welcome

 

[Alt_F4]

I don't think that you are going to get much help asking someone else to do your assignment for you.

I suggest you attempt a start yourself and post what you have done, if you find you get stuck.

 

I would start (as what you have posted suggests) by creating your database:

 

Based on what you have posted, you are at least going to need tables for products, customer registration details, cart and customer purchases