Adobe Dreamweaver: Dynamic Application Development with PHP and MySQL

Duration: 3 Days

Objectives

This Adobe certified course provides students with the knowledge and hands-on practice they need to build a dynamic data-driven web application with Dreamweaver. The course focuses on teaching the fundamentals of web programming languages and databases to build a dynamic, data-driven application using Dreamweaver, PHP and MySQL.

Pre-requisites

None other than basic IT competency.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Getting Started

  • Overview of the web client-server relationship
  • Understanding static vs. dynamic pages
  • Introducing server-side scripting
  • Installing and configuring a Web Server
  • Setting up the Application Server
  • Installing the database
  • Testing the Web Server
  • Developing with a remote vs. local server
  • A brief introduction to server-side code
  • Documenting your code with comments

Setting up a Site

  • Defining a new dynamic site
  • Specifying the server model
  • Creating a new dynamic page
  • Including common code with Server-Side Includes

Overview of Databases

  • Types of databases: flat files, hierarchical, relational
  • Advantages of Relational Databases
  • Types of Relational Databases
  • Records, Fields and Values
  • Primary and Foreign Keys
  • Using databases on the Web
  • Connecting to databases
  • Structured Query Language (SQL)

Using the Database Panel

  • Creating a database connection
  • Looking at the code Dreamweaver creates
  • Using the Bindings panel to create a simple recordset
  • Creating an advanced recordset using joins

Binding Data to a Page

  • Binding Data to a page; Using Live Data View
  • Formatting data using the Bindings panel
  • Inserting a dynamic image

Customising Recordset Display

  • Introducing Server Behaviours
  • Showing rows in a recordset with Repeat Region
  • Building recordset paging manually
  • How to show or hide data conditionally
  • Displaying Recordset Navigation Status

Introduction to SQL

  • What is SQL? Using SQL in Dreamweaver
  • Using the SELECT Statement
  • Filtering a recordset with SQL
  • Specifying a sort order with SQL
  • Combining two or more tables

Passing data between pages

  • Understanding the HTTP protocol
  • Two methods for sending data: GET and POST
  • Retrieving data with query strings/URL variables
  • Retrieving data from hyperlinks
  • Retrieving data from form variables

Creating a Search Interface

  • Reviewing HTML Forms
  • Creating dynamically populated drop-down menus
  • Creating filtered recordsets

Creating Drill-Down Interfaces

  • Planning an application
  • Creating a drill-down interface
  • Generating URLs dynamically
  • Creating a master-detail page set

Inserting Data into a Table

  • Creating a form and using the Insert Record Server Behaviour
  • Validating form data using Behaviours
  • Creating dynamic form elements
  • Client-side form validation

Updating Records

  • Creating an interface for updating data
  • Displaying results in a table using the Dynamic Table Application Object
  • Creating a pre-filled form for the row to update
  • Using URL parameters / Record Update Form Application Object
  • Manually creating a form and applying an Update Record Server Behaviour

Deleting Rows

  • Understanding the delete process
  • Creating a delete confirmation page
  • Passing hidden data in a form
  • Deleting a specific record

Authenticating Users

  • Authenticating users with a web application
  • Building the login page
  • Restricting access to pages
  • Applying different levels of access

Sending E-mail from a Web Form

  • Overview of form mailing
  • Code required to send an email
  • Creating the Web form
  • Using a secure email script

Using Dreamweaver with popular Content Management Systems

  • Using Site-Specific Code Hints
  • WordPress, Drupal and Joomla sites directly in the Dreamweaver Document window

This course is available as a private or customised course. Contact us for further information and to customise this course to your exact requirements:

Phone us: 0208 269 4260Book Now

Related Courses


"Amazing industry knowledge."

The Economist Group

"Clear and concise explanations of all program capabilities, very helpful."

Hyder Consulting Ltd

"The whole experience was great. Trainer and staff were extremely helpful and approachable."

Faithful & Gould



 

 

© Transmedia . 277 Greenwich High Road London SE10 8NB  UK . 0208 269 4260
Designed by Transmedia's Web Team