• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Q&A

Q1: Is this site secure?
A1: Mostly. There is actually a point of failure that can occur in the shopping cart area. Because we're using a form to submit cartID when items are deleted, a user could potentially modify the form and delete items from other carts. Of course you shouldn't commit sensitive data to the database without proper testing.
Q2:What kind of expansions can I make to the site?
A2: An easy expansion that I think would be worthwhile is to add a Web site specials area that is shown when the user first reaches the site. These specials could be stored in the existing database under a new category.
Q3:Could I create the site so that the user can shop without logging in?
A3: Yes. To do this, you'd need to generate an orderID when the user first visits the site. This ID would be stored in the shopping cart as the user browses, rather than when he is finished.
Q4:How do you find the orders once they've been placed?
A4: The OrderInfo entries can be related to the tblCart table based on the orderID. For each orderID in tblOrderInfo, there are potentially several entries in tblCart. Generating this SQL is simple and is left as an exercise to the reader.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint