With this server behavior you can create a form that display data from multiple record at once and the user can update all the record at the same time.
The setup of this behavior is the same of the standard Dw Update behavior.
To see how is simple to use and setup download the flash tutorial.
DownloadThere is a very important issue about php you must now.
In PHP when you have repeat form fields with the same name, like in this extension, you must add the [] (open and close brackets) in the end of the form fields name and id like this example:
<input type="text" name="fieldName[]" id="fieldName[]" value="" />This is requested by the the server to return an array of values. The extension will add this brackets to your form fields when you click the Ok button or you can add yourselfe but be sure you have this brackets in the fields name and id before you apply the form validator.
Connection:
In the Connection pop-up menu, select a connection to the database.
Click the Define button if you need to define a connection.
Table to update:
In the Update Into Table pop-up menu, select the database table into which the record should be updated
Select record from:
In the Select Record From pop-up menu, specify the recordset that contains the record displayed in the HTML form.
Unique column key:
In the Unique Key Column pop-up menus, select a key column (usually the record ID column) to identify the record in the database table. Select the Numeric option if the value is a number. A key column usually accepts only numeric values, but sometimes it accepts text values.
After updating, goto to:
In the After Inserting, Go To text box, enter the page to open after the record is inserted into the table or click Browse to browse to the file.
Get value from:
In the Get Values From pop-up menu, select the HTML form used to enter the data.
Dreamweaver automatically selects the first form on your page.
Form elements:
Select the form object that will update the column from the Value pop-up menu, and then select a data type for the form object from the Submit As pop-up menu.
Column:
Specify a database column to update
Submit as:
The data type is the kind of data the column in your database table is expecting (text, numeric, Boolean checkbox values).
