About Content Management System

Introduction
In this tutorial, you will create a Content Management System (CMS). A CMS is a web application that
allows you to create articles or any other pages directly online, from a secured administration area.
This tutorial will not present how to implement user authentication, as this is described in another
tutorial (the Job Site tutorial). You must however create the login and registration pages before
creating any other sections of the site.
This application will allow you to:
 create, update, and delete articles.
 display a list of articles for the site administrator.
 create a navigation menu and display articles in the front-end.
 auto-archive articles older than one month.
To complete this tutorial, you will make use of features from MX Kollection 3. If you do not have the
MX Kollection 3 bundle, then the following separate products must be installed:
 MX User Login
 ImpAKT
 MX Includes
 NeXTensio 3
 MX Widgets
 KTML Lite
To complete this tutorial, it will take about 80 to 100 minutes, depending on your web authoring level.
The first thing to do when starting to create an application, is to take some time and plan it out.
Decide on the files to create, and the database structure you should use.


Plan the Content Management System
Before you start building this application, make sure you have a correctly configured Dreamweaver
site, and a working database connection. For more instructions regarding these actions, consult the
Getting started book help file, which can be found in Help -> InterAKT -> Getting Started.
Through the tutorial, you will have to create several files and folders in your site's root. You can create
them at the very beginning, so that you will not waste time with this operation again. To create files
and folders in the site's root, use the corresponding options in the File menu of the Files tab. All files
created in this tutorial can also be found inside the downloaded package, and you can use them to
compare your work with what has been already done.

Here's a listing of the tables and columns used in this database:
1. page_pag - the page table stores all the site pages and their information
 id_pag - the primary key for the page table. No two pages will have the same id.
 idpag_pag - this field serves as a self-foreign key. This is a reference to another page
within the page table. Here this field differentiates between article lists, and the articles
themselves. The idpag_pag field for a regular article will contain the value of it's parent
article. If any of this is confusing just check out the Database concepts page for a little
help.
 title_pag - the title of the page.
 description_pag - A brief text description of the page's contents.
 body_pag - the actual content of the page (HTML) is stored in this field.
 date_pag - stores a date value to simplify updating.
 visible_pag - stores the status for each page. If set to 0, the page is invisible.
2. user_usr - the user table stores all users registered to the site, and some simple information about
them.
 id_usr - the primary key for the user table. No two users can have the same id.
 email_usr - the user's email address (rob_anderson@somedomain.org).
 password_usr - the user's password for logging in.
You can find the scripts needed to create an identical table structure inside the downloaded package
as a SQL or MDB file, depending on the database server you intend to use. Import them in your
database server management software (e.g. PHPMyAdmin, Microsoft Access etc).
Sample data is already entered in the database. To login into the administrative section of the site,
the default account is:
 username: admin.
 password: root.


Add, Edit and Delete Parts and Articles
In this section of the tutorial you will learn how to use MX Kollection 3 features to build the main
pages of your content management system, both in the front-end, and the back-end. You will create
the following elements:
1. For the Front-end:
 A menu for the front-end, linking to pages that present lists of articles
 The actual pages that display the lists, and the article.
 A main page which ties together the pages and functions listed above
2. For the Back-end:
 You will create the page that lists the articles, also allowing you to delete multiple
items, as well as displaying links to edit or add an article.
 A page that contains the insert/update form, allowing you to enter the actual article.
To build these pages, you will use the following products:
 MX User Login - to prevent users from accessing the administration pages
 MX Includes - to combine all front-end pages in a single file.
 NeXTensio - to build the back-end list and form of article.
Completing the first, and largest section of the tutorial will take about 40 to 50 minutes.

Triforce consulting services Pvt. Ltd.