Dreamweaver CS5 with PHP and MySQL

Introduction
Welcome
Understanding the prerequisites
Using the exercise files

1. Understanding Browsers, Servers, and Databases
Understanding static vs. dynamic web pages
Selecting application and database servers
Introducing Apache, MySQL, and PHP
Installing WampServer on Windows
Taking a tour of WampServer
Installing MAMP on Mac OS X
Taking a tour of MAMP

2. Getting Started with Dreamweaver and PHP
Defining a Dreamweaver site
Configuring a PHP testing server
Creating and testing a first 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 with 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