Dreamweaver has the ability to add PHP or ASP code to your pages that lets them communicate with a database. Dreamweaver code can display dynamic data from the database on a Web page. It can also use forms to add data to the database or to update the data that is already there. Dreamweaver can also create login pages that restrict access to administrative pages. A Web designer can use Dreamweaver to create dynamic pages by completing simple dialog boxes. It's not necessary to know how to write the code.

Knowing how to use the dynamic functions of Dreamweaver opens up an whole new realm of possibilities in Web design. You can display a product catalog with list and display pages, and provide a backend for the site owners to update the product information themselves. Using data driven Web pages can save a countless hours in the creation and maintenance of a Web site. For instance, you could have a site on golf courses in Southern California. If you were building a static site, the site would would have hundreds of pages. If there were 400 courses, you would need a information page for each one, and also several list pages that listed courses in different areas. However, if you build this site with a database, you would have a home page, where the visitor could select the area he wanted to know about. A list page that listed golf courses in the chosen area, and page that listed the details about the particular course the visitor chose on the list page. That's 3 pages, instead of over 400.

You can do other things with databases, as well. You can create forms for Web visitors to fill out. They can RSVP to event invitations and choose their meal preference or T-Shirt size. They can add items to their wish lists or vote on an important issue. The possibilities are endless. Once you see how easy this is to do, you'll be finding ways to use it in almost every site you build.

Applicable Job Roles: Web designers who don't know how to hand code server side languages that communicate with databases will be able to add to their Web design skills.

• How Dynamic Sites Work
• Choosing a Server Model and Host
• Setting Up the Site in Dreamweaver
• Forms Review

• Passing Data from Page to Page
• Intro to Database Basics
• Preparing the Database

• Connecting to the Database
• Retrieving Information from the Database
• Displaying Data on the Page
• Master-Detail Pages
• Recordset Navigation

• Forms that Add Data to a Database

• Forms that Update Data Already in the Database
• Dynamic Form Fields
• Deleting Data from the Database

• Password Protecting Web Pages
• Login Pages
• Logout Function