Building Data-Driven PHP Web Sites with Dreamweaver Training

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