• Why use Databases? Types of database

Setting up on line simple and flat file databases

• Building and maintaining a client side simple database

• Connecting to it and displaying it using a serverside script

• Making the database searchable

This section explains how to set up a PHP MySQL database page using Dreamweaver editor

• Set up the testing server on your local computer

• Connect to your database on your server

• Constructing a recordset with Dynamic Database Elements

Database elements using Dreamweaver

• The database connection and recordset will not produce output on the screen. To see and navigate your database a number of elements must be added

• Building the Database Page with dynamic tables and navigation

Making databases searchable

• It is possible to set up your own search pages using Dreamweaver but complex search routines need specialist help

• Creating a simple keyword search and displaying the results

Connecting to Access for on line databases

• If you want to connect to a relational database such as Access, FoxPro, Oracle or dBase you will need to connect through ASP or JSP, OLE DB, ColdFusion or ASP.NET

• You will need a Windows based hosting account

• Setting up a Connection to the Database using ODBC

• Sample Access Database from Webdevonline.co.uk

On Line servicing databases

• You need to get an interface to connect to your database so that you can service it on line

• You can use Dreamweaver to build servicing pages - add new records and alter/delete old ones

• Set up an Admin Area for the databases