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
$1485 incl GST
- Duration:3 Days
- Max. Class Size:10
- Avg. Class Size:5
-
Study Mode:
Classroom Online Live
- Level:Advanced
- CPD Hours:18 hours
- Course Times: Classroom: 9.00am - 5.00pm approx.(Local Time) Online Live: 9.00am - 5.00pm approx.(AEST or AEDT)
- Download Course PDF
Course Dates
Sydney Class Dates
Level 11, 32 Walker Street, North Sydney , NSW 2060
Classes scheduled on demand in Sydney
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Melbourne Class Dates
Level 12, 379 Collins Street, Melbourne , VIC 3000
Classes scheduled on demand in Melbourne
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Brisbane Class Dates
Level 6, 371 Queen Street, Brisbane , QLD 4000
Classes scheduled on demand in Brisbane
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Canberra Class Dates
All courses facilitated in, Online Live format ,
Classes scheduled on demand in Canberra
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Adelaide Class Dates
All courses facilitated in, Online Live format ,
Classes scheduled on demand in Adelaide
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Perth Class Dates
All courses facilitated in, Online Live format ,
Classes scheduled on demand in Perth
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Course Units
⊕ Expand full topic list
Unit 1: About Dynamic Websites
- Dynamic vs Static websites
- Understanding Application Servers
- Understanding Site Map
⊕ See more
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()
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
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
⊕ See more
Related Courses
Student Reviews
Thoroughly enjoyed this course. Would like a similar course that outlines all the other administrative aspects of dynamic web sites
Everything has finally started to gel, so I am now looking forward to practicing what I have learnt.
Really great course. Taught me some great techniques that I will use in the real world. Thank you very much!
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.
Note: Form fields marked with * are required.
