Dreamweaver CS5: Dynamic Application Development
With Dreamweaver CS5 you can quickly design, develop and maintain database-driven web applications. Built for both designers and developers, Dreamweaver offers the choice of working with a visual interface or a streamlined coding environment.
Quick Facts
Duration: 3 Days
Class Size: 10
Level: Int / Adv
Times: 9.00am - 5.00pm approx.
About the course
During this 3 day course, participants will learn to build a dynamic application, 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 CS5: Website Development or have the equivalent experience. In addition, students must have a good understanding of HTML.
Course Units
- Unit 1: About Dynamic Websites
- - Dynamic vs Static websites
- - Understanding Application Servers
- - Understanding Site Map
|
- Unit 2: Set Up a Local Development Environment
- - 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
- - 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
- - 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
- - 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
- - 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
- - 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
- - 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
- - 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
- - 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
- - 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
- - 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
|
Upcoming Courses
|
Sydney
Level 11, 32 Walker Street
North Sydney
View map
|
- Date:
- 29 Feb - 02 Mar 12
- 21-23 May 12
|
|
Melbourne
Level 12, 379 Collins Street
Melbourne
View map
|
- Date:
- 28-30 Mar 12
- 20-22 Jun 12
|
|
Brisbane
C/- Support Technology, Level 6, 371 Queen Street
Brisbane
View map
|
- Date:
- 12-14 Mar 12
- 06-08 Jun 12
|
|
Canberra
C/O Atlas Business Services, 21 Barry Drive
Turner
View map
|
Date: upon demand
|
|
Adelaide
C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street
Adelaide
View map
|
Date: upon demand
|
|
Perth
C/- Lansen Consulting Pty Ltd, Level 1, 484 Albany Highway
Victoria Park
View map
|
Date: upon demand
|
Quick Facts
Duration: 3 Days
Class Size: 10
Level: Int / Adv
Times: 9.00am - 5.00pm approx.
