|
hyBook - A Simple Guestbook Application
Part:
1
2
3
4
5
6
7
8
9
10
11
12
13
This chapter discusses:
- Design Overview
- Database Tables
- Configuration File
- Page Layout Templates
- Guestbook Main Page
- Data Submission Issues
- Webmaster Administration Page
Design Overview
After I published by tutorial notes on my Web site, I wanted to provide a guestbook tool
to allow visitors to share their comments with other visitors and myself. So I started
to put together a simple guestbook application in ASP with MS Access database.
While doing this, I have collected many interesting notes that might be useful to you.
Let me first provide you some design highlights before going into any details.
Functional requirements:
- hyBook should allow visitors to view all existing comments collected in the guestbook.
- hyBook should allow visitors to enter new comments anonymously.
- hyBook should organize comments by topics.
- hyBook should allow Webmasters to manage topics and comments.
Technical highlights:
- Two tables will be used in hyBook: "Topic" stores topics, and "Comment" stores comments.
Both tables will be stored in a MS Access database file.
- A single ASP page will be used for visitors to enter new comment and view existing comments.
- Two ASP page will be used for Webmaster to manage topics and comments.
- All ASP pages should be as secure as possible.
- All ASP pages should be configurable to allow Webmaster to merge into existing Website layout
and style.
Database Tables
1. "Topic" table will be named as "hyTopic" with the following fields:
ID - "Autonumber" type
Subject - "Text" type
Content - "Memo" type
2. "Comment" table will be named as "hyComment" with the following fields:
ID - "Autonumber" type
TopicID - "Number" type, foreign key pointing to "hyTopic" table.
Content - "Memo" type
Name - "Text" type
Email - "Text" type
Timestamp - "Date" type
IpAddress - "Text" type
Table names are prefixed with "hy" so that they can be merged easily with your existing databases
if needed.
(Continued on next part...)
Part:
1
2
3
4
5
6
7
8
9
10
11
12
13
| 