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

[Chris Blessing]

But again, once the user ends their session, I have no idea what their
customer id was nor do I know what it will be the next time they start a
session... right?  Unless I write out that specific id to a cookie... I
can't bind it to their already-unique user account because I don't want to
require them to login/create an account before populating their cart.

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

> 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