Operation Manual

590
USING DREAMWEAVER
Building applications visually
Last updated 3/28/2012
2 Select a form from the Submit Values From pop-up menu.
3 In the Data Source pop-up menu, select a connection to the database.
4 Enter your user name and password.
5 In the Insert Into Table pop-up menu, select the database table to insert the record in.
6 Specify a database column to insert the record in, select the form object that will insert the record from the Value
pop-up menu, and then select a data type for the form object from the Submit As pop-up menu.
The data type is the kind of data the column in your database table is expecting (text, numeric, Boolean option values).
Repeat the procedure for each form object in your form.
7 In the After Inserting, Go To box, enter the page to open after the record is inserted in the table or click the Browse
button to browse to the file.
8 Click OK.
Dreamweaver adds a server behavior to the page that lets users insert records in a database table by filling out the
HTML form and clicking the Submit button.
Add a server behavior to insert records in a database table (ASP)
1 In the Server Behaviors panel (Window > Server Behaviors), click the Plus (+) button and select Insert Record from
the pop-up menu.
2 In the Connection pop-up menu, select a connection to the database.
Click the Define button if you need to define a connection.
3 In the Insert Into Table pop-up menu, select the database table into which the record should be inserted.
4 In the After Inserting, Go To box, enter the page to open after the record is inserted into the table or click Browse
to browse to the file.
5 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.
6 Specify a database column to insert the record in, select the form object that will insert the record from the Value
pop-up menu, and then select a data type for the form object from the Submit As pop-up menu.
The data type is the kind of data the column in your database table is expecting (text, numeric, Boolean option values).
Repeat the procedure for each form object in your form.
7 Click OK.
Dreamweaver adds a server behavior to the page that lets users insert records in a database table by filling out the
HTML form and clicking the Submit button.
To edit the server behavior, open the Server Behaviors panel (Window > Server Behaviors) and double-click the Insert
Record behavior.
Add a server behavior to insert records in a database table (PHP)
1 In the Server Behaviors panel (Window > Server Behaviors), click the Plus (+) button and select Insert Record from
the pop-up menu.
2 Select a form from the Submit Values From pop-up menu.
3 In the Connection pop-up menu, select a connection to the database.
4 In the Insert Table pop-up menu, select the database table to insert the record in.