Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player

Book a Dynamic Dreamweaver Course

Dreamweaver CS5 graphic Dreamweaver Dynamic Application Development (PHP MySQL): $995

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.
Training Course Benefits

Dynamic Dreamweaver Course 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

Adobe Dreamweaver & CSS
COURSE OUTLINES

dreamweaver logo Dreamweaver Essentials Outline
2 day course: $795

CSS Essentials*
2 day course: $995

* Prerequisite quiz required.

MELBOURNE May June July August September October
Dreamweaver Essentials 15 & 16 19 & 20 19 & 20 28 & 29 — 11 & 12
CSS Essentials
(please call to book)		 21 & 22 — 12 & 13 30 & 31 — 23 & 24
Dynamic Dreamweaver
& Web Development 		— 21 & 22 — — — —

 

 

BRISBANE May June July August September October
Dreamweaver Essentials 2 & 3 — 5 & 6 21 & 22 — 11 & 12
CSS Essentials Currently not available as a public course in Brisbane. Private training can be organised.