visit
Dreamweaver MX 2004 Dynamic Application Development
SOFTWARE (should be installed on client before class)
Coldfusion MX 7 Download Free Trial
selct Coldfusion MX 7 Developer Edition
MS Access (Lesson 8 Touring the Newland Database)
DATABASE
Lessons/Lesson08/Start/newland_tours.mdb
(For ColdFusion standalone web server, copy to C:\CFUSIONMX7\wwwroot\newland
folder. See page 242.)
Dreamweaver MX 2004 PREFERENCES
General
Check - Use strong and em instead of B and I
Use CSS instead of HTML
Accessibility
all unchecked
New Document
Check - Show New Document dialog box on Control-N
Code Hints
On - Enable code hints
On - Enable auto tag completion
CSS Styles
Off - Open CSS file when modified
Invisible Elements
Check - Named Anchors, Hidden Form Fields, Form Delimiter, Visual and Non-Visual
Server markup
View - Code View Options - Line Numbers ON
View - Visual Aids - Invisible Elements ON
LINKS in textbook
http://localhost:8500/cfide/administrator/
http://www.allectomedia.com/newland_dynamic/
http://www.regxlib.com
http://httpd.apache.org
http://www.allectomedia.com/newland_dynamic/tours.cfm
TABLE OF CONTENTS
(click here to open this table in it's own web
page)
| Lesson | Section | Pages | Steps | Files & Tables | Topics |
|---|---|---|---|---|---|
| [(*) = new] | |||||
| Lesson 1: Introducing Newland Tours ( 60 minutes) |
Defining a Static Site | 13-18 | 11 | Dreamweaver as technology/standards savvy authoring tool Dreamweaver Site Adding content Basic formatting Assessing site for problems/improvements |
|
| Creating the Contact Us Page | 18-22 | 9 | contact_text.txt about.htm contact.htm (*) |
||
| Formatting the Contact Us Page | 23-30 | 15 | |||
| Assessing the Site: The Code | 31-37 | 6 | index.htm | ||
| Assessing the Site: Business Processes | 37-43 | 6 | |||
| A Glimpse of the Future | 43-46 | 3 | |||
| Lesson 2: Upgrading to XHTML (90 minutes) |
Upgrading to the XHTML Document Type | 52-59 | 12 | index.htm | Convert Site to XHTML |
| Replacing Strings in Source Code | 59-61 | 7 | |||
| Replacing Tags | 61-63 | 8 | |||
| Stripping Unwanted Tags | 64-65 | 4 | |||
| Closing Empty Tags that have Attributes | 66-69 | 8 | |||
| Finding Images without the Alt Attribute | 69-74 | 12 | about.htm | ||
| Validating your XHTML | 74-76 | 5 | |||
| Lesson 3: Creating the Presentation Layer (75 minutes) |
Redefining HTML Elements with CSS | 80-89 | 14 | index.htm newland.css (*) |
Presentation Concepts Cascading Style Sheet Custom CSS Style Template (generic) |
| Creating and Applying Custom CSS Styles | 89-95 | 11 | |||
| Creating a Reusable Template | 95-97 | 6 | generic_template.htm (*) | ||
| Enhancing Accessibilty with Invisible Navigation | 98-102 | 12 | |||
| Lesson 4: Dynamic Web Sites (60 minutes) |
Dynamic Web Site Basics | 106-109 | - | Concepts of Dynamic Web Sites |
|
| Choosing a Server Model | 109-112 | - | |||
| Redefining the Newland Tours Site for Dynamic Development | 112-113 | - | |||
| Developing with a Local Server | 113-114 | - | |||
| Setting Up a Local Environment for IIS/ASP | 114-115 | 2 | |||
| Setting Up a Local Environment for ColdFusion | 116-118 | 7 | |||
| Setting Up a Local Environment for Apache/PHP | 118-129 | 8 | |||
| Developing with a Remote Server | 129-130 | ||||
| Developing a Dynamic Site in Dreamweaver | 130-135 | 8 | |||
| Building a Simple Dynamic Application | 136-145 | 9 | test_form.cfm (*) test_form_processor.cfm (*) |
||
| Lesson 5: Passing Data Between
Pages (75 minutes) |
Understanding the HTTP Protocol | 149-151 | - | ASP: Request.Querystring Variable CF/PHP: URL Variable Cookies |
|
| Receiving Data from the URL | 151-157 | 12 | test_form.cfm test_form_processor.cfm |
||
| Sending Data with Hyperlinks | 157-162 | 9 | animal_questions.cfm (*) animal_home_page.cfm (*) |
||
| Sending and Receiving Cookies | 162-168 | 11 | |||
| Lesson 6: Sending Mail from
a Web Form (60 minutes) |
Introducing SMTP Email Service | 173-173 | - | Configure to Send SMTP Mail Objects, Methods and Properties ASP: CDO.Message CF: CFMAIL PHP: MAIL Client-side Form Validation |
|
| Configuring Your System to Send SMTP Email Messages | 173-179 | - | |||
| Configuring IIS to Send Email (ASP Users) | 174-175 | 4 | |||
| Configuring ColdFusion to Send Email | 176-177 | 5 | |||
| Writing the Code to Send a Message | 178-178 | 2 | generic_template.cfm messageSent.cfm |
||
| Understanding Objects, Methods and Properties | 178-185 | 7 | |||
| Creating the Web Form | 185-188 | 8 | contact.cfm | ||
| Emailing Dynamic Form Values | 189-191 | 4 | |||
| Client-Side Form Validation | 192-194 | 6 | |||
| Lesson 7: Building a Tour Price
Calculator (120 minutes) |
Creating the Pages | 198-200 | 7 | generic_template.cfm tourprice_processor.cfm (*) tourprice.cfm (*) |
Setting Variables in ASP/CF/PHP Performing Calculation in ASP/CF/PHP Format Currency Server-side Form Validation Custom CSS Class |
| Building the Form | 200-204 | ||||
| Collecting, Processing and Displaying the Data | 204-210 | 8 | |||
| Adding Server-Side Form Validation | 210-214 | 4 | |||
| Creating the Conditional Region | 214-217 | 5 | |||
| Creating and Applying a Custom CSS Class | 217-220 | 6 | |||
| Lesson 8: Databases on the
Web (75 minutes) |
A Crash Course on Databases | 224 | - | Database Concepts |
|
| Introducing Database Objects | 224-227 | - | |||
| Understanding Relationships | 227-229 | - | |||
| Databases on the Web | 229-231 | - | |||
| Database Security and the Web | 231-232 | - | |||
| Installing and Running MySQL | 232-241 | 8+10 | |||
| Touring the Newland Database | 242-246 | 8 | |||
| Connecting to a Database | 246-254 | 9+6+6 | index.cfm | ||
| Retrieving Recordsets and Displaying Database Information | 255-259 | 7 | tbl_journal | ||
| Lesson 9: Completing the Tour
Price Calculator (120 minutes) |
Dynamically Populated Drop-Down Menus | 262-268 | 10 | tourprice.cfm tbl_tours |
Server Behavior: Recordset (Query) Dynamic Menu Dynamic Text |
| Creating Filtered Recordsets | 269-270 | 5 | tourprice_processor.cfm | ||
| Revising the Calculation Script with Live Data | 271-275 | 8 | |||
| Documenting your Code with Comments | 275-279 | 6 | |||
| Lesson 10: Filtering and Displaying
Data (120 minutes) |
Preparing the Input Page | 282-284 | 7 | profiles.cfm tbl_country |
Generate URLs Insert from Bindings Panel, Bind To Server Behavior: Repeat Region Dynamic Image Dynamic Text |
| Generating URLs Dynamically | 284-293 | 13 | |||
| Preparing the Output Page | 294-295 | 4 | generic_template.cfm profiles_detail.cfm (*) tbl_country |
||
| Populating Page Layouts Dynamically | 296-299 | 5 | |||
| Adding Dynamic Images and Formatting the Population Number | 299-305 | 10 | |||
| Looking Up Foreign Table Data with SQL | 306-310 | 6 | tbl_region | ||
| Lesson 11: Building the Tour
Descriptions (120 minutes) |
Planning the Application | 314-316 | 4 | Recordset (Query) Advanced View SQL JOIN using INNER JOIN Server Behavior: Repeat Region Application Objects: Recordset Navigation Bar Dynamic Links |
|
| Creating Recordsets with Joins | 317-321 | 7 | generic_template.cfm tours_detail.cfm (*) tbl_tours |
||
| Building the Descriptions | 322-327 | 9 | |||
| Inserting the Images and alt Attributes | 327-331 | 6 | |||
| Implementing Recordset Paging | 331-336 | 8 | |||
| Passing Data to Other Applications | 337-344 | 13 | tourprice.cfm tourprice_processor.cfm |
||
| Lesson 12: Building Search
Interfaces (150 minutes) |
Preparing the Search Page and Creating the Search All Link | 348-350 | 6 | tours.cfm |
Browse to File with Parameters |
| Searching by Region: Building the Interfaces | 350-356 | 9 | tbl_region index.cfm |
||
| Revising the Query and Commenting Code for Testing and Debugging | 356-361 | 5 | tours_detail.cfm | ||
| Suppressing the Navigation Bar | 362-366 | 9 | |||
| Searching by Country: Filtering by Form Variable | 367-373 | 9 | tbl_country | ||
| Switching SQL Statements According to Environment Variables | 374-378 | 8 | |||
| Lesson 13: Authenticating Users (90 minutes) |
User Authentication as a Web Application | 383-385 | - | Session Variables CF: Application.cfm ASP: global.asa Server Behavior: Insert Record Server Behavior: User Authentication: Check New Username Log In User Restrict Based on Group |
|
| Building the Registration Pages | 385-392 | 12 | generic_template.cfm register.cfm (*) registration_failed.cfm (*) |
||
| Building the Login Page | 393-397 | 9 | generic_template.cfm login.cfm (*) |
||
| Creating Application.cfm (CF) | 397-398 | 3 | |||
| Ensuring Session Management is Enabled (PHP) | 398-401 | 6 | |||
| Restricting Access to Pages | 401-405 | 7 | profiles.cfm index.cfm |
||
| Lesson 14: Managing Content
with Forms (45 minutes) |
Creating the Admin Section | 409-412 | 8 | generic_template.cfm admin_template.cfm (*) admin_index.cfm (*) |
Server Behavior: User Authentication Server Behavior: Insert Record |
| Two Approaches to Formatting Content Stored in a Database | 413-414 | - | |||
| Creating the Form Interface | 414-418 | 7 | admin_update_tj.cfm (*) | ||
| Using Session Variables and Hidden Fields to Track Users | 418-420 | 3 | |||
| Inserting the Record | 420-423 | 3 | tbl_journal | ||
| Lesson 15: Building the Update Pages | Preparing the Pages | 427-428 | 8 | admin_template.cfm admin_addUser_master.cfm (*) admin_addUser_detail.cfm (*) tbl_users |
Server Behavior: Master/Detail Page Set Server Behavior: Update Record |
| Planning for the Master-Detail Pages | 428-437 | 8 | |||
| Making the Detail Page Updateable | 438-446 | 9 |