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

9

TUTORIAL

Adding Database
Functionality
Collecting and Viewing Form Data
in a Database

OBJECTIVES
Session 9.1
• Learn about creating dynamic
database content for Web pages
• Create database-driven pages
using MySQL and PHP for a
Linux server
• Create a database on a remote
Linux server
• Connect a Web site to a
database
• Add server behaviors to
Web pages
• Create pages to view data in a
database
• Create a login page

Case | NextBest Fest

Gage thinks the NextBest Fest site could benefi t from the collection
of some user data. He thinks it would be helpful to collect the data
that is received from users who complete and submit the form in
the contact.html page. You will create a database to store the infor-
mation collected from the form and connect the form in the contact
page to the database. You will also create pages that enable you to
view the data collected in the database. Finally, you will create a
login page and connect the pages that display collected database
information to the login page so that users must have a valid login
and password to view the data.

Session 9.2
• Create database-driven pages
using Access and ASP for a
Windows server
• Upload a database to a remote
Windows server
• Connect a Web site to a
database
• Add server behaviors to
Web pages
• Create pages to view data in a
database
• Create a login page

STARTING DATA FILES

Tutorial.09

Tutorial Review Case1 Case2 Case3 Case4

nbf_db.mdb
nbf_db.sql

anti_db.mdb
anti_db.sql

moeb_db.mdb
moeb_db.sql

cowboy_db.mdb
cowboy_db.sql

tess_db.mdb
tess_db.sql

coffee_db.mdb
coffee_db.sql

DMR 503