Specification: I wrote most of the code separately but seems am having difficulties linking it to my database:
Write a simple E-commerce application, which may be a bookshop, music shop, clothes store, or anything else you wish. There should be a “user” interface to allow customers to select and purchase items and also ideally a password-protected “owner” interface to allow the E-shop operator to view/edit stock and pending orders. Do not worry too much about the payment side of things: A dummy page requesting credit card details etc. (not actually doing anything with the information) will be sufficient. Alternatively you could create a dummy account with PayPal.