1300 888 724

8.30am to 5:30pm AEST (Mon-Fri)

Dreamweaver: Dynamic Application Development Course

(4.75 out of 5) 21 Student Reviews

About the course

During this 3 day course, participants will learn to build a dynamic web application using Dreamweaver CS6; with data transfer, email interactivity, forms, databases and drop-down menus. Other areas covered include filtering, recordsets, building search interfaces and authenticating users. The training exercises are conducted using a mock-website, so students finish the training with real world confidence.

Who should do this course?

This course is designed for anybody who wants to build database-driven website using PHP scripting language.

Prerequisites

Students should have already completed Dreamweaver: Website Development or have the equivalent experience. In addition, students must have a good understanding of HTML.

Course Details

Course Dates

  • Sydney Class Dates

    Level 11, 32 Walker Street, North Sydney , NSW 2060

    Classes scheduled on demand in Sydney

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

  • Melbourne Class Dates

    Level 12, 379 Collins Street, Melbourne , VIC 3000

    Classes scheduled on demand in Melbourne

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

  • Brisbane Class Dates

    Level 6, 371 Queen Street, Brisbane , QLD 4000

    Classes scheduled on demand in Brisbane

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

  • Canberra Class Dates

    Level 1, 33 Ainslie Place, Canberra , ACT 2601

    Classes scheduled on demand in Canberra

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

  • Adelaide Class Dates

    19 Young Street, Adelaide , SA 5000

    Classes scheduled on demand in Adelaide

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

  • Perth Class Dates

    Level 1, 140 St Georges Terrace, Perth , WA 6000

    Classes scheduled on demand in Perth

    Please Join our waitlist and we'll notify you when a new class is scheduled or contact us to disucss your training needs.

Course Units

Expand full topic list

Unit 1: About Dynamic Websites

See topics

  • Dynamic vs Static websites
  • Understanding Application Servers
  • Understanding Site Map

Unit 2: Set Up a Local Development Environment

See topics

  • Installing and configuring XAMPP
  • Installing MySQL Workbench
  • Installing Notepad++
  • Setting up Dreamweaver for PHP development
  • Set Dreamweaver preferences
  • Define a Site in Dreamweaver
  • Examine the current static site
  • Replace ".html" extensions with ".php"
  • Checking your PHP installation with phpinfo()

Unit 3: Introduction to PHP

See topics

  • PHP Syntax
  • Functions
  • Include Files
  • Setting up the nav bar as an include file
  • Variables
  • Operators
  • Arrays
  • Discover Dynamically-Related Files
  • Conditional Statements
  • HTTP Request and Response
  • Creating a test form page
  • Capturing the form data with PHP variables
  • Encoding a hyperlink with a query string
  • Set up the footer as an include file

Unit 4: Install and Configure a Contact Form

See topics

  • Email header injection
  • Install the GBCF-v3 Form Script
  • Link the GBCF-v3 form page to contact.php
  • Customise the form to match the site layout
  • Test for header injection

Unit 5: Create and Populate a MySQL Database

See topics

  • Introduction to MySQL and phpMyAdmin
  • Create a database
  • MySQL field names and data types
  • Create a database table
  • Import data from an Excel document
  • Create and import data into a tips table
  • Set up MySQL user accounts
  • Create additional database tables
  • Import data into the new tables

Unit 6: Displaying Content from the Database

See topics

  • Creating Connections to the database
  • Introduction to SQL (Structured Query Language)
  • Run SQL queries in phpMyAdmin
  • Run SQL queries in MySQL Workbench
  • Creating a Recordset (SQL Query)
  • Displaying dynamic content on a page
  • Displaying a single tip on the home page
  • Server Behaviors
  • Displaying multiple tips on the home page
  • Displaying lists

Unit 7: Master & detail pages

See topics

  • Creating a master list
  • Displaying a dynamic image
  • Adding a recordset navigation bar
  • Displaying the recordset navigation status
  • Linking the master & details pages
  • Filter using the WHERE clause
  • Creating a filtered recordset
  • Populating the details page
  • Joining database tables with the WHERE clause
  • Joins in phpMyAdmin
  • Formatting a number
  • Creating an administrative template

Unit 8: Inserting information into the database

See topics

  • The SQL INSERT statement
  • Creating an insert form
  • Making the list menus dynamic
  • Creating a dynamic list menu
  • Creating an admin list page
  • Inserting a new record
  • Creating a insert form
  • Storing text content in a database table
  • Installing and configuring TinyMCE
  • Creating and populating database tables
  • Creating a page to list the site users
  • Creating a page to register a new user
  • Inserting a new user

Unit 9: Registering and Authenticating Users

See topics

  • Checking for existing usernames
  • Creating login failed and welcome pages
  • Completing the login page
  • Creating a log out page
  • PHP sessions
  • Restricting Access to Page server behavior
  • Greeting user by name on the welcome page
  • Restricting access to admin pages
  • Creating an administrator menu page

Unit 10: Updating and Deleting Database Records

See topics

  • Adding dynamic update and delete links
  • The SQL UPDATE statement
  • Creating an update form
  • Updating an existing record
  • The SQL DELETE statement
  • Creating a delete page
  • Deleting an existing product
  • Modifying the list page
  • Creating a update page
  • Creating a delete page

Unit 11: Searching the Database

See topics

  • Creating a search page
  • SQL queries using wildcards
  • Displaying the search results
  • Showing and hiding items based upon the data retrieved
  • Showing a message when no records are found
  • Hiding the Recordset Navigation Bar
  • The SQL LIKE operator and Percent (%) wildcard
  • Filtering using SQL variables
  • Creating the joining & filtering SQL query
  • Linking to the details page
  • Creating a search page
  • Creating a results page

Unit 12: Performing Calculations

See topics

  • Creating an advanced recordset
  • Displaying details
  • Adding a form for user to specify data
  • Linking from the product-detail.php page
  • Calculations with PHP
  • Completing the cost estimator results page

Related Courses:

Course Reviews

(4.90 out of 5) Celie C [ 10 October, 2012 ]
Thoroughly enjoyed this course. Would like a similar course that outlines all the other administrative aspects of dynamic web sites
(4.90 out of 5) Janine R [ 26 March, 2012 ]
Everything has finally started to gel, so I am now looking forward to practicing what I have learnt.
(5.00 out of 5) Bree S [ 12 March, 2012 ]
Really great course. Taught me some great techniques that I will use in the real world. Thank you very much!
(5.00 out of 5) Tom F [ 29 February, 2012 ]
Jonathan is a wonderful trainer who ensures everyone gets what they came for and learns as much as possible in the given time. He has as a thorough knowledge of the subject and shares a wealth of experience through detailed examples and practical exercises, making the course a pleasure to attend.

Enquire Now

Fill in your details to have a training consultant contact you to discuss your training needs.

Your details

Other Ways To Get In Touch

You can also Book Online or call us on 1300 888 724

Back to Top