You are previewing Macromedia® Dreamweaver® 8 Recipes.
O'Reilly logo
Macromedia® Dreamweaver® 8 Recipes

Book Description

Looking for timesaving ways to get frequently needed data-driven applications up and running? Look no further! In this book, you’ll find a primer for using data sources to connect your Dreamweaver pages to a database. Lowery and Ott then provide step-by-step instructions for creating 7 full-featured, professional-quality Web applications suitable for small to medium organizations. Follow the carefully constructed tutorials, and you can use them today—because all the files and code you need are available on the included CD! Better still, the explanations you’ll read will give you insight into why each step was taken so that you can extend any of the recipes to meet individualized needs.

Recipes for the following full-feature applications:

  • User Login

  •  Employee Lookup

  • Conference Room Scheduler

  • In/Out Dashboard

  • Time Cards

  • Journal

  • Mail Merge

  • Table of Contents

    1. Copyright
      1. Dedication
    2. About the Authors
    3. About WebAssist
    4. Acknowledgments
    5. Introduction
      1. Recipes Audience
      2. Recipes Structure
      3. Recipes Resources
      4. Recipes Setup
    6. I. Starters: Fundamental Elements of Web Applications
      1. 1. Basic Principles of Data Source Design
        1. How Web Applications Work
        2. Application Server Technologies Overview
          1. ASP
          2. ASP.NET
          3. ColdFusion
          4. PHP
          5. JSP
        3. Types of Data Sources
        4. Structuring Your Data
        5. Connecting to Data Sources
          1. Making ASP Connections
            1. DSN Connections
            2. Connection Strings
          2. Setting Up ColdFusion Connections
            1. Declaring a Data Source
            2. Setting Up the Application.cfm File
            3. Defining the Data Source Name Variable
          3. Connecting to a MySQL Data Source for PHP
            1. Inserting a Connection
        6. Preparing SQL Statements
          1. SQL Basics
          2. Combining Data from Multiple Tables
      2. 2. Building Applications in Dreamweaver Workspace
        1. Working in the Workspace
          1. Exploring Panels and Panel Groups
          2. Modifying Attributes with the Property Inspector
          3. Adjusting Preferences
          4. Setting Up a New Site
          5. Creating New Dynamic Pages
          6. Binding Data to the Page
          7. Stirring in Server Behaviors
          8. Editing in Live Data View
    7. II. Main Course: Intranet Web Applications
      1. 1. User Login
        1. Ingredients
        2. Prep Work
        3. End User Recipe: User Login
          1. Step 1: Implement User Login Design
          2. Step 2: Apply Server Behavior for User Authentication
          3. Step 3: Insert Error Message
          4. Step 4: Add Session Objects
          5. Step 5: Add Cookie Logic for the User Login Form
          6. Step 6: Create Links to Other Application Pages
        4. End User Recipe: New User Registration
          1. Step 1: Build the Application Design
          2. Step 2: Add Insert Record Server Behavior
            1. For ASP
            2. For ColdFusion and PHP
          3. Step 3: Store New User Info in a Cookie
            1. For ASP and ColdFusion
          4. Step 4: Verify User Name Is Unique
            1. PHP Only
        5. End User Recipe: Personalizing and Protecting Pages
          1. Step 1: Implement the Content Design
          2. Step 2: Add Database Components
          3. Step 3: Display Profile Data
          4. Step 4: Restrict Access to Pages
            1. For ColdFusion
          5. Step 5: Add Link to Update Profile Button
        6. End User Recipe: Conditional Display
          1. Make Elements Conditional
        7. End User Recipe: Editing the User Profile
          1. Step 1: Implement Page Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
            1. For ColdFusion and PHP
          4. Step 4: Update User Profile
            1. For ASP
            2. For ColdFusion and PHP
          5. Step 5: Cancel the Update
        8. End User Recipe: Emailing Passwords
          1. Step 1: Implement Send Password Design
          2. Step 2: Add Database Components
            1. For ASP and PHP
            2. For ColdFusion
          3. Step 3: Insert Confirmation Message
          4. Step 4: Add Logic to Send Email
            1. For ASP
            2. For ColdFusion
            3. For PHP
        9. Administrator Recipe: Managing Users
          1. Step 1: Implement User Manager Design
          2. Step 2: Add Database Components
            1. For ASP and ColdFusion
            2. For PHP
          3. Step 3: Data Binding Process
          4. Step 4: Create a Repeat Region and Application Objects
          5. Step 5: Insert New User Records
            1. For ASP
            2. For ColdFusion and PHP
        10. Administrator Recipe: Modifying User Profiles
          1. Step 1: Implement Edit User Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
          4. Step 4: Update User Profile
            1. For ASP
            2. For ColdFusion and PHP
          5. Step 5: Add a Delete Command
            1. For ASP
            2. For ColdFusion
            3. For PHP
          6. Step 6: Cancel Editing Process
          7. Step 7: Validate the User Name
        11. Administrator Recipe: Viewing User Statistics
          1. Step 1: Implement User Statistics Design
          2. Step 2: Add Database Components
            1. For ASP and ColdFusion
            2. For PHP
          3. Step 3: Display User Statistics
      2. 2. Employee Lookup
        1. Ingredients
        2. Prep Work
        3. End User Recipe: Employee Search
          1. Step 1: Implement Employee Search Design
          2. Step 2: Specify Form Action and Method
        4. End User Recipe: Employee Advanced Search
          1. Step 1: Implement Employee Search Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
          4. Step 4: Specify Form Action and Method
        5. End User Recipe: Employee Results
          1. Step 1: Implement Design
          2. Step 2: Add Database Components
            1. For ASP
            2. For ColdFusion
            3. For PHP
          3. Step 3: Data Binding Process
          4. Step 4: Apply Server Behaviors
          5. Step 5: Adding Application Objects
          6. Step 6: Code Search Functions
            1. For ASP and PHP
            2. For ASP
        6. End User Recipe: Employee Details
          1. Step 1: Implement Employee Detail Design
          2. Step 2: Add Database Components
            1. For PHP
          3. Step 3: Data Binding Process
          4. Step 4: Link to Employee Update Page
        7. End User Recipe: Update Employee
          1. Step 1: Implement Update Employee Design
          2. Step 2: Add Database Components
            1. For ASP
            2. For ColdFusion
            3. For PHP
          3. Step 3: Update Employee Profile
            1. For ASP
            2. For ColdFusion and PHP
            3. For ColdFusion users only
          4. Step 4: Insert Delete Command
            1. For ASP
            2. For ColdFusion
            3. For PHP
          5. Step 5: Data Binding Process
            1. For PHP and ColdFusion Only
        8. Administrator Recipe: New Job
          1. Step 1: Implement New Job Design
          2. Step 2: Add Database Components
            1. For ASP
            2. For ColdFusion
            3. For PHP
          3. Step 3: Data Binding Process
          4. Step 4: Insert Record—New Job
            1. For ASP
            2. For ColdFusion and PHP
          5. Step 5: Error Text: No Job Openings
        9. Administrator Recipe: New Employee
          1. Step 1: Implement Design
          2. Step 2: Add Database Components
            1. For PHP Users
          3. Step 3: Data Binding Process
          4. Step 4: Insert Record—New Employee
            1. For ASP
            2. For ColdFusion and PHP
          5. Step 5: Hand Code—Redirect When No Job Openings
      3. 3. Conference Room Scheduler
        1. Ingredients
        2. Prep Work
        3. End User Recipe: Meeting Request
          1. Step 1: Implement Meeting Request Design
          2. Step 2: Add Database Components, Part 1
            1. For ASP
            2. For ColdFusion
          3. Step 3: Add Database Components, Part 2
            1. For ASP
            2. For ColdFusion
            3. For PHP
          4. Step 4: Data Binding Process
          5. Step 5: Insert Record for Meeting Request
            1. For ASP
            2. For ColdFusion and PHP
          6. Step 6: Add Server-Side Date Validation
            1. For ASP-JS and PHP
            2. For All Server Models
          7. Step 7: Hand-Code Edits to Handle Meeting Conflicts
            1. For ASP
            2. For PHP
          8. Step 8: Hand-Code If Statements for Inserted Recordset
            1. For ASP and ColdFusion
            2. For ASP
            3. For PHP
        4. End User Recipe: Meeting Conflict
          1. Step 1: Implement Meeting Conflict Design
          2. Step 2: Add Database Components
            1. For ASP and ColdFusion
            2. For PHP
          3. Step 3: Data Binding Process
        5. End User Recipe: Meeting Details
          1. Step 1: Implement Meeting Details Design
          2. Step 2: Add Database Components
            1. For ASP and ColdFusion
            2. For PHP
          3. Step 3: Data Binding Process
          4. Step 4: Link to Update Meeting
        6. End User Recipe: Edit Meeting Request
          1. Step 1: Implement Edit Meeting Request Design
            1. For PHP and ColdFusion
          2. Step 2: Add Database Components, Part 1
            1. For ASP
            2. For ColdFusion
            3. For PHP
          3. Step 3: Add Database Components, Part 2
            1. For ASP
            2. For ColdFusion
            3. For PHP
          4. Step 4: Data Binding Process
            1. For PHP and ColdFusion
            2. For All Server Models
          5. Step 5: Update Record for Meeting Request
            1. For ASP
            2. For ColdFusion and PHP
          6. Step 6: Add Server-Side Date Validation
          7. Step 7: Hand-Code Edits to Handle Meeting Conflicts
            1. For ASP
            2. For PHP
            3. Code Order for PHP
        7. End User Recipe: Search for Existing Meeting
          1. Step 1: Implement Search Page Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
          4. Step 4: Add Error Messages
        8. End User Recipe: Meeting Results
          1. Step 1: Implement Search Results Design
          2. Step 2: Add Database Components
            1. For ASP
            2. For ColdFusion
            3. For PHP
          3. Step 3: Data Binding Process
          4. Step 4: Add Repeat Region
          5. Step 5: Add Application Objects
          6. Step 6: Add Server-Side Date Validation
            1. For ASP-JS and PHP
          7. Step 7: Hand-Code Search Functionality
            1. For ASP and PHP
            2. For ASP
            3. For ColdFusion
          8. Step 8: Review Code Order
            1. Code Order for ASP-VB
            2. Code Order for PHP
            3. Code Order for ASP-JS
            4. Code Order for ColdFusion
          9. Step 9: Handle No Matching Results
        9. Administrator Recipe: Add Conference Room
          1. Step 1: Implement Add Room Design
          2. Step 2: Insert Record—New Conference Room
            1. For ASP
            2. For ColdFusion and PHP
        10. Administrator Recipe: Edit Conference Room
          1. Step 1: Implement Design
          2. Step 2: Add Database Components
            1. For ASP
            2. For ColdFusion
            3. For PHP
          3. Step 3: Data Binding Process
          4. Step 4: Update Record—Conference Room
            1. For ASP
            2. For ColdFusion and PHP
          5. Step 5: Hand-Code Room WHERE Clause
      4. 4. In/Out Dashboard
        1. Ingredients
        2. Prep Work
        3. End User Recipe: Dashboard
          1. Step 1: Implement Dashboard Design
          2. Step 2: Add Database Components (First Recordset)
          3. Step 3: Add Database Components (Second Recordset)
            1. For ASP and ColdFusion
            2. For PHP
          4. Step 4: Data Binding Process for Dashboard
          5. Step 5: Link to Employee Update Page
          6. Step 6: Data Binding Process for Announcements
          7. Step 7: Add Repeat Regions
        4. End User Recipe: Update Status
          1. Step 1: Implement Update Status Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
          4. Step 4: Insert Record to Update Status
            1. For ASP
            2. For ColdFusion and PHP
        5. Administrator Recipe: Manage Announcements
          1. Step 1: Implement Manage Announcements Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
            1. For ASP
            2. For ColdFusion and PHP
          4. Step 4: Insert Dynamic Checkbox Options
          5. Step 5: Update Record
        6. Administrator Recipe: Add Announcements
          1. Step 1: Implement Add Announcement Design
          2. Step 2: Insert Record for Announcement
            1. For ASP
            2. For ColdFusion and PHP
          3. Step 3: Server-Side Form Validation
    8. III. Main Course: Workgroup Web Applications
      1. 5. Time Cards
        1. Ingredients
        2. Prep Work
        3. Recipe Overview: Data Source Tables and Queries
        4. Administrator Recipe: Add Job Code
          1. Step 1: Implement the Add Job Code Design
          2. Step 2: Insert Record—Add Job Code
            1. For ASP
            2. For ColdFusion and PHP
        5. Administrator Recipe: Add Project
          1. Step 1: Implement Add Project Design
            1. For PHP
          2. Step 2: Insert Record—Add Project
            1. For ASP
            2. For ColdFusion and PHP
        6. Recipe: Administrator/End-User Recipe: Project Summary
          1. Step 1: Implement Project Summary Design
          2. Step 2: Add Database Components
            1. For PHP
          3. Step 3: Data Binding Process
          4. Step 4: Make Dynamic Links
          5. Step 5: Add Repeat Region Server Behavior
        7. End-User Recipe: Add Time Card
          1. Step 1: Implement Add Time Card Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
          4. Step 4: Apply the Insert Record Server Behavior
            1. For ASP
            2. For ColdFusion and PHP
        8. Administrator Recipe: Hours Breakdown
          1. Step 1: Implement Hours Breakdown Design
            1. For PHP
          2. Step 2: Add Database Components
            1. For PHP
          3. Step 3: Data Binding Process
          4. Step 4: Link to Time Card Details Page
          5. Step 5: Adding Repeat Region
        9. Administrator Recipe: Task Detail
          1. Step 1: Implement Task Detail Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
          4. Step 4: Link to Time Card Update Page
        10. Administrator Recipe: Task Update
          1. Step 1: Implement Task Update Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
            1. For ColdFusion and PHP
          4. Step 4: Add Update Record Server Behavior
            1. For ASP
            2. For ColdFusion and PHP
          5. Step 5: Add Delete Command for Task Update
            1. For ASP
            2. For ColdFusion
            3. For PHP
          6. Step 6: Move and Make Conditional Delete Code
            1. For ASP and ColdFusion
        11. Administrator Recipe: View Time Cards
          1. Step 1: Implement View Time Cards Design
          2. Step 2: Add Database Components
            1. For PHP
          3. Step 3: Data Binding Process
          4. Step 4: Add the Repeat Regions
      2. 6. Journal
        1. Ingredients
        2. Prep Work
        3. Administrator Recipe: Manage Journal
          1. Step 1: Implement Manage Journals Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
          4. Step 4: Add Links to Manage Journals Page
          5. Step 5: Adding Repeat Region
          6. Step 6: Create the Delete Function
            1. For ASP
            2. For ColdFusion
            3. For PHP
          7. Step 7: Complete the Delete Function (For ASP and ColdFusion Users)
            1. For ColdFusion
            2. For ASP
        4. Administrator Recipe: New Journal
          1. Step 1: Implement New Journal Design
          2. Step 2: Insert Record—New Journal
            1. For ASP
            2. For ColdFusion and PHP
        5. Administrator Recipe: Edit Journal
          1. Step 1: Implement Edit Journal Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
            1. For ColdFusion and PHP
          4. Step 4: Update Record—Edit Journal
            1. For ASP
            2. For ColdFusion and PHP
        6. User Recipe: View Journal
          1. Step 1: Implement Journal Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
          4. Step 4: Assigning Dynamic Links
          5. Step 5: Adding Repeat Region
        7. User Recipe: Journal Publisher
          1. Step 1: Implement Journal Publisher Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
            1. For PHP
          4. Step 4: Adding Repeat Region
          5. Step 5: Insert Record—New Journal
            1. For ASP
            2. For ColdFusion and PHP
          6. Step 6: Add Date and Cookie Code
        8. User Recipe: Journal Editor
          1. Step 1: Implement Journal Editor Design
          2. Step 2: Add Database Components
            1. For PHP and ColdFusion
          3. Step 3: Data Binding Process
          4. Step 4: Add Repeat Region
          5. Step 5: Update Record—New Journal
            1. For ASP
            2. For ColdFusion and PHP
          6. Step 6: Add Refresh Code
        9. User Recipe: Journal Archive
          1. Step 1: Implement Journal Archive Design
          2. Step 2: Add Database Components: Part 1
            1. For ASP and ColdFusion
            2. For PHP
          3. Step 3: Add Database Components: Part 2
            1. For ASP
            2. For ColdFusion
            3. For PHP
          4. Step 4: Data Binding Process
          5. Step 5: Bind Data to List
          6. Step 6: Add Repeat Region
          7. Step 7: Move TimePeriods Recordset
          8. Step 8: Establish Variables
          9. Step 9: Add Custom SQL Clause
          10. Step 10: Activate List with JavaScript
            1. For PHP
      3. 7. Mail Merge
        1. Ingredients
        2. Prep Work
        3. End User Recipe: Search Users
          1. Step 1: Implement Search Users Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
          4. Step 4: Set Form Action
          5. Step 5: Insert Custom Code
        4. End User Recipe: Mailing List Results Page
          1. Step 1: Implement Mailing List Design
          2. Step 2: Add Database Components
            1. For ASP
            2. For ColdFusion
            3. For PHP
          3. Step 3: Data Binding Process
          4. Step 4: Add Links
          5. Step 5: Add Repeat Region
        5. End User Recipe: Send Mail
          1. Step 1: Implement Send Email Design
          2. Step 2: Add Database Components
          3. Step 3: Data Binding Process
            1. For ASP
            2. For ColdFusion
            3. For PHP
          4. Step 4: Insert Record: Send Mail
            1. For ASP
            2. For ColdFusion and PHP
          5. Step 5: Add Custom Code
        6. Administrator Recipe: Mailbox
          1. Step 1: Implement Mailbox Design
          2. Step 2: Add Database Component
            1. For PHP
          3. Step 3: Data Binding Process
          4. Step 4: Add Link to Subject Dynamic Text
          5. Step 5: Add Repeat Region
        7. Administrator Recipe: Mail Log
          1. Step 1: Implement Mail Log Design
          2. Step 2: Add Database Components
            1. For PHP
          3. Step 3: Data Binding Process
    9. Recipe Examples