Dreamweaver Dynamic | Course Overview

Course Description

This 2 day course is designed for anyone who is proficient with Dreamweaver and HTML but wishes to take their web development skills to the next level by learning how to use Dreamweaver to create a dynamic website (a website in which the content is stored in a database so that pages are constructed on the server in response to a user request).

Dynamic websites offer many advantages over conventional static websites, such as

A search facility, so that users can find information on the site quickly and easily
The ability to password protect specific pages on the site
Site owners or content experts can maintain the site without the need for HTML or web development skills
Easier integration with a shopping cart such as eCart or Cartweaver.

In much the same way that Dreamweaver automatically creates the HTML code for a page, it can also create the PHP code needed to provide functionality that is not available with Dreamweaver's default dynamic features, some PHP code must be written by hand.

What You Will Learn

During the Dreamweaver Dynamic Application Development course, the following topics are covered. See outline below for more in depth detail on Dynamic websites and application servers.

Setting up a PHP & MySQL environment on Mac & Windows
Basic PHP coding
Creating a secure and accessible contact form
Designing and creating a MySQL database.

Retrieving and displaying database content
Inserting, updating, and deleting database records
Providing detailed information about items displayed in a list
Registering and authenticating users.

Dreamweaver Dynamic

Dreamweaver Dynamic | Outline

About Dynamic Websites

Dynamic vs Static sites
Application Servers

Setting Up a Local Development Environment

Install & configure Apache, PHP, MySQL on Mac & Windows
Using an integrated server environment such as XAMPP or Mamp
Preparing Dreamweaver for PHP development
Define a PHP & MySQL site in Dreamweaver

Introduction to PHP

PHP syntax, Variables, Functions, Arrays
Replacing static page elements with dynamic content
Dynamically Related Files
Passing data between pages using forms and hyperlinks

Enabling communication with a contact form

email header injection, What is it, how do you prevent it?
Install & configure a secure accessible Contact Form Script
Styling the form so that it matches the site layout

The MySQL Database

Database Design
Creating a MySQL database
Defining database tables
Setting up user accounts
Importing data

Retrieving content from the Database

Displaying content from the database
Connecting to the database from Dreamweaver
SQL Structured Query Language
Running SQL queries in Dreamweaver, Recordsets
Regularly updating content items on the homepage
Displaying product information

List and detail pages

Displaying a list of products
Breaking a large list of records into smaller blocks
Recordset paging
Filtering with a recordset ID to display a single product
Creating a page to show detailed information about a product
Linking the list and detail pages
Joining database tables with SQL

Inserting information into the database

Inserting a new product into the database
Creating dynamic list menus
Storing text content into a database

Registering and Authenticating Users

Design & implement a registration & authentication system
Allowing users to log in and log out of the website
Restrict access based on username, password & access level
Creating pages only accessible to site administrators

Updating and Deleting Database Records

The SQL UPDATE and DELETE commands
Updating records in the database
Deleting Records

Sydney
Melbourne
Brisbane
Canberra

SYDNEY Select a date to book online now	May	Jun	Jul	Aug	Sept	Oct
HTML & Web Principles	22	3 19	8 31	19	6 25	11 21
Dreamweaver Essentials	23 & 24	—	4 & 5	20 & 21	26 & 27	22 & 23
CSS Essentials	23 & 24	27 & 28	—	8 & 9	19 & 20	31 Oct & 1 Nov
Dynamic Dreamweaver	Please call to book

MELBOURNE Select a date to book online now	May	Jun	Jul	Aug	Sept	Oct
HTML & Web Principles	22	—	1 31	21	10 30	24
Dreamweaver Essentials	23 & 24	—	2 & 3	22 & 23	—	1 & 2
CSS Essentials	—	3 & 4	10 & 11	26 & 27	—	10 & 11
Dynamic Dreamweaver	Please call to book

BRISBANE Select a date to book online now	May	Jun	Jul	Aug	Sept	Oct
HTML & Web Principles	1	19	26	—	2	16
Dreamweaver Essentials	—	25 & 26	—	—	3 & 4	19 & 20 Nov
CSS Essentials	Currently not available as a public course but private training can be organised.

CANBERRA Select a date to book online now	May	Jun	Jul	Aug	Sept	Oct
HTML & Web Principles	15	—	—	12	—	14
Dreamweaver Essentials	—	—	—	13 & 14	—	—
CSS Essentials	—	—	—	—	3 & 4	—