|
Site Features
- Site created by Brandon Schnierer as a class project for MIS
314 at Western Washington University.
- All product information is dynamically generated using Active
Server Pages.
- Product, customer and order information is stored in an Access database.
- Server-side includes are used for all reusable code (such as the search/browse and Author scripts, as well as
the header and footer).
- Home Page
- "Today's Features" are randomly selected from the
database.
- The browse menu is dynamically generated from the database using a SQL query that shows
only the current item categories.
- Product descriptions are truncated at 300 characters.
- Search/Browse response page
- The search function searches the database fields: ItemID,
description, category, tagline and name.
- The RecordCount property of the RecordSet object is used
to count the number of items found by the search.
- Searches that have no matches respond gracefully.
- Server-side validation is used to assure that a model is
selected.
- Shopping cart page
- Uses a cookie to store the ItemIDs, model and number of
each item in the
cart.
- Checkout pages
- Searches the database for email addresses of existing
customer accounts and writes their shipping information in
the form on the order confirmation page.
- Order Confirmation Page
- All fields are checked to make sure that they contain
information.
- Checks email address in database and prompts user to try
again user if address not found.
- Customer information is updated in
the database.
- Order information is written to the database.
- An email is sent to the customer with the order
information.
- The shopping cart is emptied.
- Order History Page
- Searches the database for all orders associated with
customer's e-mail address and displays all items purchased.
- Enhancements
- Search/Browse function is protected from unfriendly database errors using the ' character. It will also
fix any HTML entered into the search box and change it to plain text.
- Emails from the checkout feature are sent in HTML format for compatibility.
- The page header has a check to tell the customer if they are logged into their account. It will greet
you by name and keep track of the amount of items in your shopping cart.
- Database is protected by an auto-numbered primary key so customers can update any account value
and retain their order history.
- Purchasing and checkout pages cannot be accesed unti the customer logs in with their email address.
There is also a logout button located on the login screen for security.
- Thanks to
ThinkGeek.com, Amazon.com (the world's greatest on-line bookstore) and Landan's Page for the use of
their
icons, product images and and product descriptions.
|
|
About This Site