Link to home
Start Free TrialLog in
Avatar of tonMachine100
tonMachine100

asked on

shopping cart - customise items

I'm working on an shopping cart. I've used some sample code i've found on the web as a basis but now i need some help as the requirements of the project have developed.

As it stands there are 3 pages - a product page, a product customization page and a cart page.

The requirement is for a customer to be able to select a product from the product page - the product_id is then passed through to the customization page where the user can select which material and color they would like the product to be, then the product id and customization details will be passed through to the cart and displayed.

At the moment the product id is passed through to the final cart screen but the color and material values (captured through 2 picklists) are not being displayed.

The product colour and material details are stored in 3 separate tables (t_products, t_material, and t_colour). There are no links between the three tables (t_material and t_colours are just lookup tables).

I've attached:
 a screen shot of the 3 pages and a mock up of how i'd like the cart page to display the items and custom item data
The three .php files
The mysql create table and insert statements


Can somebody give me some guidance around how the code in the cart.php file needs to be adapted to display the customized items.

Any help is appreciated
ee-example.png
ee-db-struct.txt
cart.php
customise.php
products.php
ASKER CERTIFIED SOLUTION
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tonMachine100
tonMachine100

ASKER

thankyou