Lynda.COM Dreamweaver CS4 Dynamic Development

David Gassner

Software works on:

Mac and Windows

Topics include:

• Installing software
• Authenticating users
• Integrating websites with ColdFusion and PHP
• Layering web pages with the Spry framework
• Adding visual effects to a web page
• Building data-entry systems
• Testing web pages with Live View and Live Code

Introduction
Welcome           01:20
Series overview           03:07
Using ASP and ASP.NET with Dreamweaver           01:38
Installing the exercise files           01:34
17:37 1. Understanding Browsers, Servers, and Databases
Static vs. dynamic web pages           05:58
Selecting an application server           04:51
Selecting a database           06:48
12:54 2. Installing Required Software
Introducing Apache, MySQL, and PHP           02:51
Installing WAMP on Windows           04:34
Installing MAMP on Mac OS X           03:04
Installing the exercises database           02:25
25:55 3. Defining a Site with PHP and MySQL
Setting up the PHP exercise files           01:55
Defining a Dreamweaver site           03:50
Understanding basic PHP code           02:24
Inserting simple PHP commands           02:40
Using Live View and Live Code with PHP           02:49
Using server-side includes           06:46
Defining a database connection           05:31
44:17 4. Defining a Site with ColdFusion and MySQL
Installing ColdFusion on Windows           04:38
Installing ColdFusion on Mac           05:35
Completing the ColdFusion installation           01:22
Using the ColdFusion Administrator           04:44
Setting up the ColdFusion exercise files           01:44
Defining a Dreamweaver site           03:22
Understanding basic ColdFusion code           03:30
Using Live View and Live Code with PHP           02:00
Inserting simple ColdFusion commands           03:25
Using server-side includes           07:10
Defining a ColdFusion data source           06:47
46:36 5. Using Bindings and Server Behaviors
Working with data in PHP and ColdFusion           01:36
Using the Bindings and Server Behaviors panels           02:54
Building a simple recordset           05:30
Building an advanced recordset           05:08
Using repeating regions           03:32
Generating a dynamic table           04:23
Applying string formats           04:32
Displaying the total number of records           01:52
Limiting the number of records with paging controls           05:58
Creating conditional regions           03:39
Creating a Master Detail page set           07:32
53:10 6. Building Data Entry Systems
Understanding data entry systems           03:47
Preparing a record insert form with recordsets           03:38
Using the Record Insertion Form wizard           07:17
Creating a custom data entry form           07:44
Using the Insert Record server behavior           04:26
Using the Record Update Form wizard           07:15
Displaying existing data in form controls           06:23
Using the Update Form behavior           03:14
Creating list page links to edit and delete data           03:28
Using the Delete Record server behavior           05:58
24:28 7. Authenticating Users with ColdFusion
Enabling J2EE sessions in ColdFusion           03:24
Creating an Application.cfc file           04:58
Creating a login form page for ColdFusion           04:26
Logging in with a ColdFusion server behavior           05:02
Protecting page access with ColdFusion server behaviors           03:30
Logging out with a ColdFusion server behavior           03:08
16:18 8. Authenticating Users with PHP
Creating a login form page for PHP           05:17
Logging in with a PHP server behavior           02:56
Protecting page access with PHP server behaviors           04:18
Logging out with a PHP server behavior           03:47
15:48 9. Validating Forms with Spry
Understanding client-side form validation           03:48
Validating form controls           06:18
Laying out the validation user interface           02:55
Modifying validation display with CSS           02:47
37:01 10. Using Spry XML Data Sets
Creating a Spry XML data set           05:58
Generating XML output with ColdFusion           04:19
Generating XML output with PHP           04:22
Generating HTML output           05:23
Creating a Spry table           04:13
Formatting Spry tables           04:59
Generating a repeating list           03:23
Creating a Spry repeating region           04:24
23:02 11. Creating a Dynamic User Interface with Spry
Using multiple record sets and displaying multiple dynamic tables           03:49
Using a Spry accordion           04:24
Using Spry tabbed panels           04:21
Using Spry collapsible panels           04:23
Using a Spry menu bar           06:05
00:53 Conclusion
Goodbye           00:53