Site Features

  • Site created by Loren Anderson as a class project for MIS 314 at Western Washington University.
  • All product information is dynamically generated using Active Server Pages.
  • Book, customer and order information is stored in an Access database.
  • Server-side includes are used for all components that are used more than once (such as the search/browse menu, ListAuthor function, 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 book categories.
    • Book descriptions are truncated at 300 characters.
  • Search/Browse response page
    • The search function searches book titles, descriptions and categories fields in the database.
    • The RecordCount property of the RecordSet object is used to count the number of books found by the search.
    • Searches that have no matches respond gracefully
  • Shopping cart page
    • Uses a cookie to store the ISBNs of items 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
    • Checks for shopping cart and prompts user if cart is empty.
    • 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.
    • Modifications made to customer information are updated in the database.
    • Order information are written to the database.
    • An email is sent to the customer with the order information.
    • The shopping cart is emptied by setting ItemCount to zero in the ShoppingCart cookie. .
  • Order History Page
    • Searches the database for all orders associated with e-mail address
    • If no matching email address is found user is prompted to try again.
  • Enhancements
    • This Site is created completely with a CSS File. The page is designed largely with Div tags, but uses Tables where bombproof set up is necessary. This is done similar to Amazon.com
    • Bomb Proof Search Feature, which includes:
      • Empty queries
        • Queries with only spaces
      • Queries with html code
      • Queries with apostrophies
      • Attempts to insert SQL statements
    • Protection from malicious hackers whom attempt to insert SQL statements into the Email input to view the whole database.

     

  • Thanks to Amazon.com (the world's greatest on-line bookstore) for the use of its icons, book images and book descriptions.