Form1 Builder MYSQL

With Form1 Builder MYSQL you can automatically have form submission data added to your MYSQL database

To use the MYSQL option you must have a server based MYSQL database and it must have an existing table with field names that correspond to form field names. On form submission a new record is added to the MYSQL database table.

MYSQL database table fields that are not set as MYSQL Fields to be Skipped and have the same name as form fields will include the input of the form field. Form field inputs are processed as text variable types.

Additional form variables can be added to the MYSQL table by including a field in the MYSQL table that has the same name as the field to be included.

When Include User Variables is set variables available include:

Field Name Description
HTTP_USER_AGENT User Browser
REMOTE_ADDR User IP Address
SERVER_ADDR Form1 PHP Server IP
SERVER_NAME Form1 PHP Server Name
PHP_SELF Form1 PHP Script
Domain Form1 URL Domain
HTTP_REFERER Form1 URL

When Include User Cookies is set Cookies can be added to the MYSQL table by having a MYSQL table field with the name of the Cookie.

Form1 Builder MYSQL generates form processing code that runs on your web server. To run this code your server must support the php scripting language. Most commercial web servers support php.