Macromedia Dreamweaver 8 Recipes : ASP VBScript, ASP JavaScript, ColdFusion, PHP

by Lowery, Joseph; Ott, Eric

• ISBN13: 9780321393913
• ISBN10: 0321393910
• Edition: 1st
• Format: Paperback w/CD
• Copyright: 2006-01-01
• Publisher: Macromedia Press

Summary

Ready to make the leap from static to dynamic sites? Learn how to create sophisticated data-driven applications by following step-by-step instructions to build seven full-featured, professional-quality Web applications suitable for small to medium organizations. You'll get insight into why each step was taken so that you can extend any of the recipes to meet your individualized needs.

Table of Contents

Introduction	xix
Part I: Starters: Fundamental Elements of Web Applications	1	(44)
Basic Principles of Data Source Design	3	(22)
How Web Applications Work	4	(1)
Application Server Technologies Overview	5	(3)
ASP	5	(1)
ASP.NET	6	(1)
ColdFusion	7	(1)
PHP	7	(1)
JSP	8	(1)
Types of Data Sources	8	(2)
Structuring Your Data	10	(2)
Connecting to Data Sources	12	(9)
Making ASP Connections	13	(1)
DSN Connections	13	(2)
Connection Strings	15	(1)
Setting Up ColdFusion Connections	16	(1)
Declaring a Data Source	17	(1)
Setting Up the Application.cfm File	17	(1)
Defining the Data Source Name Variable	18	(1)
Connecting to a MySQL Data Source for PHP	19	(1)
Inserting a Connection	19	(2)
Preparing SQL Statements	21	(4)
SQL Basics	22	(1)
Combining Data from Multiple Tables	23	(2)
Building Applications in Dreamweaver Workspace	25	(20)
Working in the Workspace	25	(20)
Exploring Panels and Panel Groups	27	(2)
Modifying Attributes with the Property Inspector	29	(1)
Adjusting Preferences	30	(3)
Setting Up a New Site	33	(3)
Creating New Dynamic Pages	36	(2)
Binding Data to the Page	38	(2)
Stirring in Server Behaviors	40	(2)
Editing in Live Data View	42	(3)
Part II: Main Course: Intranet Web Applications	45	(270)
User Login	47	(72)
Ingredients	49	(1)
Prep Work	49	(1)
End User Recipe: User Login	50	(11)
Step 1: Implement User Login Design	50	(1)
Step 2: Apply Server Behavior for User Authentication	51	(3)
Step 3: Insert Error Message	54	(1)
Step 4: Add Session Objects	54	(3)
Step 5: Add Cookie Logic for the User Login Form	57	(3)
Step 6: Create Links to Other Application Pages	60	(1)
End User Recipe: New User Registration	61	(8)
Step 1: Build the Application Design	61	(1)
Step 2: Add Insert Record Server Behavior	62	(1)
For ASP	63	(1)
For ColdFusion and PHP	64	(1)
Step 3: Store New User Info in a Cookie	64	(1)
For ASP and ColdFusion	65	(1)
Step 4: Verify User Name Is Unique	66	(2)
PHP Only	68	(1)
End User Recipe: Personalizing and Protecting Pages	69	(6)
Step 1: Implement the Content Design	69	(1)
Step 2: Add Database Components	70	(2)
Step 3: Display Profile Data	72	(1)
Step 4: Restrict Access to Pages	72	(2)
For ColdFusion	74	(1)
Step 5: Add Link to Update Profile Button	74	(1)
End User Recipe: Conditional Display	75	(2)
Make Elements Conditional	75	(2)
End User Recipe: Editing the User Profile	77	(6)
Step 1: Implement Page Design	77	(1)
Step 2: Add Database Components	78	(1)
Step 3: Data Binding Process	79	(1)
For ColdFusion and PHP	79	(1)
Step 4: Update User Profile	80	(1)
For ASP	81	(1)
For ColdFusion and PHP	81	(1)
Step 5: Cancel the Update	82	(1)
End User Recipe: Emailing Passwords	83	(7)
Step 1: Implement Send Password Design	84	(1)
Step 2: Add Database Components	84	(1)
For ASP and PHP	85	(1)
For ColdFusion	85	(1)
Step 3: Insert Confirmation Message	86	(1)
Step 4: Add Logic to Send Email	87	(1)
For ASP	87	(2)
For ColdFusion	89	(1)
For PHP	90	(1)
Administrator Recipe: Managing Users	90	(10)
Step 1: Implement User Manager Design	90	(2)
Step 2: Add Database Components	92	(1)
For ASP and ColdFusion	93	(1)
For PHP	93	(1)
Step 3: Data Binding Process	94	(2)
Step 4: Create a Repeat Region and Application Objects	96	(3)
Step 5: Insert New User Records	99	(1)
For ASP	99	(1)
For ColdFusion and PHP	99	(1)
Administrator Recipe: Modifying User Profiles	100	(15)
Step 1: Implement Edit User Design	100	(1)
Step 2: Add Database Components	101	(1)
Step 3: Data Binding Process	102	(2)
Step 4: Update User Profile	104	(1)
For ASP	104	(1)
For ColdFusion and PHP	105	(1)
Step 5: Add a Delete Command	105	(1)
For ASP	106	(2)
For ColdFusion	108	(1)
For PHP	109	(1)
Step 6: Cancel Editing Process	110	(1)
Step 7: Validate the User Name	110	(5)
Administrator Recipe: Viewing User Statistics	115	(4)
Step 1: Implement User Statistics Design	115	(1)
Step 2: Add Database Components	116	(1)
For ASP and ColdFusion	116	(1)
For PHP	117	(1)
Step 3: Display User Statistics	117	(2)
Employee Lookup	119	(62)
Ingredients	120	(1)
Prep Work	121	(1)
End User Recipe: Employee Search	122	(1)
Step 1: Implement Employee Search Design	122	(1)
Step 2: Specify Form Action and Method	123	(1)
End User Recipe: Employee Advanced Search	123	(4)
Step 1: Implement Employee Search Design	124	(1)
Step 2: Add Database Components	125	(1)
Step 3: Data Binding Process	126	(1)
Step 4: Specify Form Action and Method	127	(1)
End User Recipe: Employee Results	127	(19)
Step 1: Implement Design	127	(1)
Step 2: Add Database Components	128	(1)
For ASP	129	(1)
For ColdFusion	130	(1)
For PHP	130	(2)
Step 3: Data Binding Process	132	(1)
Step 4: Apply Server Behaviors	133	(1)
Step 5: Adding Application Objects	134	(2)
Step 6: Code Search Functions	136	(1)
For ASP and PHP	136	(7)
For ASP	143	(3)
End User Recipe: Employee Details	146	(5)
Step 1: Implement Employee Detail Design	146	(1)
Step 2: Add Database Components	147	(2)
For PHP	149	(1)
Step 3: Data Binding Process	150	(1)
Step 4: Link to Employee Update Page	151	(1)
End User Recipe: Update Employee	151	(13)
Step 1: Implement Update Employee Design	151	(1)
Step 2: Add Database Components	152	(2)
For ASP	154	(1)
For ColdFusion	154	(1)
For PHP	155	(2)
Step 3: Update Employee Profile	157	(1)
For ASP	157	(1)
For ColdFusion and PHP	158	(1)
For ColdFusion users only	158	(1)
Step 4: Insert Delete Command	159	(1)
For ASP	159	(2)
For ColdFusion	161	(1)
For PHP	162	(1)
Step 5: Data Binding Process	163	(1)
For PHP and ColdFusion Only	164	(1)
Administrator Recipe: New Job	164	(9)
Step 1: Implement New Job Design	165	(1)
Step 2: Add Database Components	166	(1)
For ASP	167	(1)
For ColdFusion	167	(1)
For PHP	168	(1)
Step 3: Data Binding Process	169	(2)
Step 4: Insert Record---New Job	171	(1)
For ASP	171	(1)
For ColdFusion and PHP	172	(1)
Step 5: Error Text: No Job Openings	172	(1)
Administrator Recipe: New Employee	173	(8)
Step 1: Implement Design	174	(1)
Step 2: Add Database Components	174	(1)
For PHP Users	175	(1)
Step 3: Data Binding Process	176	(1)
Step 4: Insert Record---New Employee	177	(1)
For ASP	177	(1)
For ColdFusion and PHP	178	(1)
Step 5: Hand Code---Redirect When No Job Openings	179	(2)
Conference Room Scheduler	181	(98)
Ingredients	182	(1)
Prep Work	183	(1)
End User Recipe: Meeting Request	183	(28)
Step 1: Implement Meeting Request Design	184	(1)
Step 2: Add Database Components, Part 1	185	(1)
For ASP	186	(1)
For ColdFusion	187	(1)
Step 3: Add Database Components, Part 2	187	(1)
For ASP	188	(1)
For ColdFusion	189	(1)
For PHP	190	(1)
Step 4: Data Binding Process	191	(2)
Step 5: Insert Record for Meeting Request	193	(1)
For ASP	194	(1)
For ColdFusion and PHP	195	(1)
Step 6: Add Server-Side Date Validation	196	(1)
For ASP-JS and PHP	196	(1)
For All Server Models	197	(2)
Step 7: Hand-Code Edits to Handle Meeting Conflicts	199	(5)
For ASP	204	(1)
For PHP	205	(1)
Step 8: Hand-Code If Statements for Inserted Recordset	206	(1)
For ASP and ColdFusion	206	(3)
For ASP	209	(1)
For PHP	210	(1)
End User Recipe: Meeting Conflict	211	(4)
Step 1: Implement Meeting Conflict Design	211	(1)
Step 2: Add Database Components	212	(1)
For ASP and ColdFusion	213	(1)
For PHP	213	(1)
Step 3: Data Binding Process	214	(1)
End User Recipe: Meeting Details	215	(5)
Step 1: Implement Meeting Details Design	216	(1)
Step 2: Add Database Components	217	(1)
For ASP and ColdFusion	217	(1)
For PHP	217	(1)
Step 3: Data Binding Process	218	(1)
Step 4: Link to Update Meeting	219	(1)
End User Recipe: Edit Meeting Request	220	(27)
Step 1: Implement Edit Meeting Request Design	220	(1)
For PHP and ColdFusion	221	(1)
Step 2: Add Database Components, Part 1	221	(1)
For ASP	222	(1)
For ColdFusion	223	(1)
For PHP	223	(2)
Step 3: Add Database Components, Part 2	225	(1)
For ASP	225	(1)
For ColdFusion	226	(2)
For PHP	228	(1)
Step 4: Data Binding Process	229	(1)
For PHP and ColdFusion	230	(1)
For All Server Models	231	(2)
Step 5: Update Record for Meeting Request	233	(1)
For ASP	233	(1)
For ColdFusion and PHP	234	(1)
Step 6: Add Server-Side Date Validation	235	(3)
Step 7: Hand-Code Edits to Handle Meeting Conflicts	238	(6)
For ASP	244	(1)
For PHP	245	(2)
Code Order for PHP	247	(1)
End User Recipe: Search for Existing Meeting	247	(5)
Step 1: Implement Search Page Design	248	(1)
Step 2: Add Database Components	248	(1)
Step 3: Data Binding Process	249	(1)
Step 4: Add Error Messages	250	(2)
End User Recipe: Meeting Results	252	(17)
Step 1: Implement Search Results Design	252	(1)
Step 2: Add Database Components	253	(1)
For ASP	253	(1)
For ColdFusion	254	(1)
For PHP	254	(1)
Step 3: Data Binding Process	255	(1)
Step 4: Add Repeat Region	256	(1)
Step 5: Add Application Objects	257	(2)
Step 6: Add Server-Side Date Validation	259	(1)
For ASP-JS and PHP	259	(2)
Step 7: Hand-Code Search Functionality	261	(1)
For ASP and PHP	261	(2)
For ASP	263	(2)
For ColdFusion	265	(1)
Step 8: Review Code Order	266	(1)
Code Order for ASP-VB	266	(1)
Code Order for PHP	266	(1)
Code Order for ASP-JS	267	(1)
Code Order for ColdFusion	267	(1)
Step 9: Handle No Matching Results	267	(2)
Administrator Recipe: Add Conference Room	269	(2)
Step 1: Implement Add Room Design	269	(1)
Step 2: Insert Record---New Conference Room	270	(1)
For ASP	270	(1)
For ColdFusion and PHP	270	(1)
Administrator Recipe: Edit Conference Room	271	(8)
Step 1: Implement Design	271	(1)
Step 2: Add Database Components	272	(1)
For ASP	273	(1)
For ColdFusion	273	(1)
For PHP	273	(1)
Step 3: Data Binding Process	274	(2)
Step 4: Update Record---Conference Room	276	(1)
For ASP	276	(1)
For ColdFusion and PHP	276	(1)
Step 5: Hand-Code Room Where Clause	277	(2)
In/Out Dashboard	279	(36)
Ingredients	280	(1)
Prep Work	281	(1)
End User Recipe: Dashboard	281	(13)
Step 1: Implement Dashboard Design	281	(1)
Step 2: Add Database Components (First Recordset)	282	(2)
Step 3: Add Database Components (Second Recordset)	284	(1)
For ASP and ColdFusion	284	(1)
For PHP	285	(2)
Step 4: Data Binding Process for Dashboard	287	(5)
Step 5: Link to Employee Update Page	292	(1)
Step 6: Data Binding Process for Announcements	292	(1)
Step 7: Add Repeat Regions	292	(2)
End User Recipe: Update Status	294	(5)
Step 1: Implement Update Status Design	294	(1)
Step 2: Add Database Components	295	(1)
Step 3: Data Binding Process	296	(2)
Step 4: Insert Record to Update Status	298	(1)
For ASP	298	(1)
For ColdFusion and PHP	299	(1)
Administrator Recipe: Manage Announcements	299	(9)
Step 1: Implement Manage Announcements Design	300	(1)
Step 2: Add Database Components	300	(1)
Step 3: Data Binding Process	301	(1)
For ASP	302	(1)
For ColdFusion and PHP	302	(1)
Step 4: Insert Dynamic Checkbox Options	303	(2)
Step 5: Update Record	305	(3)
Administrator Recipe: Add Announcements	308	(7)
Step 1: Implement Add Announcement Design	308	(1)
Step 2: Insert Record for Announcement	309	(1)
For ASP	309	(1)
For ColdFusion and PHP	310	(1)
Step 3: Server-Side Form Validation	311	(4)
Part III Main Course: Workgroup Web Applications	315	(164)
Time Cards	317	(54)
Ingredients	318	(1)
Prep Work	319	(1)
Recipe Overview: Data Source Tables and Queries	319	(4)
Administrator Recipe: Add Job Code	323	(2)
Step 1: Implement the Add Job Code Design	323	(1)
Step 2: Insert Record---Add Job Code	324	(1)
For ASP	324	(1)
For ColdFusion and PHP	325	(1)
Administrator Recipe: Add Project	325	(3)
Step 1: Implement Add Project Design	326	(1)
For PHP	327	(1)
Step 2: Insert Record---Add Project	327	(1)
For ASP	327	(1)
For ColdFusion and PHP	328	(1)
Recipe: Administrator/End-User Recipe: Project Summary	328	(7)
Step 1: Implement Project Summary Design	329	(1)
Step 2: Add Database Components	329	(1)
For PHP	330	(2)
Step 3: Data Binding Process	332	(1)
Step 4: Make Dynamic Links	332	(1)
Step 5: Add Repeat Region Server Behavior	333	(2)
End-User Recipe: Add Time Card	335	(6)
Step 1: Implement Add Time Card Design	336	(1)
Step 2: Add Database Components	337	(1)
Step 3: Data Binding Process	338	(2)
Step 4: Apply the Insert Record Server Behavior	340	(1)
For ColdFusion and PHP	340	(1)
Administrator Recipe: Hours Breakdown	341	(7)
Step 1: Implement Hours Breakdown Design	341	(2)
For PHP	343	(1)
Step 2: Add Database Components	343	(2)
For PHP	345	(1)
Step 3: Data Binding Process	346	(1)
Step 4: Link to Time Card Details Page	346	(1)
Step 5: Adding Repeat Region	347	(1)
Administrator Recipe: Task Detail	348	(5)
Step 1: Implement Task Detail Design	348	(1)
Step 2: Add Database Components	349	(2)
Step 3: Data Binding Process	351	(1)
Step 4: Link to Time Card Update Page	352	(1)
Administrator Recipe: Task Update	353	(9)
Step 1: Implement Task Update Design	353	(1)
Step 2: Add Database Components	353	(2)
Step 3: Data Binding Process	355	(1)
For ColdFusion and PHP	356	(1)
Step 4: Add Update Record Server Behavior	357	(1)
For ASP	357	(1)
For ColdFusion and PHP	358	(1)
Step 5: Add Delete Command for Task Update	358	(1)
For ASP	359	(1)
For ColdFusion	359	(1)
For PHP	359	(1)
Step 6: Move and Make Conditional Delete Code	360	(1)
For ASP and ColdFusion	360	(2)
Administrator Recipe: View Time Cards	362	(9)
Step 1: Implement View Time Cards Design	362	(2)
Step 2: Add Database Components	364	(2)
For PHP	366	(2)
Step 3: Data Binding Process	368	(1)
Step 4: Add the Repeat Regions	369	(2)
Journal	371	(68)
Ingredients	372	(1)
Prep Work	373	(1)
Administrator Recipe: Manage Journal	373	(12)
Step 1: Implement Manage Journals Design	374	(1)
Step 2: Add Database Components	375	(1)
Step 3: Data Binding Process	376	(1)
Step 4: Add Links to Manage Journals Page	376	(2)
Step 5: Adding Repeat Region	378	(1)
Step 6: Create the Delete Function	379	(1)
For ASP	380	(1)
For ColdFusion	381	(1)
For PHP	381	(1)
Step 7: Complete the Delete Function	382	(2)
For ColdFusion	384	(1)
For ASP	384	(1)
Administrator Recipe: New Journal	385	(3)
Step 1: Implement New Journal Design	385	(1)
Step 2: Insert Record---New Journal	386	(1)
For ASP	386	(1)
For ColdFusion and PHP	387	(1)
Administrator Recipe: Edit Journal	388	(4)
Step 1: Implement Edit Journal Design	388	(1)
Step 2: Add Database Components	389	(1)
Step 3: Data Binding Process	390	(1)
For ColdFusion and PHP	391	(1)
Step 4: Update Record---Edit Journal	391	(1)
For ASP	391	(1)
For ColdFusion and PHP	392	(1)
User Recipe: View Journal	392	(6)
Step 1: Implement Journal Design	393	(1)
Step 2: Add Database Components	394	(1)
Step 3: Data Binding Process	395	(1)
Step 4: Assigning Dynamic Links	396	(1)
Step 5: Adding Repeat Region	397	(1)
User Recipe: Journal Publisher	398	(11)
Step 1: Implement Journal Publisher Design	399	(1)
Step 2: Add Database Components	400	(1)
Step 3: Data Binding Process	401	(1)
For PHP	402	(1)
Step 4: Adding Repeat Region	402	(1)
Step 5: Insert Record---New Journal	403	(1)
For ASP	403	(1)
For ColdFusion and PHP	404	(1)
Step 6: Add Date and Cookie Code	405	(4)
User Recipe: Journal Editor	409	(8)
Step 1: Implement Journal Editor Design	409	(1)
Step 2: Add Database Components	410	(2)
For PHP and ColdFusion	412	(1)
Step 3: Data Binding Process	412	(3)
Step 4: Add Repeat Region	415	(1)
Step 5: Update Record---New Journal	415	(1)
For ASP	415	(1)
For ColdFusion and PHP	416	(1)
Step 6: Add Refresh Code	416	(1)
User Recipe: Journal Archive	417	(22)
Step 1: Implement Journal Archive Design	418	(1)
Step 2: Add Database Components: Part 1	419	(1)
For ASP and ColdFusion	419	(1)
For PHP	420	(2)
Step 3: Add Database Components: Part 2	422	(1)
For ASP	422	(1)
For ColdFusion	423	(1)
For PHP	424	(1)
Step 4: Data Binding Process	425	(2)
Step 5: Bind Data to List	427	(2)
Step 6: Add Repeat Region	429	(1)
Step 7: Move TimePeriods Recordset	429	(3)
Step 8: Establish Variables	432	(2)
Step 9: Add Custom SQL Clause	434	(3)
Step 10: Activate List with JavaScript	437	(1)
For PHP	437	(2)
Mail Merge	439	(40)
Ingredients	440	(1)
Prep Work	441	(1)
End User Recipe: Search Users	441	(6)
Step 1: Implement Search Users Design	442	(1)
Step 2: Add Database Components	443	(1)
Step 3: Data Binding Process	444	(1)
Step 4: Set Form Action	445	(1)
Step 5: Insert Custom Code	445	(2)
End User Recipe: Mailing List Results Page	447	(9)
Step 1: Implement Mailing List Design	448	(1)
Step 2: Add Database Components	449	(1)
For ASP	449	(2)
For ColdFusion	451	(1)
For PHP	452	(1)
Step 3: Data Binding Process	453	(1)
Step 4: Add Links	454	(1)
Step 5: Add Repeat Region	455	(1)
End User Recipe: Send Mail	456	(13)
Step 1: Implement Send Email Design	456	(2)
Step 2: Add Database Components	458	(1)
Step 3: Data Binding Process	459	(1)
For ASP	460	(1)
For ColdFusion	460	(1)
For PHP	460	(1)
Step 4: Insert Record: Send Mail	460	(1)
For ASP	461	(1)
For ColdFusion and PHP	461	(1)
Step 5: Add Custom Code	462	(7)
Administrator Recipe: Mailbox	469	(5)
Step 1: Implement Mailbox Design	469	(1)
Step 2: Add Database Component	469	(2)
For PHP	471	(1)
Step 3: Data Binding Process	471	(1)
Step 4: Add Link to Subject Dynamic Text	472	(1)
Step 5: Add Repeat Region	473	(1)
Administrator Recipe: Mail Log	474	(5)
Step 1: Implement Mail Log Design	474	(1)
Step 2: Add Database Components	475	(1)
For PHP	475	(1)
Step 3: Data Binding Process	476	(3)
Index	479