|
|
| Site Features
- Site created by Nathaniel Jones 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
- fixed a glitch in the 'Geekbooks' programming that returned all publishers as 'que' on the product page.
- Personalized the color scheme and all of the logos with photoshop (the only images I did not create personally are the book covers)
- Helped reduce the risk of SQL Injection and other hacker tricks by eliminating left arrows from customer inputs.
- Validate customer e-mail address with regular expressions.
- Automatically fill in the user's e-mail address on the log-in page with a cookie.
- Automatically sign-in customers on the Order History with the e-mail cookie.
- Added hyperlinks to the book titles on the search/browse page to make for easier navigation.
- I made it more difficult to mess up the customer database by creating a seperate page for updating customer information, eliminating the need for extra safegaurds
- Thanks to Amazon.com (the world's greatest on-line bookstore) for the use of its
icons, book images and book descriptions.
|
