Lynda.com: Dreamweaver CS5 with PHP and MySQL English | .mov (QuickTime) | 960x540 (16:9) | 05:00:00 | 679 Mb
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.
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 the Zend Framework to a PHP site 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 delete 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