Prepare an update form Dreamweaver and PHP


show more Preparing an update form provides you with in-depth training on Business. Taught by David Gassner as part of the Dreamweaver with PHP and MySQL show less
please wait ...

Preparing an update form

Just as with inserting data into a database, you can create a data entry form to update data using Dreamweaver's update record server behavior. Before you use the server behavior though, you need to prepare the form to display data from a single record that the user wants to update. I'll be working in the file explorerupdate. php, in the Explorers folder of my site root. The first step is to add a binding, or recordset to the form, to retrieve a single record from the database table. I'll go to the Bindings panel and click plus and choose Recordset or Query.

I'll give my recordset a name of rsExplorer. Notice I am using the singular version of Explorer, rather than the plural version, because I am only going to retrieve the single record, filtered by the primary key of the table. Then I'll choose the Explorers table. I'll click Selected, and then holding down Ctrl on Windows or Command on Mac, I'll select only the fields that I want to display in the form: the ex...

Preparing an update form
Video duration: 7m 6s 4h 55m Intermediate Updated Jun 12, 2012

Viewers:

Preparing an update form provides you with in-depth training on Business. Taught by David Gassner as part of the Dreamweaver with PHP and MySQL

Subjects:
Business Developer Web
Software:
Dreamweaver
Author:
please wait ...