[Lynda.com]Dreamweaver with PHP and MySQL

Dreamweaver with PHP and MySQL

 

with David Gassner

  

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.

This course was updated on 6/12/2012.

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

author

David Gassner

subject

Developer, Application Servers,Databases, Web Development

software

Dreamweaver CS5, CS5.5, CS6,MySQL 5, PHP 5

level

Intermediate

duration

4h 55m

released

Sep 22, 2010

updated

Jun 12, 2012

DVD

purchase

• table of contents
• exercise files
• transcript
• author
• preferences
• FAQs

subscribelearn more

Get immediate access to the entire library!

expand all | collapse all

viewed duration

Introduction8m 48s

Welcome1m 25s  

What you should know before watching this course2m 17s  

Using the exercise files1m 40s  

Understanding the differences between Dreamweaver CS5.5 and CS63m 26s  

1. Understanding Browsers, Servers, and Databases19m 31s

Understanding static vs. dynamic web pages4m 32s  

Selecting application and database servers6m 10s  

Introducing Apache, MySQL, and PHP6m 36s  

Installing Apache, MySQL, and PHP2m 13s  

2. Getting Started with Dreamweaver and PHP39m 34s

Defining a Dreamweaver site3m 22s  

Configuring a PHP testing server7m 48s  

Creating and testing a PHP-based web page8m 25s  

Adding PHP commands with the Insert panel3m 14s  

Setting and outputting simple variables3m 56s  

Testing pages with Live view and Live Code view2m 9s  

Using server-side includes7m 50s  

Navigating included pages with the Code Navigator2m 50s  

3. Managing PHP Code36m 37s

Using code hinting with PHP variables5m 31s  

Understanding PHP custom classes6m 38s  

Adding Zend Framework to PHP on Windows5m 18s  

Adding Zend Framework to PHP on Mac4m 2s  

Using the Site-Specific Code Hints feature3m 43s  

Using Zend Framework classes with code hints7m 26s  

Managing reusable code with the Snippets panel3m 59s  

4. Creating a Database18m 27s

Understanding relational databases5m 26s  

Creating a MySQL database in phpMyAdmin4m 41s  

Adding data in phpMyAdmin2m 46s  

Importing a completed database from a script5m 34s  

5. Using Bindings and Server Behaviors39m 35s

Defining a Dreamweaver database connection5m 27s  

Building a simple recordset4m 31s  

Building an advanced recordset5m 1s  

Displaying data with repeating regions6m 4s  

Displaying data in a dynamic table4m 15s  

Formatting dynamic data4m 54s  

Displaying the total number of records2m 4s  

Limiting records with paging controls4m 5s  

Creating conditional regions3m 14s  

6. Building Data Entry Forms43m 12s

Building a simple data entry form5m 27s  

Handling form submissions with PHP5m 12s  

Creating a customer email form3m 9s  

Validating form controls with Spry7m 54s  

Populating a list control with dynamic data4m 50s  

Working with multiple checkbox controls8m 5s  

Sending email with Zend_Mail8m 35s  

7. Managing Server-Side Data50m 51s

Using data wizards6m 20s  

Formatting dates for SQL5m 27s  

Creating a custom data entry form4m 50s  

Preparing a database table for server behaviors3m 3s  

Using the Insert Record server behavior5m 42s  

Preparing an update form7m 6s  

Using the Update Form behavior5m 46s  

Creating list page links to edit and update data7m 3s  

Using the Delete Record server behavior5m 34s  

8. Authenticating Users with PHP14m 45s

Creating a login form with a PHP server behavior6m 29s  

Protecting page access with PHP server behaviors4m 17s  

Logging out with a PHP server behavior3m 59s  

9. Deploying a Dynamic Site to a Remote Server22m 50s

Configuring a remote server with FTP credentials4m 42s  

Synchronizing site assets with the remote server5m 27s  

Exporting the MySQL database to a script3m 8s  

Importing the MySQL database on a remote server2m 24s  

Configuring the site for the remote database7m 9s  

Conclusion52s

Final thoughts52s