Dreamweaver with PHP and MySQL [repost]

Join author David Gassner as he describes how to add dynamic data to a PHP-enabled web site in Adobe Dreamweaver. This intermediate course shows how to plan and create a MySQL database, define a PHP-enabled site in Dreamweaver, connect the site to the database, and manage and present dynamic data. David also explores Dreamweaver features such as PHP custom class introspection and site-specific code hinting as well as the differences between the CS5 and CS6 versions of the software.

Topics include:
Understanding dynamic versus static content
Adding PHP commands to web pages
Setting and outputting variables
Using server-side includes
Creating PHP custom classes
Adding the Zend Framework to a PHP installation
Creating a MySQL database
Adding data in phpMyAdmin
Building recordsets
Formatting dynamic data
Building data entry forms
Authenticating users
Deploying a dynamic site

Introduction
Welcome
What you should know before watching this course
Using the exercise files
Understanding the differences between Dreamweaver CS5.5 and CS6

1. Understanding Browsers, Servers, and Databases
Understanding static vs. dynamic web pages
Selecting application and database servers
Introducing Apache, MySQL, and PHP
Installing Apache, MySQL, and PHP

2. Getting Started with Dreamweaver and PHP
Defining a Dreamweaver site
Configuring a PHP testing server
Creating and testing a PHP-based web page
Adding PHP commands with the Insert panel
Setting and outputting simple variables
Testing pages with Live view and Live Code view
Using server-side includes
Navigating included pages with the Code Navigator

3. Managing PHP Code
Using code hinting with PHP variables
Understanding PHP custom classes
Adding Zend Framework to PHP on Windows
Adding Zend Framework to PHP on Mac
Using the Site-Specific Code Hints feature
Using Zend Framework classes with code hints
Managing reusable code with the Snippets panel

4. Creating a Database
Understanding relational databases
Creating a MySQL database in phpMyAdmin
Adding data in phpMyAdmin
Importing a completed database from a script

5. Using Bindings and Server Behaviors
Defining a Dreamweaver database connection
Building a simple recordset
Building an advanced recordset
Displaying data with repeating regions
Displaying data in a dynamic table
Formatting dynamic data
Displaying the total number of records
Limiting records with paging controls
Creating conditional regions

6. Building Data Entry Forms
Building a simple data entry form
Handling form submissions with PHP
Creating a customer email form
Validating form controls with Spry
Populating a list control with dynamic data
Working with multiple checkbox controls
Sending email with Zend_Mail

7. Managing Server-Side Data
Using data wizards
Formatting dates for SQL
Creating a custom data entry form
Preparing a database table for server behaviors
Using the Insert Record server behavior
Preparing an update form
Using the Update Form behavior
Creating list page links to edit and update data
Using the Delete Record server behavior

8. Authenticating Users with PHP
Creating a login form with a PHP server behavior
Protecting page access with PHP server behaviors
Logging out with a PHP server behavior

9. Deploying a Dynamic Site to a Remote Server
Configuring a remote server with FTP credentials
Synchronizing site assets with the remote server
Exporting the MySQL database to a script
Importing the MySQL database on a remote server
Configuring the site for the remote database

Conclusion
Final thoughts