Overview

This two day course is aimed at experienced users of Adobe Dreamweaver and focuses on the creation of dynamic, database-driven sites using Dreamweaver, PHP and MySQL. Delegates will learn how to create connections to databases, set up search and results pages and create password protected admin areas with facilities for adding, deleting and editing database contents direct from their web pages. Although an overview of server side PHP coding is provided, this course does not involve any programming, rather it shows how to use Dreamweaver's built-in features to generate dynamic sites using PHP and MySQL.

Course Outline

PHP Essentials

Background to PHP, Installation and configuration, Embedding PHP tags, Adding comments, Using the Print function, Using variables, Dynamic variables, Data types

Connections

Databases and dynamic sites, Connecting to a MySQL database, Dreamweaver's connection folder, Displaying records

Adding dynamic content to pages, Creating Repeat Regions, Using Recordset Paging, Using Show Region, Displaying the current page, Using Live Data View

Filtering results with SQL

The use of variables, Setting default values, Setting run-time values, Naming variables, Creating the WHERE clause, Filtering numeric fields, Filtering text fields, Filtering date fields, Using wildcards, Editing database content

nsert Record, Naming form fields, Update Record, Repopulating the update form, Delete Record

Dynamic page elements

Making HTML attributes dynamic, Dynamic text, Dynamic images, Dynamic links, Dynamic drop-down menus, Dynamic radio buttons

User authentication

Creating a registration page, Check User Name, Creating a log in page, Log In User, Restrict Access to Page, Log Out User, Using levels in authentication