• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

5. Maintaining Database Records > 5.2. Updating Existing Records

Updating Existing Records

Updating a database record is a three-step process that involves a bit more work that just inserting a new record. The first step in the process is to identify the record to be updated; there are two ways to handle this task. Next, an HTML form containing the editable fields needs to be created. This form must be prepopulated with the data from the record to be edited. Finally, you need another template to take the updated form-field data and update the appropriate record in the database.

Choosing a Record to Update

Before you can make an update to a record, you need some sort of interface that allows you to choose the record you wish to modify. There are two general approaches to this interface. The first approach involves a URL-based technique for selecting the record to modify. The second approach utilizes a forms-based technique to achieve the same goal. Both approaches begin by querying a data source (in our case, the


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint