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


"Absolutely top quality training and facilities."

National Museum of Wales

"Probably the best course I have been on. Very thorough and entertaining."

Cancer Research UK

"The best two days training I have ever had. Would definitely recommend and use again."

Surrey Heath Borough Council



 

 

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