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

15. Upload the page to your remote server (include dependent fi les), preview the page
in a browser, and then close the browser.
If the page does not display, Dreamweaver has not added a piece of code that you
need to insert. Open the index.asp page in Code view, scroll to approximately
Line 145, and locate the following code:

<objectƒtype=”application/x-shockwave-fl ash”
data=”FLVPlayer_Progressive.swf”ƒwidth=”222”ƒheight=”201”>

After the opening bracket (and before the word object), type <%%> and then repeat
Step 15.
16. Double-click the Recordset behavior in the Server Behaviors panel to open the
Recordset dialog box, click the Simple button, click the Selected option button in
the Columns section, click comments in the Columns box, and then click the OK
button.
17. Place the pointer below the form area inside the content div, 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 3 , and then
click the OK button. A dynamic table appears below the form in the page.
18. Select the comments text in the top row of the dynamic table and format the text
with the h2 tag.
19. Save the page, upload the index.asp page to your remote server (include dependent
fi les), preview the page in a browser (updating the page and dependent fi les on the
testing server, if necessary), type a test entry in the form, and then click the Submit
button to submit the form. The comment you submitted appears below the form in
the page. ( Hint : If you are sharing a database with classmates, you might see addi-
tional entries in the database. If you do not see your comment, refresh the page.)
20. Submit the fi nished fi les to your instructor.

Case Problem 1

Add database-
driven pages
to display blog
entries in a
Web site for an
independent
skateboard
company.

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

Moebius Skateboards Corey wants to create blog entries that appear in the about page
of the Moebius Skateboards site. The blog entries will help him communicate with users
as well as promote the skateboards he sells and the company's skateboarding team.
You'll create database-driven pages to create a tool that will enable him to do this. As
part of the tool, you will create a form Corey can use to enter blog entries. This form will
use the Spry Validation Textarea widget to ensure that no empty entries are posted to the
site accidentally.

If you are using MySQL and PHP on a Linux server, complete the following steps:

1. Open the Moebius Skateboards site you modifi ed in Tutorial 8.
2. In the Files panel, duplicate the contact.html page, rename the copied page as
blog.php , and then update the links in the fi le.
3. Open the blog.php page in Design view, change the heading text to Blog Entry ,
replace the word “Contact” in the page title with Blog Entry , and then delete the
content from below the heading to the end of the content div, including the form and
form content.
4. Insert a form in the page, enter blogentry as the form name, and then insert a table
with 2 rows, 2 columns, 100 percent table width, 0 border thickness, 3 cell padding,
0 cell spacing, and no header in the form.
5. In the upper-left cell, type blog entry , and then align the text to the Right and Top.