Adobe Dreamweaver CS3 with ASP, ColdFusion, and PHP: Training from the Source

Table of contents

1. Copyright
   1. Dedication
2. Bios
3. Acknowledgments
4. Introduction
   1. Prerequisites
   2. Outline
   3. The Project Site
   4. Elements and Format
   5. If You Get Stuck
   6. About This Edition
   7. Adobe Training From The Source
   8. Adobe Authorized Training and Certification
   9. What You Will Learn
   10. Minimum System Requirements: Windows
   11. Minimum System Requirements: Macintosh
5. 1. Introducing Newland Tours
   1. Defining a Static Site
   2. Creating the Contact Us Page
   3. Formatting the Contact Us Page
   4. Assessing the Site: The Code
   5. Assessing the Site: Business Processes
   6. A Glimpse of the Future
   7. What You Have Learned
6. 2. Preparing the Static HTML and CSS
   1. Automating Changes with Find and Replace
   2. Redefining HTML Elements with CSS
   3. Creating and Applying Custom CSS Styles
   4. Creating a Reusable Template
   5. Enhancing Accessibility with Invisible Navigation
   6. What You Have Learned
7. 3. Dynamic Web Sites
   1. Dynamic Web Site Basics
   2. Choosing a Server Model
      1. Side by Side with ASP, ColdFusion, and PHP: A Strategy for Learning
   3. Redefining the Newland Tours Site for Dynamic Development
   4. Developing with a Local Server
   5. Setting Up a Local Environment for IIS/ASP
   6. Setting Up a Local Environment for ColdFusion
   7. Setting Up a Local Environment for Apache/PHP
      1. Installing Apache, MySQL and PHP for Windows
      2. Installing Apache, MySQL and PHP for Mac OS X
   8. Developing with a Remote Server
   9. Defining a Dynamic Site in Dreamweaver (All Users)
   10. Building a Simple, Dynamic Application
       1. Creating the Input Page
       2. Creating the Output Page
   11. What You Have Learned
8. 4. Passing Data Between Pages
   1. Understanding the HTTP Protocol
   2. Retrieving Data from the URL
   3. Sending Data with Hyperlinks
   4. Setting and Retrieving Cookies
   5. What You Have Learned
9. 5. Sending Email from a Web Form
   1. Introducing SMTP Email Service
   2. Configuring Your System to Send SMTP Email Messages
   3. Configuring IIS to Send Email (ASP Users)
   4. Configuring ColdFusion to Send Email
   5. Configuring PHP to Send Email
      1. Windows
      2. Macintosh
   6. Writing the Code to Send a Message
   7. Understanding Objects, Methods, and Properties
   8. Creating the Web Form
   9. Emailing Dynamic Form Values
   10. Client-Side Form Validation
   11. What You Have Learned
10. 6. Building a Tour Price Calculator
    1. Creating the Pages
    2. Building the Form
    3. Collecting, Processing, and Displaying the Data
    4. Adding Server-Side Form Validation
    5. Creating the Conditional Region
    6. Creating and Applying a Custom CSS Class
    7. What You Have Learned
11. 7. Databases on the Web
    1. A Crash Course on Databases
    2. Introducing Database Objects
    3. Understanding Relationships
    4. Databases on the Web
    5. Database Security and the Web
    6. Installing the Newland Tours Database in MySQL
       1. Opening phpMyAdmin in a Local Windows Installation
       2. Opening phpMyAdmin in a Local Macintosh Installation
       3. Creating the Newland Tours Database on a Local Server
       4. Creating and Populating the Newland Tours Database on a Remote Server
    7. Touring the Newland Database
    8. Connecting to a Database
       1. ASP Users (Running IIS Locally or Connecting to a Remote Server)
       2. ColdFusion Users (Running ColdFusion Locally or Connecting to a Remote Server)
       3. PHP Users (Running PHP/MySQL Locally or on a Remote Server)
    9. Retrieving Recordsets and Displaying Database Information
    10. What You Have Learned
12. 8. Completing the Price Calculator
    1. Dynamically Populated Drop-Down Menus
    2. Creating Filtered Recordsets
    3. Revising the Calculation Script With Live Data
    4. Documenting Your Code With Comments
    5. What You Have Learned
13. 9. Filtering and Displaying Data Using Ajax
    1. Passing and Using Data with Ajax
    2. Expanding Dreamweaver with Extensions
    3. Turning a Recordset into XML
    4. Connect Country Profiles page to XML data
    5. Building a Spry Table
       1. Styling the Spry Table
    6. Creating Spry Regions
    7. Displaying with a Spry Accordion
    8. Adding Images and the Country Name
    9. Looking Up Foreign Table Data with SQL
    10. Refining Page Display Using CSS Styling and Positioning
        1. Padding and Positioning the Country Table
        2. Padding and Positioning the Accordion Panels
    11. What You Have Learned
14. 10. Building the Tour Descriptions
    1. Planning the Application
    2. Creating Recordsets with Joins
    3. Building the Descriptions
    4. Inserting the Images and alt Attributes
    5. Implementing Recordset Paging
    6. Passing Data to Other Applications
       1. Passing Data to Spry
       2. Using Passed Data to Set a Form Value
    7. What You Have Learned
15. 11. Building Search Interfaces
    1. Preparing the Search Page and Creating the Search All Link
    2. Searching by Region: Building the Interfaces
    3. Revising the Query and Commenting Code for Testing and Debugging
    4. Suppressing the Navigation Bar
    5. Searching by Country: Filtering by Form Variable
    6. Modifying SQL Statements According to Environmental Variables
    7. What You Have Learned
16. 12. Authenticating Users
    1. User Authentication as a Web Application
    2. Building the Registration Pages
    3. Building the Log-in Page
    4. Creating Application.cfc (ColdFusion Only)
    5. Restricting Access to Pages
    6. What You Have Learned
17. 13. Managing Content with Forms
    1. Creating the Admin Section
    2. Formatting Content Stored in a Database
    3. Creating the Form Interface
    4. Using Session Variables and Hidden Fields to Track Users
    5. Inserting the Record
    6. What You Have Learned
18. 14. Building Update Pages
    1. Preparing the Pages
    2. Planning for the Master-Detail Pages
    3. Making the Detail Page Updateable
    4. What You Have Learned
19. 15. Hand-Coding a Basic CMS
    1. Preparing the Content Management System
    2. Building the Form and Hand-Coding a Recordset
    3. Adding the Insert Functionality
    4. Creating the Master Page
    5. Creating the Update Record Detail Page
    6. Adding the Update Functionality
    7. Adding the Delete Functionality
    8. Update the Links on the Admin Page
    9. Where to Go from Here
    10. What You Have Learned