PHP and MySQL with Dreamweaver CS4

Cost:

$1,395.00 (Online Class - Lodestone Live)
$1,595.00 (Lodestone Training Center)

Time: 10 AM - 4:30 PM EST
Length: 2 day class
Type: Instructor-led

Course Description:

This class concentrates on getting the best out of Dreamweaver CS4 when programming PHP and MySQL. If you are a web designer and have never programmed a line of PHP - this class is for you. You will cover all aspects of the new user interface as related to PHP programming, including workspace layouts, iconic panels, the related documents feature, Live View, Code Navigator, and Live Code.

Learning Objectives:

After taking this class you will be able to:

• Streamline your workflow with the Related Files toolbar, Live view, and the Code Navigator
• Use server-side includes, templates, and Adobe's InContext Editing online service
• Create dynamic web applications using Dreamweaver's PHP server behaviors
• Build real world web site functions, such as form validation
• How to publish your site after you've created it

Target Audience:

This class is focused on web designers with no prior middleware programming experience. It will be helpful if you know a little HTML and have worked inside Dreamweavwer CS4 for a few weeks.

Course Outline:

Lesson 1: Introducing the Basics of PHP

• Understanding what PHP is for
• Writing PHP scripts
• Displaying PHP output
• Commenting scripts
• Working with numbers
• Using arrays to store values
• Making decisions
• Using loops
• Using functions
• Understanding PHP error messages

Lesson 2: Using PHP to Process a Form

• Getting information from the server with PHO superglobals
• Sending email
• Improving security
• Redirecting to another page
• Blocking submission by spam-bots

Lesson 3: Using PHP Includes

• Including text and code from other files
• Making things easier with includes
• Displaying HTML output
• Avoiding problems/errors
• Recycle code
• Adapting code as an include

Lesson 4: Storing Records in a Database

• Introducing MySQL
• Understanding terminology
• Using MySQL with a graphic interface
• Using phpMyAdmin
• Setting up your first database
• How databases work
• Building a registration system
• Storing, Updating and deleting records

Lesson 5: Validating Database Input and User Authentication

• Analyzing PHP code generated by Dreamweaver
• Server Behavior code
• Connecting to the database
• Preventing SQL injection
• Adding server side validation
• Verifying fields
• Verifying a password
• Building a custom server behavior
• PHP Sessions
• Authenticate a user

Lesson 6: Working with Custom Forms and Multiple Tables

• Storing related information in seprate tables
• Selecting records from more than one table
• The four essential SQlL commands
• Managing content
• Inserting records
• Working with large databases
• Deleting records

Lesson 7: Handling Checkbox Groups, Searches and Dates

• Storing multiple values in a SET column
• Gettin ginformation you want from a database
• Enhancing the display of search results
• Reusing a record set
• Formatting dates and time

There are currently no public classes scheduled dates for this class. To schedule a private class, please call us toll free at 866-665-9441.

Please note, assigned instructor may change. Lodestone confirms instructor schedules two weeks prior to class date.

*Classes are online via Lodestone Live and at a Lodestone training center.
The only time that a class will cancel is either if there is a power failure or other major disruption in service.