Adobe Dreamweaver: Dynamic Application Development with PHP and MySQL

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