book

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

by Jeffrey Bardzell, Bob Flynn

September 2007

Intermediate to advanced

504 pages

11h 36m

English

Adobe Press

Read now

Unlock full access

Dedication
PrerequisitesOutlineThe Project SiteElements and FormatIf You Get StuckAbout This EditionAdobe Training From The SourceAdobe Authorized Training and CertificationWhat You Will LearnMinimum System Requirements: WindowsMinimum System Requirements: Macintosh
Defining a Static SiteCreating the Contact Us PageFormatting the Contact Us PageAssessing the Site: The CodeAssessing the Site: Business ProcessesA Glimpse of the FutureWhat You Have Learned
Automating Changes with Find and ReplaceRedefining HTML Elements with CSSCreating and Applying Custom CSS StylesCreating a Reusable TemplateEnhancing Accessibility with Invisible NavigationWhat You Have Learned
Dynamic Web Site BasicsChoosing a Server ModelSide by Side with ASP, ColdFusion, and PHP: A Strategy for LearningRedefining the Newland Tours Site for Dynamic DevelopmentDeveloping with a Local ServerSetting Up a Local Environment for IIS/ASPSetting Up a Local Environment for ColdFusionSetting Up a Local Environment for Apache/PHPInstalling Apache, MySQL and PHP for WindowsInstalling Apache, MySQL and PHP for Mac OS XDeveloping with a Remote ServerDefining a Dynamic Site in Dreamweaver (All Users)Building a Simple, Dynamic ApplicationCreating the Input PageCreating the Output PageWhat You Have Learned
Understanding the HTTP ProtocolRetrieving Data from the URLSending Data with HyperlinksSetting and Retrieving CookiesWhat You Have Learned
Introducing SMTP Email ServiceConfiguring Your System to Send SMTP Email MessagesConfiguring IIS to Send Email (ASP Users)Configuring ColdFusion to Send EmailConfiguring PHP to Send EmailWindowsMacintoshWriting the Code to Send a MessageUnderstanding Objects, Methods, and PropertiesCreating the Web FormEmailing Dynamic Form ValuesClient-Side Form ValidationWhat You Have Learned
Creating the PagesBuilding the FormCollecting, Processing, and Displaying the DataAdding Server-Side Form ValidationCreating the Conditional RegionCreating and Applying a Custom CSS ClassWhat You Have Learned

A Crash Course on DatabasesIntroducing Database ObjectsUnderstanding RelationshipsDatabases on the WebDatabase Security and the WebInstalling the Newland Tours Database in MySQLOpening phpMyAdmin in a Local Windows InstallationOpening phpMyAdmin in a Local Macintosh InstallationCreating the Newland Tours Database on a Local ServerCreating and Populating the Newland Tours Database on a Remote ServerTouring the Newland DatabaseConnecting to a DatabaseASP Users (Running IIS Locally or Connecting to a Remote Server)ColdFusion Users (Running ColdFusion Locally or Connecting to a Remote Server)PHP Users (Running PHP/MySQL Locally or on a Remote Server)Retrieving Recordsets and Displaying Database InformationWhat You Have Learned
Dynamically Populated Drop-Down MenusCreating Filtered RecordsetsRevising the Calculation Script With Live DataDocumenting Your Code With CommentsWhat You Have Learned
Passing and Using Data with AjaxExpanding Dreamweaver with ExtensionsTurning a Recordset into XMLConnect Country Profiles page to XML dataBuilding a Spry TableStyling the Spry TableCreating Spry RegionsDisplaying with a Spry AccordionAdding Images and the Country NameLooking Up Foreign Table Data with SQLRefining Page Display Using CSS Styling and PositioningPadding and Positioning the Country TablePadding and Positioning the Accordion PanelsWhat You Have Learned
Planning the ApplicationCreating Recordsets with JoinsBuilding the DescriptionsInserting the Images and alt AttributesImplementing Recordset PagingPassing Data to Other ApplicationsPassing Data to SpryUsing Passed Data to Set a Form ValueWhat You Have Learned
Preparing the Search Page and Creating the Search All LinkSearching by Region: Building the InterfacesRevising the Query and Commenting Code for Testing and DebuggingSuppressing the Navigation BarSearching by Country: Filtering by Form VariableModifying SQL Statements According to Environmental VariablesWhat You Have Learned
User Authentication as a Web ApplicationBuilding the Registration PagesBuilding the Log-in PageCreating Application.cfc (ColdFusion Only)Restricting Access to PagesWhat You Have Learned
Creating the Admin SectionFormatting Content Stored in a DatabaseCreating the Form InterfaceUsing Session Variables and Hidden Fields to Track UsersInserting the RecordWhat You Have Learned
Preparing the PagesPlanning for the Master-Detail PagesMaking the Detail Page UpdateableWhat You Have Learned
Preparing the Content Management SystemBuilding the Form and Hand-Coding a RecordsetAdding the Insert FunctionalityCreating the Master PageCreating the Update Record Detail PageAdding the Update FunctionalityAdding the Delete FunctionalityUpdate the Links on the Admin PageWhere to Go from HereWhat You Have Learned

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

Chapter 11. Building Search Interfaces

<feature><title>What You Will Learn</title>

In this lesson, you will:

Build a dynamic search interface that lets users search and filter data in three different ways

</objective> <objective>

Hand-code several SQL queries using joins, dynamically filtered data, and subqueries

</objective> <objective>

Show or hide the Recordset Navigation Bar, based on need

</objective> <objective>

Apply basic application security

</objective> <objective>

Temporarily disable code using comments for testing and debugging

</objective> <objective>

Use built-in functions to check for the presence of URL and form variables

</objective> <objective>

Use nested if...else blocks to create a sophisticated flow control structure

</objective> ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Macromedia® Dreamweaver® 8 with ASP, Coldfusion® and PHP: Training from the Source

Jeffrey Bardzell

Adobe ColdFusion 9 Web Application Construction Kit, Volume 2: Application Development

Ben Forta

Adobe ColdFusion 8 Web Application Construction Kit, Volume 3: Advanced Application Development

Ben Forta, Charlie Arehart, Jeffrey Bouley, Jeff Tapper, Matt Tatam, Raymond Camden, Robi Sen, Sarge Sargent

CS5.5 Update: Actionscript 3.0 For Adobe Flash Professional CS5 Classroom In A Book

Adobe Creative Team

Publisher Resources

ISBN: 9780321461063Purchase book

Chapter 11. Building Search Interfaces

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

Macromedia® Dreamweaver® 8 with ASP, Coldfusion® and PHP: Training from the Source

Adobe ColdFusion 9 Web Application Construction Kit, Volume 2: Application Development

Adobe ColdFusion 8 Web Application Construction Kit, Volume 3: Advanced Application Development

CS5.5 Update: Actionscript 3.0 For Adobe Flash Professional CS5 Classroom In A Book

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.