|
|
|
|
This first section of this tutorial helps you create all the files and database tables needed for the application.
Before you start building this application, make sure you have a correctly configured Dreamweaver site, and a working database connection. For more instructions regarding such actions, consult the Getting started help file, which can be found in Help -> InterAKT -> Getting Started.
Through the tutorial, you will have to create several files in your
site's root. The file structure will look as in the example below, and
you can create it easily by unpacking the zip
file corresponding to your server model from \tutorials\Custom
CSS Skin\ in your site root:
Besides these files that are the actual pages that will be viewed from the browser, some more files and folders will appear in your site structure:
Some images, that come with the site template.
The Dreamweaver created Connection folder.
The includes folder, created when an extension is used on a page.
Included in the zip file you can also find the template that has been used in the tutorial, as well as the new skin's images and CSS files.
After having dealt with the file and folder structure, it is time to create the database structure that will be used throughout the site's pages. The database is simple in nature, as it is not the scope of this tutorial, and contains only two tables:
product_prd - the table that stores the company's product list
category_ctg - this table stores the different product categories.
The table and column structure is as shown in the following image:
Note: The database diagram in the image above was built with MX Query Builder (also referred as QuB) to better illustrate the database structure. You do not need to build it in order to complete this tutorial.
You can find the scripts needed to create an identical table structure inside the downloaded package, in the \tutorials\Custom CSS Skin\db\ folder, as an 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).
The scripts already contains some data, in order for you to easily view the results.
Next, open the main index page and create
a new connection named connAds and configure
it to connect to your newly created database.
In the next section of the tutorial, you will prepare all necessary images and files needed for the customization.