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 Dates
-
Sydney Class Dates
Level 11, 32 Walker Street, North Sydney , NSW 2060
Classes scheduled on demand in SydneyPlease 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 MelbournePlease 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 BrisbanePlease 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 4, 54 Marcus Clarke Street, Canberra , ACT 2601
Classes scheduled on demand in CanberraPlease 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 AdelaidePlease 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 PerthPlease 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
- 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
Course Reviews
Enquire Now
Fill in your details to have a training consultant contact you to discuss your training needs.