[thelist] Backend of a shopping cart system...

[Casey Crookston]

Each time a user click's "Add to Cart" a record is added to your Cart
table.  This table will have several key fields, one being unique to
that row, one which relates back to the customer (a Customer ID) and one
which relates back to the product (a Product ID).  Another colum would
indicate the staus of this items in the cart.  Example 1=added but not
purchased; 2=Added then deleted; 3=Added and purchased.  When that
visitor comes back, your SQL statement which populates his cart will
select all items from Cart where Customer ID = current and Status ID =
1.

Other data in this table will record the date and time it was added or
deleted or purchased, etc.

HTH,

Casey


-----Original Message-----
From: Chris Blessing [mailto:webguy at mail.rit.edu]
Sent: Friday, April 05, 2002 9:10 AM
To: thelist at lists.evolt.org
Subject: RE: [thelist] Backend of a shopping cart system...


But then how would I maintain their cart after the session expired?

Chris Blessing
webguy at mail.rit.edu
http://www.330i.net

> You have a session table and write the contents of their sesion to
> that. When they log out that deletes the row in the table associated
> with their sessionID
>
> Julian
--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !