Building Data-Driven PHP Web Sites with Dreamweaver
Duration:
3 days
Overview
MobileK16.com's "Building Data-Driven PHP Web Sites with Dreamweaver" course teaches attendees the Dreamweaver and PHP skills they need to integrate databases with their Web site.
Location and Pricing
Most of our courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.
In addition, some courses are available as live, online classes for individuals.
PHP with Dreamweaver Training Prerequisites
MobileK-16.com's Beginning Adobe Dreamweaver CS4, Introduction to Adobe Dreamweaver CS4, or equivalent experience.
Alternative Class
If you are interested in learning PHP programming, we encourage you to consider our Introduction to PHP & MySQL training class.
Hands-on/Lecture Ratio
This Dreamweaver training class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 15 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.
PHP with Dreamweaver Training Materials
All students for this Dreamweaver training class receive a copy of Adobe Press' Adobe Dreamweaver with ASP, ColdFusion, and PHP: Training from the Source and related courseware.
Software Needed on Each Student PC
Firefox 2.0 or later or Internet Explorer 6 or later
• Dreamweaver CS4, CS4, or later (course can also be taught using Dreamweaver MX 2004 or MX)
• Microsoft Internet Information Server, Apache Web server, Tomcat, or another appropriate Web server software package (please contact us for details)
• PHP 4.3 or later, downloadable from http://www.php.net
• A database server, such as MySQL™ (free), SQL Server, or Oracle (this can be installed on each student PC or on a server reachable over the network from these PCs)
PHP with Dreamweaver Training Objective
To learn how to build data-driven Web sites using Dreamweaver, PHP, and a database
PHP with Dreamweaver Training Outline
• Introduction
◦ Roles of server-side languages
◦ Choosing a server-side language
◦ Which server-side language is best?
◦ Overview of PHP and its requirements
◦ Goals of this class / Who is this class for?
• Creating a Dreamweaver site
◦ Site creation - basic
◦ Site creation - advanced
• Database connections
◦ Database basics
◦ Introduction to SQL
◦ Server behaviors
• Querying the database
◦ Building a SQL query using the Simple view
◦ Building a SQL query using the Advanced view
◦ Adding fields from the resulting records to your page
• Displaying and formatting query results
◦ Using Repeat Region to display multiple records
◦ Formatting results
• Paging through records
◦ Schemes for recordset navigation
◦ Paging to first, last, previous, and next records
• Show region if...
◦ Selectively displaying information based on a conditional
◦ Disabling the first and previous record links if the first page of results is displayed
◦ Disabling the last and next record links if the last page of results is displayed
• Displaying the count of the number of records returned
• Creating master-detail views
◦ Overview of the importance of master-detail views and how they convey information
◦ Creating a master-detail view
• Advanced recordsets and multi-table queries
◦ Method 1 - Simple recordset with filter
◦ Method 2 - Advanced recordset
◦ Method 3 - Advanced recordset and multi-table Queries
• Dynamically populating forms
◦ Populating text fields, text areas, and hidden fields
◦ Populating selection lists, radio button lists, and checkboxes
• Building record insertion forms
◦ Building the insertion form by hand
◦ Allowing Dreamweaver to generate the record insertion form automatically
◦ Creating a page that confirms the record insertion
◦ Validating form entries using JavaScript behaviors
• Understanding stored procedures
◦ How they are created in the database
◦ Advantages/disadvantages of stored procedures versus SQL
◦ Calling a stored procedure without passing parameters
◦ Passing input parameters to a stored procedure
◦ Retrieving parameters from a stored procedure
• Updating records
◦ Manually constructing a form that allows the user to update a record
◦ Using Dreamweaver to automatically generate a form for updating the record
◦ Validating the edited information using JavaScript behaviors
◦ Building a confirmation page to display the result of updating the record
• Deleting records
◦ Precautions to take to ensure that records are not inadvertently deleted
◦ Building an appropriate record deletion interface, complete with confirmation dialog
• Implementing user login/logout with Dreamweaver
◦ Overview of Web application security issues
◦ Preferred approach: configuring the Web server to manage security
◦ Alternative approach: having Dreamweaver automatically generate code for logging users in, authenticating them, and logging them out
◦ In-depth instruction on using Dreamweaver with PHP to implement user login/logout and page-by-page authentication • Conclusion
