Chapter 12. Creating Pages for Editing Records


12. Creating Pages for Editing Records

Editing database records involves inserting new records and updating or deleting existing ones. You can edit database records in the application you used to create the database, such as Microsoft Access or MySQL, or you can create dynamic Web pages from which to edit them. Using a Web page for editing database records has two main advantages: You don't need to have the database application installed on your computer, and you or other users don't need to know how to use the database application to edit records.

In this chapter, you'll learn the following:

  • Two ways to insert new records: by adding a form and an Insert Record server behavior to a Web page, or by adding a Record Insertion Form Wizard application object.

  • How to create a set of pages for updating a record, including a master page and an update page. The master page contains a dynamic table with links and URL parameters for selecting a specific record. The update page contains a form for updating records, and is created by adding a form and the Update Record server behavior, or by inserting a Record Update Form Wizard application object.

  • How to create a set of pages for deleting a record, including a master page for selecting a record to delete and a delete page. The delete page contains a form and a Delete Record server behavior. (Dreamweaver doesn't include an application object for deleting records.)

We'll use PHP and the MySQL travelclub database that we created in Chapter 5 for the tasks in this chapter. However, the process of creating pages for editing database records is the same for PHP, ColdFusion, and ASP.




Macromedia Dreamweaver 8 Advanced for Windows and Macintosh. Visual Quickpro Guide
Macromedia Dreamweaver 8 Advanced for Windows and Macintosh: Visual QuickPro Guide
ISBN: 0321384024
EAN: 2147483647
Year: 2004
Pages: 129
Authors: Lucinda Dykes

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net