nathan
schmoll's
aspdiscovery
Building an article management system -- Part I |
|
| Welcome to part one of a four-part tutorial on how to build a basic article management system (kind of like a basic version of this web site!)! Article management systems are used widely across sites that produce articles and publish them online. All they must do is add a simple record into a basic databse. Let me start off by telling you how ASP Discovery runs. It's based on a Microsoft database that gets accessed whenever an article is requested from the system. There is a basic layout for an article. The article title, date of publication, author, and article content just gets pulled from the database by an article identification number. That information is then inserted into the layout and poof! -- you magically have your beautiful article. Easy for us to put up, easy for you to read! Let me start off by telling you what columns will be necessary for the database. An article identification number, an article title, and article content will be required and you can add, if you like, date of publication and page author. In this tutorial, we'll call the database "articles.mdb" and the table inside of articles.mdb -- the one with all the articles -- will be called "articles". The column names will be as follows: "id" for the article id, "title" for the article title, "content" for the article content, "date" for the article's date of publication, and "author" for the article's author. Go ahead and create this database and we'll continue this in part two. Go to next to part two >> |
