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

Trouble? If a dialog box opens, stating that the site URL prefix for the testing
server does not match the site URL prefix specified in the HTTP address for the
site, your server includes a public_html directory that stores all the content view-
ers can access with a Web browser. However, when visitors view the Web site, the
URL they enter does not include the public_html directory. Therefore, these paths
are different. Click the OK button now and whenever this dialog box appears.

Adding Server Behaviors
Dreamweaver provides a list of prewritten server behaviors in the Server Behaviors panel
after the page is connected to the database. You include these server behaviors in the
page to extend the functionality of the page and to enable you to retrieve and display the
data from the database. You will include two server behaviors in the contact.php page:
Recordset and Insert Record.
The Recordset behavior enables you to specify which data you want to retrieve from
the database and display in the Web page. A recordset is a temporary collection of data
retrieved from a database and stored on the application server that generates the Web
page when that page is loaded in a browser window. You specify the database and the
records (or data) to include in the recordset when you set the parameters for the behav-
ior. A recordset can include all the data in the database or a subset of the data. You must
add the server-side behaviors that will create the recordset in which to store and retrieve
data before you can use a database as a content source for a dynamic Web page. The
server discards the recordset when it is no longer needed.
The Insert Record behavior enables you to specify what will happen to the information
collected from the Web page (in this case, when the form is submitted). You can specify
in which database the data will be placed, where the data will be stored in the database,
what columns will be included, and so on. It also lets you select the page that appears in
the browser window after the form is submitted.
You'll create a recordset for the contact.php page.

To create the recordset for the contact.php page:

◗

1. At the top of the Server Behaviors panel, click the Add behavior button , and

then click Recordset . The Recordset dialog box opens. See Figure 9-8.