Introduction to ColdFusion

• Static Client/Server Model on the web
• Dynamic Client/Server Model using ColdFusion

Web-to-Database Integration

• JDBC data sources, drivers, and SQL
• ODBC data source names (DSNs)
• ColdFusion Web to Database Integration Model

Writing ColdFusion Code

• ColdFusion templates
• Using HomeSite+ vs. Using Dreamweaver
• Writing HTML tags and executing files in a browser

Date and Time Functions and Formats

Working with Variables

• Setting variables with <cfset>
• Displaying variable values with <cfoutput>

Passing Variables Between Pages

• Passing variables via links or via forms
• Distinguishing among variable types

Building Forms with Homesite+

Conditionals in ColdFusion

• <cfif> and <cfelse> conditionals
• ColdFusion conditional operators
• Using <cfif> and <cfelse> to perform form validation
• <cfabort> and form validation
• Adding <cfelseif> blocks to a condititonal
• Self-submitting forms

An Introduction to SQL

• Database concepts and SQL syntax
• Issuing database commands with SQL
• Retrieving information with SELECT
• INSERT, UPDATE and DELETE

Querying a Database

• <cfquery> and <cfoutput> tags
• Distinguishing query variables
• Counting records with queryname.recordcount

Displaying Query Records in Table Format

• Creating HTML tables manually
• Creating HTML tables with the <cftable> tag

Dynamically Populating Select Lists

• Dynamically populating a select list via <cfoutput>
• Auto-populating select lists with <cfselect>

Creating a Search Interface

• Using the LIKE clause
• Using % and _ in a LIKE statement
• Building dynamic SQL statements

Implementing Basic Data Drill-Downs

• Explanation of drill-down code
• Passing variables between pages
• Passing variables via links

The <cfqueryparam> Tag

• Protection against SQL injection attacks

Inserting Records into the Database

• Inserting a record into a database table
• Inserting a work of art into the artworks table
• Hidden fields to pass data in a form submission
• The <cfinsert> tag

The <cflocation> Tag

• Redirecting the user
• Where and how <cflocation> is used
• isdefined() function

The <cfinclude> Tag

• What are server-side includes?
• ColdFusion options for include files

Client-Side & Server-Side Form Validation

Editing Records in the Database

• Building an editing application to edit works of art
• Using the <input> tag's value attribute
• UPDATE page and <cfupdate> tag
• Passing the primary key
• "Deleting" without deleting

Generating Email Messages with <cfmail>

Output Shortcuts

• The <cfdump> tag

Encapsulating Data Using Sessions

• The Basics of encapsulation
• Encapsulating session data
• Encapsulating a component within a session
• Outline of a component
• Accessing a component in session scope
• Removing the component from the session
• Advantages of encapsulation

ColdFusion Administrator Configuration

• Accessing the administrator to set up data sources
• Setting the mail server connection

ColdFusion Variable Types

Working with Cookies

• What is a cookie?
• Why do some consider cookies bad?
• Implementation characteristics set by user agent

Working with Sessions

• What is a session?
• When does the session end?
• Configuring and enabling session variables
• Enabling session variables in your application
• Storing session data in session variables
• Standard session variables
• Getting a list of session variables
• Creating and deleting session variables
• Life cycle of a ColdFusion template
• Uses for application.cfm
• Session and application variables
• Required CFAPPLICATION tag
• Locking session/application variables with CFLOCK
• Password protection with sessions

Debugging Advice

Web Application Technologies and PHP

• Client-Side vs. Server-Side Web Technologies
• The Web's Client-Server Relationship
• Which Web Servers Support PHP?

Writing PHP Pages

• PHP Code In HTML vs Server Context
• PHP Syntax, Expressions and Statements
• Working with Text and Strings in PHP
• What PHP Can Do and Should be Used For
• Branching with Conditional Constructs”
• Arithmetic and Comparison Operators in PHP
• Combining Logical Statements and Precedence
• Adding a Greeting, Date and Time to a Web Page

Processing Data from Online Forms

• How Forms Are Processed on the Web
• Data Variables and Scalars in PHP
• Displaying a Customized Greeting
• Client and Server Code in a Web Form
• Personalizing Your Homepage

Working with Cookies in PHP

• The Lack of Persistence and State in http
• About Cookies and Their Role in Web Applications
• Setting, Retrieving, and Expiring a Cookie
• Enhancing Your Home Page With Cookies

Maintaining State with Sessions

• Session and Application State Support in Web Apps
• Storing and Retrieving Session Values
• Using the Session Object to Track a Shopping Cart
• Building a Shopping Cart for Your Web Site

Generating Email with PHP

• Writing Server Code to Send Email in PHP
• Implementing CDONTS Email on Your Web Site

Interfacing with the Server File System

• Creating and Writing to a Tab-Delimited Text File
• Reading Data From a Tab-Delimited Text File
• Storing Registrations in a Text File on Your Site

Iteration Structures in PHP

• For Loops, Foreach Loops and While Loops
• Looping Structures and Arrays
• Looping to Read and Present Data from a File

Database Integration with PHP

• Databases and the Web
• Database Connections and SQL Commands
• Connecting to a Database in PHP
• Issuing SQL Commands in PHP
• Using User Supplied Values in a Database Query
• Building a Search Engine Interface
• Enhance the Registration System to a Database

Functions and Regular Expressions

• Creating User Defined Functions
• Using Functions to Validate Form Data
• Pattern Matching with RegEx in PHP
• Validating Form Data with Regular Expressions

Creating a Drill Down Query

• Passing and Acceptiong Parameters in the URL
• Generating Drill Down Links with Dynamic Data

Installing PHP and MySQL