Dumping Values to a Database:
MySQL (only PHP and Perl)

Dumping field values to MySQL is only available for PHP and Perl. This option, writes the field values of the HTML form into a MySQL database table that is already created after the user submit the form.

It is independent of the email message to the form's owner, and the MySQL table fields must be specified previously.

Requirements and Restrictions

• This option is only available in PHP and Perl scripts.

• It's only available in the registered version of Forms To Go.

• All the MySQL database settings must be handy and should be consulted with your web system administrator.

• Previous knowledge table's field names where the form's field values will be inserted.

 

To configure the settings and activate this option, select MySQL Dump... from the Settings menu.



 

Insert field values into a MySQL table

Select this option to include in the PHP or Perl script the specific code to dump the fields values to the MySQL table.

Hostname

The hostname were the MySQL database is located. It can be a fully qualified internet name or an IP address, as well a local alias for the MySQL server. This settings is mandatory.

Port

Optional value in case the connection to the MySQL server is thru another port.

Database

The database name on your MySQL server.

Table

The table name where the field values will be dumped.

User

The name of the user to access the database.

Password

The password of the user to access the database.

Field mapping

When dumping the form's field values to the MySQL table, you must select which fields will be dumped by clicking in the checkbox to the left of the field name in the column Form's field name. For every field you select, you must type in the right column MySQL's field name, the equivalent MySQL field name.

Do not leave any MySQL's field name empty for each form field selected.


More about Dumping Values to a Database:

Text file
MySQL
MS Access

Index