Design Resources

Multiple Insert Record (Dreamweaver PHP)

Multiple Insert Record by Metho

The major reason why Dremweaver cannot do multiple inserts is because of the fields offered in the server behaviour dialog box. The dialog asks for a URL to go to after a successful insert. If the developer puts a value in this box, the application does an exit before it can perform any other actions.

If your page form is properly designed to do multiple inserts, then handling those actions via Dreamweaver is as simple as leaving the insert record server behaviour value for the redirect URL blank until the last insert behaviour is cycled through. When this last insert is generated by DW, the redirect portion is written into the code and allows the application to exit.

Let's take a look at an example; change the form values and press submit to insert and display the records...

Multiple Insert Record Values

Multiple Record Insert Form
Record	Column 1 Value	Column 2 Value
Record 1
Record 2
Record 3
Submit

... NEXT :: Page 1, 2, 3, 4.