Lynda.COM Dreamweaver CS5 with PHP and MySQL

Author:
David Gassner

Duration:
05h 06m

Released on:
9/22/2010

Exercise files:
Yes

Software works on:
Windows only

Join David Gassner in Dreamweaver CS5 with PHP and MySQL as he explains how to add dynamic data to a PHP-enabled web site in Dreamweaver CS5. This course shows how to plan and create a MySQL database, define a PHP-enabled site in Dreamweaver CS5, connect the site to the database, and manage and present dynamic data. Dreamweaver CS5 features are demonstrated throughout the video series, including PHP custom class introspection and site-specific code hinting. Exercise files are included with the course.
Topics include:

    Understanding dynamic versus static content
    Installing WAMP and MAMP servers
    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           01m 25s
Understanding the prerequisites           02m 21s
Using the exercise files           01m 40s

1. Understanding Browsers, Servers, and Databases
Understanding static vs. dynamic web pages           04m 32s
Selecting application and database servers           06m 10s
Introducing Apache, MySQL, and PHP           06m 36s
Installing WampServer on Windows           05m 41s
Taking a tour of WampServer           04m 10s
Installing MAMP on Mac OS X           04m 13s
Taking a tour of MAMP           03m 19s

2. Getting Started with Dreamweaver and PHP
Defining a Dreamweaver site           03m 22s
Configuring a PHP testing server           07m 11s
Creating and testing a first PHP-based web page           08m 25s
Adding PHP commands with the Insert panel           03m 14s
Setting and outputting simple variables           03m 56s
Testing pages with Live view and Live Code view           02m 09s
Using server-side includes           07m 50s
Navigating included pages with the Code Navigator           02m 50s

3. Managing PHP Code
Using code hinting with PHP variables           05m 31s
Understanding PHP custom classes           06m 38s
Adding Zend Framework to PHP on Windows           05m 18s
Adding Zend Framework to PHP on Mac           04m 02s
Using the Site-Specific Code Hints feature           03m 43s
Using Zend Framework classes with code hints           07m 26s
Managing reusable code with the Snippets panel           03m 59s

4. Creating a Database
Understanding relational databases           05m 26s
Creating a MySQL database in phpMyAdmin           04m 41s
Adding data in phpMyAdmin           02m 46s
Importing a completed database from a script           05m 34s

5. Using Bindings and Server Behaviors
Defining a Dreamweaver database connection           05m 27s
Building a simple recordset           04m 31s
Building an advanced recordset           05m 01s
Displaying data with repeating regions           06m 04s
Displaying data with a dynamic table           04m 24s
Formatting dynamic data           04m 54s
Displaying the total number of records           02m 04s
Limiting records with paging controls           04m 05s
Creating conditional regions           03m 14s

6. Building Data Entry Forms
Building a simple data entry form           05m 27s
Handling form submissions with PHP           05m 12s
Creating a customer email form           03m 09s
Validating form controls with Spry           07m 54s
Populating a list control with dynamic data           04m 50s
Working with multiple checkbox controls           08m 05s
Sending email with Zend_Mail           08m 35s

7. Managing Server-Side Data
Using data wizards           06m 20s
Formatting dates for SQL           05m 27s
Creating a custom data entry form           04m 50s
Preparing a database table for server behaviors           03m 03s
Using the Insert Record server behavior           05m 42s
Preparing an update form           07m 06s
Using the Update Form behavior           05m 46s
Creating list page links to edit and update data           07m 03s
Using the Delete Record server behavior           05m 34s

8. Authenticating Users with PHP
Creating a login form with a PHP server behavior           06m 29s
Protecting page access with PHP server behaviors           04m 17s
Logging out with a PHP server behavior           03m 59s

9. Deploying a Dynamic Site to a Remote Server
Configuring a remote server with FTP credentials           04m 42s
Synchronizing site assets with the remote server           05m 27s
Exporting the MySQL database to a script           03m 08s
Importing the MySQL database on a remote server           02m 24s
Configuring the site for the remote database           07m 09s

Conclusion
Final thoughts           00m 49s