Adding Database Functionality - New Perspectives on Adobe Dreamweaver CS5, Comprehensive - page 569

13. Save the page, upload the page to your remote server (include dependent fi les), and
then preview the page in a browser.
14. Copy the Recordset behavior in the Server Behaviors panel, and then close the page.
15. Open the coaching.html page in Design view, select ASP VBScript as the document
type in Step 2 in the Server Behaviors panel, update the links in the pages, click the
OK button to confi rm that the contact.asp page could not be updated, paste the
Recordset behavior into the Server Behaviors panel, save the coaching.asp page,
update the Coaching navigation text to link to the coaching.asp page, save the page
again, and then upload the page to your remote server (include dependent fi les).
16. Above the Coaching disclaimer heading, enter an Online Coaching heading, and then
type the following text in the Online Coaching section: Below I have provided some
general information that you may fi nd helpful. Check back frequently for more.
17. Make sure the insertion point is in a blank line below the text in the Online
Coaching section, click the Dynamic Table button in the Dynamic Data list in the
Data category of the Insert panel, click the All records option button, set the border
to 0, set the cell padding to 5, click the OK button, and then delete the fi rst row of
the dynamic table (the row that shows “topic_text”).
18. Save the coaching.asp page, upload the page to your remote server (include depen-
dent fi les), preview the topics.asp page in a browser (update the fi les and dependent
fi les on the testing server, if necessary), type a test entry in the form followed by
your name, and then click the Submit button. The coaching.asp page with the topic
entries appears in the browser. ( Hint : If you are sharing a database with classmates,
you might see additional entries in the database.)
19. Submit the fi nished fi les to your instructor.

Create database-
driven pages
to collect and
display customer
comments in a
Web site for a
coffee lounge.

Case Problem 4

Data File needed for this Case Problem: coffee_db.sql or coffee_db.mdb

Coffee Lounge Tommy wants you to add a form to the Coffee Lounge site that includes
a comments section. After you create the form, you will connect the form to a database
and add code to another page to display the customer comments.

1. Open the Coffee Lounge site you modifi ed in Tutorial 8, and then open the page in
which you will create the form in Design view.
2. Create a form in the page that enables customers to enter comments. The form
should have a text area for comments and a Submit button for submission. ( Hint : Use
a table to create the form structure and use the Spry Validation Textarea widget to
verify that users have entered content into the text area before they submit the form.)
3. If your instructor has not already done so, upload the database on the remote server
using the coffee_db.sql fi le (if you are using MySQL and PHP) or create the database
on your remote server using the coffee_db.mdb fi le (if you are using Access and ASP)
located in the Tutorial.09\Case4 folder included with your Data Files. ( Hint : Obtain
the information you need from your instructor or technical support person.)
4. Connect the Web site to the database by completing Steps 2 and 3 in the Server
Behaviors panel. ( Hint : Remember to update the link on the .php or .asp page.)
5. Add the Recordset and the Insert Record server behaviors to the page.
6. Copy the Recordset server behavior from the page, open the page in which you want
the comments to appear, and then paste the Recordset server behavior in the page.