I need a back-to-basics shopping cart tutorial in PHP/mySQL. I thought I
had it down and I failed, as usual. Here is what I mapped out as a spec:
3) initial work on bestilling.php to contain the following plan:
1) Cookie: 'nordicnet_best illing' to contain unique, random 16-char string
2) Table: nnet_produkt_be stilling to contain ordering information bundled
by
unique bestilling_id (16-char string)
a) produkt_id
b) farge_id
c) storrelse_id
d) quantity ordered
e) bestilling_id
f) nordicnet_regis tration_number
3) *PROPOSAL* To make cookie a timed cookie - if user does not check out in
X hours
the cookie will be deleted
4) *PROPOSAL* CRON-based PHP script to systemically wipe out any stray rows
in
nnet_produkt_be stilling that have not yet been checked out
5) Idea plan for bestilling:
a) User will order produkt in vis_varegruppen .php
b) bestilling.php will do server-side checking of produkt, farge,
storrelse
and quantity based upon entry in nnet_produkt_fa rge_storrelse_a ssoc
c) bestilling.php will then check if $_COOKIE['nordicnet_best illing']
already exists (meaning you have an order # - or, a cart ('bestill')
d) If you have a cart then check if there is already a row in
nnet_produkt_be stilling with same produkt_id/farge_id/storrelse_id with
your
matching bestilling_id
e) If so then increase quantity ordered by the quantity you ordered and
check
quantity totals against nnet_produkt_fa rge_storrelse_a ssoc
f) If NOT then add new row with produkt_id, farge_id, storrelse_id and
quantity with your bestilling_id and registration number
g) -- If you do NOT have a cart (no cookie) then generate a new cart
(bestilling)
id into a cookie
h) If other people ordered the same item be sure to check their quantities
ordered against yours and what is in stock before proceeding
So far this is what happens:
1) I enter products into the cart
2) If I delete items from the cart, they can be deleted; if I delete all
items from my cart, the cart cookie is deleted, I think.
3) I try to re-enter the same item into the cart, it inserts into the db w/
a NULL value for 'nnet_user_best illing_id' which is
the cart id (which it's not supposed to do) and browser-side logic
fails, you get the wrong screen and all kinds of garbage I cannot even go
into because it's in Norwegian
I have tried for nearly 24 hours to build a cart and I can't seem to get it
done. I really need some help.
Phil
had it down and I failed, as usual. Here is what I mapped out as a spec:
3) initial work on bestilling.php to contain the following plan:
1) Cookie: 'nordicnet_best illing' to contain unique, random 16-char string
2) Table: nnet_produkt_be stilling to contain ordering information bundled
by
unique bestilling_id (16-char string)
a) produkt_id
b) farge_id
c) storrelse_id
d) quantity ordered
e) bestilling_id
f) nordicnet_regis tration_number
3) *PROPOSAL* To make cookie a timed cookie - if user does not check out in
X hours
the cookie will be deleted
4) *PROPOSAL* CRON-based PHP script to systemically wipe out any stray rows
in
nnet_produkt_be stilling that have not yet been checked out
5) Idea plan for bestilling:
a) User will order produkt in vis_varegruppen .php
b) bestilling.php will do server-side checking of produkt, farge,
storrelse
and quantity based upon entry in nnet_produkt_fa rge_storrelse_a ssoc
c) bestilling.php will then check if $_COOKIE['nordicnet_best illing']
already exists (meaning you have an order # - or, a cart ('bestill')
d) If you have a cart then check if there is already a row in
nnet_produkt_be stilling with same produkt_id/farge_id/storrelse_id with
your
matching bestilling_id
e) If so then increase quantity ordered by the quantity you ordered and
check
quantity totals against nnet_produkt_fa rge_storrelse_a ssoc
f) If NOT then add new row with produkt_id, farge_id, storrelse_id and
quantity with your bestilling_id and registration number
g) -- If you do NOT have a cart (no cookie) then generate a new cart
(bestilling)
id into a cookie
h) If other people ordered the same item be sure to check their quantities
ordered against yours and what is in stock before proceeding
So far this is what happens:
1) I enter products into the cart
2) If I delete items from the cart, they can be deleted; if I delete all
items from my cart, the cart cookie is deleted, I think.
3) I try to re-enter the same item into the cart, it inserts into the db w/
a NULL value for 'nnet_user_best illing_id' which is
the cart id (which it's not supposed to do) and browser-side logic
fails, you get the wrong screen and all kinds of garbage I cannot even go
into because it's in Norwegian
I have tried for nearly 24 hours to build a cart and I can't seem to get it
done. I really need some help.
Phil
Comment