MySQL is a very popular database within several web hosting services. In addition of sending the field values via email, the script of Forms To Go can dump these values in a MySQL database table.
The only requirement is that the data base table must be previously created, field names must be known, and all database access parameters must be available.
Furthermore, Forms To Go offers the possibility of creating an additional script that lets the user visualize field values that have been stored in the database.To set the script to write to a MySQL database, you must selectthe Settings->Database->MySQL menu and click the Insert field values in a MySQLtable checkbox.
All parameters to access the database are listed in the connection panel.
These parameters are provided by the database administrator and are mandatory; otherwise, the script could not be created.
The Hostname must be the IP address or the domain name of the MySQL server. In many cases, when the database server is in the same web server, localhost is used as server name.
The User, Password and Database parameters are mandatory.
The only non mandatory parameter is the port number. If the database administrator did not provide this value, it must be in blank.Note: connection parameters are case-sensitive. They must be written just as they were created or assigned by the database administrator.
The relation between the fields of the HTML form and the table fields of the MySQL database are defined in this panel.
You must define the Table name of the database where values will be dumped. This table must exist in the database and table fields must be known.
Next you will find a list of all the fields of the HTML form. You must select the checkbox of each field you want to dump in the HTML table, and put the name of the equivalent field in the MySQL table, in the right column.Note: the table name and the field names of the MySQL table are case-sensitive. They must be written as they were created.
This panel allows you to dump server, environment and date values to the MySQL database table.
The following are dumpable values:
HTTP_USER_AGENT: browser being used by the user, reported by the web browser.
REMOTE_ADDRESS: IP address of the user sending the form data.
DATE: date when the data is being dumped in the database. The format is YYYY-MM-DD.
TIME: time when the data is being dumped in the database. The format is HH:MM:SS.
DATE_TIME: date and time when the data is being dumped in the database. The format is YYYY-MM-DD HH:MM:SS.
To dump any of these values, you must select the related checkbox and put in the second column the field name of the MySQL table, specified in the Data dump panel.Another setup parameter in this panel is the one related to MySQL errors. Due to security reasons, several users would not like to have the error output with access details or database dumped values shown in the browser. If you select the Show errors in the browser option, if an error occurs, the error message will be shown in the browser and script execution will be suspended, otherwise, no error will arise and the script execution will continue.
Upon dumping data in the database table, you can generate an additional script that will let the user display all data stored in the MySQL table.
To generate the additional script, you must select the Create a web browser checkbox and then set up the remaining parameters.
The script will display a list of all data recorded in the database, and by clicking each recorded data, a detail of all recorded fields will be displayed.
To set up the list, you must select the fields to be displayed by clicking the Listed fields checkboxes.
The list will be sorted by the field defined in Sorted by and a total of Records per page will be displayed in each list.If these two values are not defined, the records will be shown by 20 per page and sorted by time and date of recording in descending order.