Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

MYSQL Database Form1 Builder Help

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

Form1 Builder MYSQL Database Form1 Builder Start

On This Page

  1. Overview
  2. Instructions for Use - Form1 Builder MYSQL
    1. Required Variable
      1. Form Delivery Email Address
      2. Variable Settings
    2. MYSQL
      1. MYSQL Use
      2. MYSQL Server Name
      3. MYSQL User Name
      4. MYSQL User Password
      5. MYSQL Database Name
      6. MYSQL Table Name
      7. MYSQL Empty Value
      8. MYSQL Fields to be Skipped
      9. Send Email Only if Error
    3. Optional Variables
      1. Content
        1. Deliver Empty Form Fields
        2. Deliver First Letter Upper Case Fields Only
        3. Local Time Offset
        4. Verification Subject Code
        5. Verification Body Code
        6. Include User Variables
        7. Include User Cookies
      2. Required Fields
        1. Defined Required Form Fields
        2. Defined As Empty Form Field Values
      3. Auto Responder
        1. Auto Responder Message
      4. Formating
        1. Display as HTML before Submission
        2. Alphabetically Sort Delivered Data by Form Field Name
        3. HMTL Email
        4. Line Break Off
        5. Access Password
        6. CSS (Cascading Style Sheet) File Name
      5. Messages
        1. Thank You URL
        2. Required URL
        3. Check Email URL
        4. Form Process Error URL.
      6. Pre-Defined Fields
        1. Defined First Name Form Field
        2. Defined Last Name Form Field
        3. Defined Email Address Form Field
        4. Defined Subject Form Field
        5. Defined Email Copy Form Field
      7. File Attachments
        1. Defined File Attachment Form Field
        2. Maximum Size of File Attachment
        3. Allowable File Types as Attachment
      8. Mathematical Functions
        1. Defined Plus Form Fields
        2. Defined Minus Form Fields
        3. Defined Multiply Form Fields
        4. Defined Divide Form Fields
        5. Execution Order of Form Fields
        6. Result Name
      9. Data Files
        1. CSV (Comma Separated Value) File Name
        2. XML (Extensible Markup Language) File Name
      10. Server Settings
        1. SMPT Mailserver Setting
    4. Quick Form
    5. Designer Form
      1. Add Pre-defined Fields
      2. Additional Fields
      3. Form Fields Table
    6. Existing Form
      1. Local Files
      2. Internet URL
      3. Copy and Paste Code
      4. Form Action Method
    7. Form Code
      1. Form Code Complete
      2. Form Processing Code Only
      3. Form Page Layout Code Only
    8. Upload
      1. Server Name
      2. User Name
      3. User Password
      4. Save As File Name
    9. Help
    10. Registration
    11. www.softswot.com
  3. Multi Page Forms
  4. Maintaining Form Content
  5. Trouble Shooting
  6. Requirements for Use
  7. Install / Uninstall
Overview

This software includes the base Form1 Builder plus an additional MYSQL feature. With Form1 Builder MYSQL you can automatically have form submission data added to your MYSQL database. For specific details on using this software with MYSQL please refer to the MYSQL section.

Form1 Builder runs in your web browser and allows you to easily build any web form. It applies the base Form1 structure to provide a single file form with a hidden email delivery address and an extensive range of benefits and options.

Back to Index

Key Features

Plus - Form1 Builder software provides:

All Form Code generated includes the extensive benefits and options provided by Form1 processing including:

Form1 (the generated form code) runs on your web server. To run Form1 your server must support the php scripting language. Most commercial web servers support php.

Back to Index

Instructions for Use - Form1 Builder MYSQL

Install it on your local system or upload it to your server. To use the Upload function Form1Builder files must be installed on your server. Then open the Form1BuilderMYSQL.html file in your web browser (JavaScript must be enabled). At the top of the page is the control Menu.

Initially it is recommended that you build a Quick Form, and give it a test run on you server. To do this:

  1. From the top menu click Required .
  2. Input your Form Delivery Email Address .
  3. Click Quick Form then Build Form.
  4. Then
  1. Select the Form Code Complete and copy it to a text editor.
  2. Save it as a file with a .php extension (i.e QuickForm.php). Some servers require files to have the extension .php before they will execute php code. If using NotePad as your text editor when you Save, select Save As Type "All Files" and then provide the full File Name i.e "QuickForm.php" to ensure a .txt extension is not applied to the file.
  3. Then upload the file to your web server and open the form in your browser i.e www.mydomain.com/QuickForm.php to give it a test run.
  1. or
  1. If you are running Form1Builder on your server you can use the Upload function.

Once you have seen Form1 in action on your server you can explore the range of features offered by Form1 Builder and generate single file forms to suit all your requirements. Use the controls Menu at the top or the progressive control links at the bottom of each section to develop forms.

Variables are set in the Form1 Builder and can be left empty if not required. Alternatively variables can be defined using hidden fields in your form. Variables set in the form overwrite variables set in the script except the Delivery Email Variable which will only use hidden form fields if it has no value in the processing script.

Back to Index

Required Variable

Form Delivery Email Address

Form Delivery Email Address.
This is where you want your form data sent. To send to multiple addresses separate each address with a comma (i.e [email protected],[email protected]).

Example: Variable set as [email protected]. In the processing script this appears as $delemail = "[email protected]";.

Alternatively: This variable can be set using two hidden fields in your form. For example:
<input type="hidden" name="delemailname" value="myemail" />
<input type="hidden" name="delemaildomain" value="mydomain.com" />

The values of the fields delemailname and delemaildomain are combined by the script with an @ to create the full email address (ie [email protected]). This prevents email harvesting even when the email components are visible in the code. If a Form Delivery Email Address ($delemail) is set in the processing script the hidden fields delemailname and delemaildomain are ignored. They are only applied if the Form Delivery Email Address ($delemail) variable is empty ie $delemail = "". It is recommended to set the Form Delivery Email Address ($delemail) in the processing script to ensure that form delivery cannot be redirected.

Back to Index

Variable Settings

Controls to save and load Required and Optional Variable Settings.

Default Variables sets the Required and Optional Variables to default values, these are also applied when you Start a new Form1 Builder session. Default values are:

Save Variables saves all the current Required and Optional Variables. Variables are saved as Cookies and Cookies must be enabled.

Load Variables sets all Required and Optional Variables to the previously saved values.

Clear All clears all Form1 Builder fields.

Back to Index

MYSQL

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. It is recommended that the form is run on the same server as your MYSQL database. 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 also 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.

The processed time as set in the form can be included by having a MYSQL table field with the name Processed.

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.

Back to Index

MYSQL Use

To use this feature MYSQL Support must be enabled in the server php configuration. If Form1 Builder is running on your server, and the server supports php from the Upload section you can View Server php Configuration. To use MYSQL the php configuration MYSQL section must be displayed.

MYSQL Use.
When selected (checked) this sets form processing to add submitted form data to a MYSQL database. If unchecked a MYSQL database will not be used. In the processing script this appears as $mysqluse = "true";.

Alternatively this variable can be set using a hidden field in your form. For example:
<input type="hidden" name="mysqluse" value="true" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

MYSQL Server Name

MYSQL Server Name.
This is the server for your MYSQL database (i.e mydomain.com).

Example: If your MYSQL server name is mydomain.com. In the processing script this appears as $mysqlservername = "mydomain.com";.

Setting this variable as a hidden field is not recommended.

Back to Index

MYSQL User Name

MYSQL User Name.
This is the user name for your MYSQL database.

Example: If your MYSQL user name is myuser. In the processing script this appears as $mysqlusername = "myuser";.

Setting this variable as a hidden field is not recommended.

Instead of setting the administrator as your MYSQL User it is good practice to set it as a user with Read/Write permissions only. To do this you will need to set up a specific user and password with Read/Write permissions in your database.

Back to Index

MYSQL User Password

MYSQL User Password .
This is the password for your MYSQL database.

Example: If your MYSQL user password is mypassword. In the processing script this appears as $mysqluserpassword = "mypassword";.

Setting this variable as a hidden field is not recommended.

Instead of setting the administrator as your MYSQL User it is good practice to set it as a user with Read/Write permissions only. To do this you will need to set up a specific user and password with Read/Write permissions in your database.

Back to Index

MYSQL Database Name

MYSQL Database Name.
This is the name of your MYSQL database.

Example: If your MYSQL database name is mydatabase. In the processing script this appears as $mysqldatabase = "mydatabase";.

Setting this variable as a hidden field is not recommended.

Back to Index

MYSQL Table Name

MYSQL Table Name.
This is the name of the Table in your MYSQL database. This must be an existing table in your MYSQL database. The form data will be added to this table.

Example: If your MYSQL table name is mytable. In the processing script this appears as $mysqltable = "mytable";.

Setting this variable as a hidden field is not recommended.

Back to Index

MYSQL Empty Value

MYSQL Empty Value.
This is the value that will be added to the MYSQL table field if there is no corresponding form field or the form field value is empty and the table field is not included in MYSQL Fields to be Skipped . If this is left empty any MYSQL table fields that are not skipped must accept NULL values.

Example: Variable set as NA. In the processing script this appears as $mysqlemptyvalue = "NA";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="mysqlemptyvalue" value="NA" />
Variables set in the form overwrite variables set in the processing script.

MYSQL Fields to be Skipped

MYSQL Fields to be Skipped.
This is the MYSQL table field names that are to be skipped when the table is updated with form data. This is primarily used for automatically incremented fields in MYSQL. Names of fields to be skipped should be input separated by a comma. If this is left empty any MYSQL table fields that do not have a corresponding form field will be be added with the MYSQL Empty Value.

Example: Variable set as ID. In the processing script this appears as $mysqlfieldskip = "ID";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="mysqlfieldskip" value="ID" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Send Email Only if Error

Send Email Only if Error.
This sets form processing to only send form data by email when there is an error adding the data to the MYSQL database. If an MYSQL error occurs the subject of the form delivery email is modified to Start with Error MYSQL. The email is sent to the Form Delivery Email Address. Because any MYSQL error notification is sent by email you must always provide a Form Delivery Email Address. If unchecked form data will always be sent by email as well as added to the MYSQL database table. In the processing script this appears as $sendonlyiferror = "true";.

Alternatively this variable can be set using a hidden field in your form. For example:
<input type="hidden" name="sendonlyiferror" value="true" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Optional Variables

Optional Variables include General Variables which can be applied to all forms and Advanced Variables which are applicable only in specific circumstances. They can be left empty if not required.

Content - General variables related to the content of the form delivery email. Deliver Empty Form Fields

Deliver Empty Form Fields.
When selected (checked) this will send empty form fields in the form delivery email. In the processing script this appears as $showempty = "true";.

Alternatively this variable can be set using a hidden field in your form. For example:
<input type="hidden" name="showempty" value="true" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Deliver First Letter Upper Case Fields Only

Deliver First Letter Upper Case Fields Only.
When selected (checked) this will only send fields with names that Start with an upper case letter in the form delivery email. If it is not selected all named fields in the form will be sent in the form delivery email. This may include some fields set by the processing code. In the processing script this appears as $firstupper = "true";.

Alternatively this variable can be set using a hidden field in your form. For example:
<input type="hidden" name="firstupper" value="true" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Local Time Offset

Local Time Offset.
This is the local time offset in hours from GMT/UTC and is used to define the form processed time. If set as 0 or left empty GMT/UTC will be recorded. You can use http://www.worldtimeserver.com to find your local time offset.

Example: If local time is 4 hours behind GMT/UTC time the variable is set as -4. In the processing script this appears as $timeoffset = "-4";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="timeoffset" value="-4" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Verification Subject Code

Verification Subject Code.
This appends the Verification Subject Code to the form delivery email subject and can be used with an email filter to ensure the email originates from the form. If this is left empty no Verification Subject Code will be appended.

Example: Variable set as W4r6hsL9. In the processing script this appears as $verifysubject = "W4r6hsL9";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="verifysubject" value="W4r6hsL9" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Verification Body Code

Verification Body Code.
This adds the Verification Body Code to the form delivery email body and can be used with an email filter to ensure the email originates from the form. If this is left empty no Verification Body Code will be added.

Example: Variable set as W4r6hsL9. In the processing script this appears as $verifybody = "W4r6hsL9";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="verifybody" value="W4r6hsL9" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Include User Variables

Include User Variables.
When selected (checked) this will include referrer, server, browser and IP address variables in the delivered form data. If this is unchecked no User Variables will be added to the form data. In the processing script this appears as $usehttpvars = "true";.

Example: User Variables included in the form data are formatted variable name : variable value as:

Variables -
User Browser (HTTP_USER_AGENT): Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624
User IP Address (REMOTE_ADDR): 202.45.107.1
Form1 PHP Server IP (SERVER_ADDR): 64.176.242.139
Form1 PHP Server Name (SERVER_NAME): www.softswot.com
Form1 PHP Script (PHP_SELF): /Form1Try.php
Form1 URL Domain: softswot.com
Form1 URL (HTTP_REFERER): http://www.softswot.com/Form1Try.php

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="usehttpvars" value="true" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Include User Cookies

Include User Cookies.
When selected (checked) this will include set user cookie data for the current domain in the delivered form data. If this is unchecked no User Cookies will be added to the form data. In the processing script this appears as $usecookvars = "true";.

Example: User Cookies are only those cookies that are currently set on the users system by the domain hosting the form (i.e http://www.mydomain.com). They are included in the form data and formatted cookie name : cookie value as:

Cookies -
a : testCookie

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="usecookvars" value="true" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Required Fields - General variables to set and manage the fields identified as required. Defined Required Form Fields

Defined Required Form Fields.
This is the form field names that are defined as Required (must be completed). Required field names should be input separated by a comma (ie First_Name,Last_Name). If Deliver First Letter Upper Case Fields Only is selected all form field names to be delivered must Start with an upper case letter. Spaces should not be used in field names, an underscore _ can be used as a separator and will be replaced by a space when the field name is displayed. If this is left empty no form fields will be set as required. For Select field types that require multiple selections the field name in the form; not in Defined Required Form Fields ($defrequired); must end with [] and the Select Start tag should include <select multiple='multiple'>. All field names set as Required must be included in your form.

Example: To define the field names First_Name and Last_Name as required the variable is set as First_Name,Last_Name. In the processing script this appears as $defrequired = "First_Name,Last_Name";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="defrequired" value="First_Name,Last_Name" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Defined As Empty Form Field Values

Defined As Empty Form Field Values.
This is the form field values that are defined as Empty (not provided). As Empty field values should be input separated by a comma (ie Please make a selection,Input your email address here). If this is left empty no form field values will be defined as empty.

Example: This is commonly used with Select fields so any default value is not treated as user input. For a Required Select field with the first option Please make a selection the selection of the first option will be treated as empty when this variable is set as Please make a selection. In the processing script this appears as $asempty = "Please make a selection";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="defrequired" value="Please make a selection" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Auto Responder - General variables to set an Auto Responder Message. Auto Responder Message

Auto Responder Message
This message will be sent to the input value of the Defined Email Address Form Field on form submission. The form should include an input email address field and it should be set as Required in the Defined Required Form Fields .

The Auto Responder Message is sent as a plain text email. All non-Alphanumeric characters should be avoided. Leave empty for no Auto Responder Message. In the processing script this appears as $autoresponse = "Thank you for your request, it is currently being processed.\n\nFor further details on our products and services please visit www.softswot.com.";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="autoresponse" value="Thank you for your request, it is currently being processed.\n\nFor further details on our products and services please visit www.softswot.com." />
Variables set in the form overwrite variables set in the processing script.

If editing an Auto Response Message directly in the form processing script or via a hidden form field use "\n" to include a line break.

Clear Auto Responder Message clears the Auto Responder text area contents.

Back to Index

Formating - General variables related to the formatting of the form submission and delivery email. Display as HTML before Submission

Display as HTML before Submission.
When selected (checked) this will display the form input as a html web page prior to form submission. This should not be used if your form includes a file upload. If unchecked the form will be submitted without prior display. In the processing script this appears as $htmldisplay = "true";.

Alternatively this variable can be set using a hidden field in your form. For example:
<input type="hidden" name="htmldisplay" value="true" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Alphabetically Sort Delivered Data by Form Field Name

Alphabetically Sort Delivered Data by Form Field Name.
When selected (checked) this will sort delivered form field data alphabetically by field name. If unchecked the delivered order will be as sent by the browser. In the processing script this appears as $alphasort = "true";.

Alternatively this variable can be set using a hidden field in your form. For example:
<input type="hidden" name="alphasort" value="true" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

HMTL Email

HMTL Email.
When selected (checked) this will set the form delivery email to include a multipart html format. If unchecked the form delivery email will be plain text. In the processing script this appears as $htmlemail = "true";.

Alternatively this variable can be set using a hidden field in your form. For example:
<input type="hidden" name="htmlemail" value="true" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Line Break Off

Line Break Off.
When selected (checked) this will remove the default line break between field Names and Values in the delivered form data. This is only applicable when the form delivery email is plain text with HMTL Email not selected. In the processing script this appears as $breakoff = "true";.

Alternatively this variable can be set using a hidden field in your form. For example:
<input type="hidden" name="breakoff" value="true" />
Variables set in the form overwrite variables set in the processing script.

Turning the line break off results in the delivered form data format:

Email Address: [email protected]

Maintaining the line break results in the delivered form data format:

Email Address:
[email protected]

Back to Index

Access Password

Access Password.
This sets a required password to access the form. If this is left empty no access password is required.

Example: Variable set as secretpassword. In the processing script this appears as $accesspass = "secretpassword";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="accesspass" value="secretpassword" />
Variables set in the form overwrite variables set in the processing script. It is recommended to set this variable in the processing script to ensure that it is not revealed in the source code.

Back to Index

CSS (Cascading Style Sheet) File Name

CSS (Cascading Style Sheet) File Name.
This is the URL address (i.e http://www.mydomain.com/style.css) of the Cascading Style Sheet (CSS) file you want to apply to the default html notification pages, and forms built using Quick Form and Designer Form functions. If this is left empty default style settings will be applied.

Example: Variable set as http://www.mydomain.com/style.css. In the processing script this appears as $accesspass = "http://www.mydomain.com/style.css";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="cssfile" value="http://www.mydomain.com/style.css" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Messages - General variables related to message and notification display. Thank You URL

Thank You URL.
This is the URL address (i.e http://www.mydomain.com/thankyou.html) you want to display after form submission. If this is left empty a standard thank you message will be displayed with a button to return to the form. The standard message will apply the CSS (Cascading Style Sheet) File Name if set.

Example: Variable set as http://www.mydomain.com/thankyou.html. In the processing script this appears as $thankurl = "http://www.mydomain.com/thankyou.html";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="thankurl" value="http://www.mydomain.com/thankyou.html" />
Variables set in the form overwrite variables set in the processing script.

When you include this setting the Form file name i.e form1.php is also passed to the Thank You URL as the value of a variable $reason. If you add the code:
<?php if(!isset($_GET)){$_GET=$HTTP_GET_VARS;}if(isset($_GET["reason"])){echo $_GET["reason"];} ?>
to your web page code the form file name will be displayed when the page is run on a server supporting php and viewed in a browser. Some servers require files to have the extension .php before they will execute php code.

Back to Index

Required URL

Required URL.
This is the URL address (i.e http://www.mydomain.com/required.html) you want to display if any Required fields are not completed. If this is left empty a standard required message will be displayed with a button to return to the form. The standard message will apply the CSS (Cascading Style Sheet) File Name if set. Required fields are set as Required in the Defined Required Form Fields variable.

Example: Variable set as http://www.mydomain.com/required.html. In the processing script this appears as $requrl = "http://www.mydomain.com/required.html";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="requrl" value="http://www.mydomain.com/required.html" />
Variables set in the form overwrite variables set in the processing script.

When you include this setting the missing Required Form Field Name i.e Email is also passed to the Required URL as the value of a variable $reason. If you add the code:
<?php if(!isset($_GET)){$_GET=$HTTP_GET_VARS;}if(isset($_GET["reason"])){echo $_GET["reason"];} ?>
to your web page code the form file name will be displayed when the page is run on a server supporting php and viewed in a browser. Some servers require files to have the extension .php before they will execute php code.

Back to Index

Check Email URL

Check Email URL.
This is the URL address (i.e http://www.mydomain.com/checkemail.html) you want to display if the Email Address submitted is not valid. If this is left empty a standard check email message will be displayed with a button to return to the form. The standard message will apply the CSS (Cascading Style Sheet) File Name if set. The email address is identified as the input of the form field that has the name of the Defined Email Field Name , by default this is Email_Address.

Example: Variable set as http://www.mydomain.com/checkemail.html. In the processing script this appears as $ckurl = "http://www.mydomain.com/checkemail.html";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="ckurl" value="http://www.mydomain.com/checkemail.html" />
Variables set in the form overwrite variables set in the processing script.

When you include this setting the email form field input is also passed to the Check Email URL as the value of a variable $reason. If you add the code:
<?php if(!isset($_GET)){$_GET=$HTTP_GET_VARS;}if(isset($_GET["reason"])){echo $_GET["reason"];} ?>
to your web page code the form file name will be displayed when the page is run on a server supporting php and viewed in a browser. Some servers require files to have the extension .php before they will execute php code.

Back to Index

Form Process Error URL

Form Process Error URL.
This is the URL address (i.e http://www.mydomain.com/processerror.html) you want to display if the form cannot be delivered on submission. If this is left empty a standard processing error message will be displayed with a button to return to the form. The standard message will apply the CSS (Cascading Style Sheet) File Name if set.

Example: Variable set as http://www.mydomain.com/processerror.html. In the processing script this appears as $errurl = "http://www.mydomain.com/processerror.html";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="errurl" value="http://www.mydomain.com/processerror.html" />
Variables set in the form overwrite variables set in the processing script.

When you include this setting the email form field input is also passed to the Check Email URL as the value of a variable $reason. If you add the code:
<?php if(!isset($_GET)){$_GET=$HTTP_GET_VARS;}if(isset($_GET["reason"])){echo $_GET["reason"];} ?>
to your web page code the form file name will be displayed when the page is run on a server supporting php and viewed in a browser. Some servers require files to have the extension .php before they will execute php code.

Back to Index

Pre-Defined Fields - General variables related to the handling of specific fields.

Pre-Defined Fields are not necessary for form processing but when included will be applied in a defined manner.

Defined First Name Form Field

Defined First Name Form Field.
This is the field name for the pre-defined input First Name. The input value is treated as a name provided by the form user. If provided it is combined with the input from the Defined Last Name Form Field as "First_Name Last_Name" and applied in the From address of the delivered form data email. The default value is First_Name, this can be changed by providing a different field name. If Deliver First Letter Upper Case Fields Only is selected all form field names to be delivered must Start with an upper case letter. Spaces should not be used in field names, an underscore _ can be used as a separator (ie First_Name) and will be replaced by a space when the field name is displayed. If this is left empty there will be no pre-defined data for this variable.

Example: Variable set as First_Name. In the processing script this appears as $deffirstname = "First_Name";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="deffirstname" value="First_Name" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Defined Last Name Form Field

Defined Last Name Form Field.
This is the field name for the pre-defined input Last Name. The input value is treated as a name provided by the form user. If provided it is combined with the input from the Defined First Name Form Field as "First_Name Last_Name" and applied in the From address of the delivered form data email. The default value is Last_Name, this can be changed by providing a different field name. If Deliver First Letter Upper Case Fields Only is selected all form field names to be delivered must Start with an upper case letter. Spaces should not be used in field names, an underscore _ can be used as a separator (ie Last_Name) and will be replaced by a space when the field name is displayed. If this is left empty there will be no pre-defined data for this variable.

Example: Variable set as Last_Name. In the processing script this appears as $deflastname = "Last_Name";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="deflastname" value="Last_Name" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Defined Email Address Form Field

Defined Email Address Form Field.
This is the field name for the pre-defined input Email Address. The input value is treated as an email address provided by the form user and checked for validity. It is applied in the From address of the delivered form data email. The default value is Email_Address, this can be changed by providing a different field name. If Deliver First Letter Upper Case Fields Only is selected all form field names to be delivered must Start with an upper case letter. Spaces should not be used in field names, an underscore _ can be used as a separator (ie Email_Address) and will be replaced by a space when the field name is displayed. If this is left empty there will be no pre-defined data and the delivery email address will be used as the From address.

Example: Variable set as Email_Address. In the processing script this appears as $defemail = "Email_Address";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="defemail" value="Email_Address" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Defined Subject Form Field

Defined Subject Form Field.
This is the field name for the pre-defined input Subject. The input value is applied as the subject of the delivered email. It can be set up as a text field for user input or as a hidden filed with a pre set value. The default value is Subject, this can be changed by providing a different field name. If Deliver First Letter Upper Case Fields Only is selected all form field names to be delivered must Start with an upper case letter. Spaces should not be used in field names, an underscore _ can be used as a separator and will be replaced by a space when the field name is displayed. If this is left empty there will be no pre-defined data and the default subject Form Submission will be used.

Example: Variable set as Subject. In the processing script this appears as $defsubject = "Subject";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="defsubject" value="Subject" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Defined Email Copy Form Field

Defined Email Copy Form Field.
This is the field name for the pre-defined input Email Copy. This field is usually a check box and when selected (checked) by the user a Carbon Copy (CC) of the form data email is sent to the From email address as determined by the Defined Email Address Field . This should only be used in conjunction with a Defined Email Address Field that is set as Required in the Defined Required Form Fields to ensure a user email address is provided otherwise it may result in two emails being delivered to the form delivery email address. The default value is Email_Copy, this can be changed by providing a different field name. If Deliver First Letter Upper Case Fields Only is selected all form field names to be delivered must Start with an upper case letter. Spaces should not be used in field names, an underscore _ can be used as a separator and will be replaced by a space when the field name is displayed. If this is left empty there will be no pre-defined data.

Example: Variable set as Email_Copy. In the processing script this appears as $defemailcopy = "Email_Copy";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="defemailcopy" value="Email_Copy" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

File Attachments - Advanced variables related to handling file attachments with form delivery.

To use File Attachments Display as HTML before Submission. must not be selected. When you use Designer form to add a file attachment field Display as HTML before Submission. is automatically unselected.

Also file_uploads must be set as on in the server php configuration. In most cases this will be set as on by the server host. If Form1 Builder is running on your server, and the server supports php from the Upload section you can View Server php Configuration to see the file_uploads setting.

Defined File Attachment Form Field

Defined File Attachment Form Field.
This is the field name for the pre-defined input File Attachment. This field must be of the input type="file" and the form Start tag must include enctype="multipart/form-data" to enable file attachments. Spaces should not be used in field names, an underscore _ can be used as a separator (ie Attach_File) and will be replaced by a space when the field name is displayed. If this is left empty no file attachments will be processed.

Example: Variable set as Attach_File. In the processing script this appears as $deffileatt = "Attach_File";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="deffileatt" value="Attach_File" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Maximum Size of File Attachment

Maximum Size of File Attachment.
This is the maximum allowable size in bytes of file attachments. The maximum upload size may also be limited by the server settings. If this is left empty or set to 0 no file attachments will be processed.

Example: To limit attached file sizes to around 50 kb (50 kilobytes) set this variable as 50000. In the processing script this appears as $filemaxsize = "50000";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="filemaxsize" value="50000" />
Variables set in the form overwrite variables set in the processing script.

The maximum allowable file size will be limited by the upload_max_filesize set in the server php configuration. If Form1 Builder is running on your server, and the server supports php from the Upload section you can View Server php Configuration to see the upload_max_filesize.

Back to Index

Allowable File Types as Attachment

Allowable File Types as Attachment.
This is the allowable file types (MIME) for file attachments. Allowable file types should be input separated by a comma (ie image/gif,image/jpeg,image/pjpeg,image/png,image/x-png,application/zip). Information on MIME types is available at W3Schools . Some file types have more than one MIME ie image/jpeg and image/pjpeg both refer to jpeg images. When a File Type Not Allowed Message is displayed it includes the not allowed file type. To enable processing of this file type add it to this variable. If this is left empty no file attachments will be processed.

Example: To allow attachments of gif, jpeg and png images as well as zip files set this variable as image/gif,image/jpeg,image/pjpeg,image/png,image/x-png,application/zip. In the processing script this appears as $fileallow = "image/gif,image/jpeg,image/pjpeg,image/png,image/x-png,application/zip";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="fileallow" value="image/gif,image/jpeg,image/pjpeg,image/png,image/x-png,application/zip" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Mathematical Functions - Advanced variables related to handling mathematical functions in the form. Defined Plus Form Fields

Defined Plus Form Fields.
These are the field names defined as Plus fields for Mathematical Functions. Field names should be input separated by a comma (ie Item_1,Item_2). The order of calculation is determined by the variable Execution Order of Form Fields . If Deliver First Letter Upper Case Fields Only is selected all form field names to be delivered must Start with an upper case letter. Spaces should not be used in field names, an underscore _ can be used as a separator and will be replaced by a space when the field name is displayed.

Example: To set the input for the fields named Item_1 and Item_2 as plus fields set this variable as Item_1,Item_2. In the processing script this appears as $defplus = "Item_1,Item_2";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="defplus" value="Item_1,Item_2" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Defined Minus Form Fields

Defined Minus Form Fields.
These are the field names defined as Minus fields for Mathematical Functions. Field names should be input separated by a comma (ie Item_3,Item_4). The order of calculation is determined by the variable Execution Order of Form Fields . If Deliver First Letter Upper Case Fields Only is selected all form field names to be delivered must Start with an upper case letter. Spaces should not be used in field names, an underscore _ can be used as a separator and will be replaced by a space when the field name is displayed.

Example: To set the input for the fields named Item_3 and Item_4 as minus fields set this variable as Item_3,Item_4. In the processing script this appears as $defminus = "Item_3,Item_4";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="defminus" value="Item_3,Item_4" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Defined Multiply Form Fields

Defined Multiply Form Fields.
These are the field names defined as Multiply fields for Mathematical Functions. Field names should be input separated by a comma (ie Item_5,Item_6). The order of calculation is determined by the variable Execution Order of Form Fields . If Deliver First Letter Upper Case Fields Only is selected all form field names to be delivered must Start with an upper case letter. Spaces should not be used in field names, an underscore _ can be used as a separator and will be replaced by a space when the field name is displayed.

Example: To set the input for the fields named Item_5 and Item_6 as multiply fields set this variable as Item_5,Item_6. In the processing script this appears as $defmultiply = "Item_5,Item_6";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="defmultiply" value="Item_5,Item_6" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Defined Divide Form Fields

Defined Divide Form Fields.
These are the field names defined as Divide fields for Mathematical Functions. Field names should be input separated by a comma (ie Item_7,Item_8). The order of calculation is determined by the variable Execution Order of Form Fields . If Deliver First Letter Upper Case Fields Only is selected all form field names to be delivered must Start with an upper case letter. Spaces should not be used in field names, an underscore _ can be used as a separator and will be replaced by a space when the field name is displayed.

Example: To set the input for the fields named Item_7 and Item_8 as divide fields set this variable as Item_7,Item_8. In the processing script this appears as $defdivide = "Item_7,Item_8";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="defdivide" value="Item_7,Item_8" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Execution Order of Form Fields

Execution Order of Form Fields.
This is the field order of execution for the Mathematical Functions. Field names should be input separated by a comma (ie Item_1,Item_5,Item_3,Item_7 which based on the above example is Item_1 * Item_5 - Item_3 / Item_7 ). If the input for Item_1=10, Item_5=20, Item_3=10 and Item_7=2 the calculation would be 20 * 10 - 10 / 2. The result is 95 and this will be displayed with the Result Name . The calculation order is not influenced by the operator (ie plus, minus, multiply, divide) and is strictly as defined by this variable. Only Defined Plus, Minus, Multiply or Divide field names can be used.

Example: To set the Execution Order to Item_1 then Item_5 then Item_3 then Item_7 set this variable as Item_1,Item_5,Item_3,Item_7. In the processing script this appears as $execorder = "Item_1,Item_5,Item_3,Item_7";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="execorder" value="Item_1,Item_5,Item_3,Item_7" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Result Name

Result Name.
This is the name displayed for the result of executing a mathematical function on form input values. If Deliver First Letter Upper Case Fields Only is selected it must Start with an upper case letter to be displayed or sent. The result is calculated when the form is submitted and if Display as HTML before Submission is set the result will be displayed to the user when the form submit button is clicked and before the form is sent. If this is left empty there will be no result calculated.

Example: Variable set as Order Total. In the processing script this appears as $resultname = "Order Total";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="resultname" value="Order Total" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Data Files - Advanced variables to send form data as a data file attachment. CSV (Comma Separated Value) File Name

CSV (Comma Separated Value) File Name.
This is the CSV Data File name (ie data.csv) and when set form data will also be delivered as a CSV Data File attachment to the form delivery email. Additional detail on CSV is available at Creativyst . If this is left empty no CSV Data File attachment will be sent.

Example: Variable set as data.csv. In the processing script this appears as $csvfile = "data.csv";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="csvfile" value="data.csv" />
Variables set in the form overwrite variables set in the processing script.

The CSV file sent is structured with form data value for each field included as:
"Value",

The processed time is:
"Time",

When Include User Variables is set the CSV file also has user variables included:
"User Browser",
"User IP Address",
"Form1 PHP Server",
"Form1 PHP Server Name",
"Form1 PHP Script",
"Form1 URL Domain",
"Form1 URL",

When Include User Cookies is set the CSV file also has each set Cookie value included:
"Value",

Back to Index

XML (Extensible Markup Language) File Name

XML (Extensible Markup Language) File Name.
This is the XML Data File name (ie data.xml) and when set form data will also be delivered as a XML Data File attachment to the form delivery email. Additional detail on XML is available from the W3Schools . If this is left empty no XML Data File attachment will be sent.

Example: Variable set as data.xml. In the processing script this appears as $xmlfile = "data.xml";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="xmlfile" value="data.xml" />
Variables set in the form overwrite variables set in the processing script.

The XML file sent is structured as:
<?xml version="1.0" ?>
<Form1_XML>

Form data for each field is included as:
<FormFieldName>Value</FormFieldName>

The processed time is:
<Processed>Time</Processed>

When Include User Variables is set the XML file also has a Variables tag with user variables included:
<Variables>
<HTTP_USER_AGENT>User Browser</HTTP_USER_AGENT>
<REMOTE_ADDR>User IP Address</REMOTE_ADDR>
<SERVER_ADDR>Form1 PHP Server IP</SERVER_ADDR>
<SERVER_NAME>Form1 PHP Server Name</SERVER_NAME>
<PHP_SELF>Form1 PHP Script</PHP_SELF>
<Domain>Form1 URL Domain</Domain>
<HTTP_REFERER>Form1 URL</HTTP_REFERER>
</Variables>

When Include User Cookies is set the XML file also has a Cookies tag with with each set Cookie included:
<Cookies>
<Cookie1Name>Value</Cookie1Name>
<Cookie2Name>Value</Cookie2Name>
</Cookies>

The XML file is closed with:
</Form1_XML>

Back to Index

Server Settings - Advanced variables to adjust server settings.

These settings are not normally required however if your form is not being delivered (particularly if you are using a windows based server) then it may be necessary.

SMPT Mailserver Setting

SMPT Mailserver Setting.
This will adjust the SMPT mailserver setting to the value provided, this should be your domain SMPT (ie mail.mydomain.com or smpt.mydomain.com). When this is set the server send_mail from is set as the delivery email. For some servers the send_mail from must be a valid email address on the domain mailserver. This means that if you are running your form on mydomain.com you must use a delivery email address that is valid on mydomain.com (ie [email protected]). Setting this value will also cause the email from address to be set as the first delivery email address. In most cases this is not required but it is a requirement to send emails on some servers (usually windows based servers). If this is left empty no server changes are made.

Example: Variable set as mail.mydomain.com. In the processing script this appears as $smptserver = "mail.mydomain.com";.

Alternatively: This variable can be set using a hidden field in your form as
<input type="hidden" name="smptserver" value="mail.mydomain.com" />
Variables set in the form overwrite variables set in the processing script.

Back to Index

Quick Form

Click Build Form to generate base Quick Form code. This includes basic fields to demonstrate Form1 features and functionality. The generated code is displayed in the Form Code section.

Quick Forms include default meta tags at the top of the generated html code. You can modify or remove these meta tags directly in the Form Code text area if desired. The displayed page title; which is the contents of the title tags (between <title> and </title>); can also be adjusted as required.

Back to Index

Designer Form

Allows you design a form to your specifications by Adding Pre-defined and Additional fields to the Form Fields Table. The the Form Fields Table displays the fields that will be included in your form when you Build Form.

Add Pre-defined Fields

You can add a Pre-defined field to the Form Fields Table by clicking the desired field description. Refer to Form Pre-Defined Fields for details on how predefined fields are handled.

Additional Fields

Input the required number of fields to Add or Remove from the bottom of the Form Fields Table and click Add or Remove.

Form Fields Table

You can adjust the variables of added fields as required. Pre-defined Field shaded variables should not be changed.

Once a field is added to the Form Fields Table you can adjust the variables. Pre-defined Field shaded variables should not be changed. The fields will be displayed on the form in the order they appear in the Form Fields Table. If Deliver First Letter Upper Case Fields Only is selected (which it is by default) the field names must Start with an upper case letter to be delivered.

Once you have the the form fields set up click Build Form to generate form code.

The generated code is displayed in the Form Code section.

Designer Forms include default meta tags at the top of the generated html code. You can modify or remove these meta tags directly in the Form Code text area if desired. The displayed page title; which is the contents of the title tags (between <title> and </title>); can also be adjusted as required.

Back to Index

Existing Form

Local Files

To use an existing form file as the base for your new form click Browse, select the html file from your local system. The file used must include a valid html form with a submit button. Form1 Builder must be running on the local system (ie saved on your computer) not via the internet to use this function. If you wish to use an internet file you can save it to your computer and then select it as a local file.

Once a local file has been selected click Build Form.

You can also click View Source Code to display the source code of a local file. Alternatively you can simply open the file directly in a browser window. You can then paste the source code directly into the Form Page Layout Code Only text area and Re-Build Using Form Page Layout Code to generate new Form Code. View Source Code is influenced by the way your browser handles different web page code and may not function in all cases.

When adding processing code to the top of an Existing form there must be no code (including form1 processing code) above the html Start tag. If a file includes code above the html Start tag open the file in a text editor and delete it before using the Existing Form function. When Deliver First Letter Upper Case Fields Only is selected (which it is by default) the field names must Start with an upper case letter to be delivered.

Back to Index

Internet URL

Input the URL Address of an existing web page ie http://www.mydomain.com/form.html. Then click View Source Code to display the source code of the Web Page. Alternatively you can simply open the file directly in a browser window. You can then save the displayed code to your local system and use it as a local file or you can paste the source code directly into the Form Page Layout Code Only text area and Re-Build Using Form Page Layout Code to generate new Form Code. View Source Code is influenced by the way your browser handles different web page code and may not function in all cases.

Back to Index

Copy and Paste Code

You can also easily add Form1 Processing Code to any valid web page form using a simple copy and paste. This allows you to copy the processing code from an existing Form1 file or from the Processing Code Only text area once you have run Build Form and paste it the the top of any valid form.

The copied processing must include all code from the top down to and including the line:

/* #### Below here is standard html. You can adjust the html as required. You can also copy the code from here up (including the ?> following this comment) and paste it at the top (above the html tag and any document type tags) of any html form page. All forms must be valid html and follow the guidelines provided in the help file. */?>

Open the existing file in a text editor and paste the copied processing code at the top (above the html tag and any document type tags). The existing form must be valid html and include:

You can modify the file including the Form Delivery Email Address and Optional Variables directly in the text editor. Save the new code as a file with the php extension and upload the saved file to your server.

A couple of points to remember when modifying forms:

Using the Copy and Paste Code method you can easily combine components from different web pages or forms with Form1 processing code or add Form1 Builder Designer Form components to existing web pages or forms. For example you can copy the form component only (from the form Start tag to the form end tag) and paste it directly into the body of an existing web page file.

When using an Existing file there should be no code above the first html tag and all html code must be valid. You can use the free W3C MarkUp Validation Service or the WDG HTML Validator to check form validation.

Form Action Method

As an alternative to adding Form1 Processing Code to a form you can simply point the form action of an existing form to the uploaded processing code. To do this simply provide a Form Delivery Email Address , adjust any desired Optional Variables , then from Designer Form click Build Form, upload the Form Processing Code Only to your server and set the form action of your existing forms to point to the uploaded processing code file. This method does not produce a single file form but allows the form1 processing script to process any forms that point to it. You can have multiple forms pointing to the one script.

Example: You upload the Form Processing Code Only to your server at mydomain.com and name the file form1process.php. The form processing code url is now http://mydomain.com/form1process.php or if you use a www directory http://www.mydomain.com/form1process.php. Then open your existing form file in a text editor or use the Local Files feature to edit the file directly in the Form Page Layout Code Only text area. Modify the form action to point to the form processing code url:

<form action="http://mydomain.com/form1process.php" method="post">

The existing form must be valid html and include a submit button. When Deliver First Letter Upper Case Fields Only is selected (which it is by default) the field names must Start with an upper case letter to be delivered. You can point multiple forms to the same processing script and set Optional Variables to whatever you like either directly in the processing code or using hidden form fields to set different options for different forms.

Upload your modified form and when you submit the form it will be processed by the processing code at http://mydomain.com/form1process.php.

Back to Index

Form Code

Form Code Complete

This is the complete layout and processing code for your form. Simply copy the code in this text area to a text editor, then save it as a file with the php extension ie form1.php and upload the saved file to your server. Alternatively you can use the Upload function. View Form layout displays the form in a new window.

Select All - Highlights all the text code in the Form Code Complete text area for copying it.

View Form Layout - Displays the built form in a new window. This is only the form layout and does not include the processing code. Your browser must allow new windows to be opened.

Clear Form Code Complete - Clears the contents of the Form Code Complete text area.

Back to Index

Form Processing Code Only

This is only required for multi page forms or advanced form modification.

This is the form processing code only. You can Copy and Paste Code to the top of existing forms or set the form action of existing forms to point to it once uploaded to your server. To upload simply copy the code in this text area to a text editor, then save it as a file with the php extension ie form1process.php and upload the saved file to your server. Alternatively you can use the Upload function.

Select All - Highlights all the text code in the Form Processing Code Only text area for copying it.

Clear Form Processing Code Only - Clears the contents of the Form Processing Code Only text area.

Back to Index

Form Page Layout Code Only

This is only required for multi page forms or advanced form modification.

This is the form page code only. You can paste existing form code into this text area, or modify code and Re-Build Using Form Page Layout Code. If you want to use a separate form processing script set the form action to point to the script, copy the code in this text area to a text editor, then save it as a html file ie form.html and upload the saved file to your server. Alternatively you can use the Upload function.

It is also possible to copy the form component only (from the form Start tag to the form end tag) and paste it directly into the body of an existing web page file.

Select All - Highlights all the text code in the Form Page Layout Code Only text area for copying it.

View Form Layout - Displays the built form in a new window. This is only the form layout and does not include the processing code. Your browser must allow new windows to be opened.

Clear Form Page Layout Code Only - Clears the contents of the Form Page Layout Code Only text area.

Re-Build Using Form Page Layout Code - Uses the current Form Page Layout Code Only text area contents as the base form and runs Build Form to add processing script. Any modifications made to Form Page Layout Code Only contents will then be reflected in all Form Code text areas.

Back to Index

Upload

The Upload function is only available when Form1 Builder is running on your server, the server supports php, and ftp functions are enabled in the php server configuration. Any files uploaded will be placed in the same directory as the Form1 Builder and will overwrite any existing file of the same name. To use this function you must upload and run all Form1 Builder files on your server. Some servers require files to have the extension .php before they will execute php code, if this is the case for your server you will need to rename your uploaded Form1Builder.html file to Form1Builder.php.

If Form1 Builder is running on your server, and the server supports php you can View Server php Configuration. The displayed php configuration is generated by the phpinfo function. To use the Upload function the php configuration ftp section must be displayed and FTP support must be enabled.

If your server does not support the Upload function simply follow the instructions in the Form Code section to place your form file on your server.

Server Name

Server Name.
This is the domain of your web site (i.e mydomain.com). It should be the domain only, no http or www.

User Name

User Name.
This is the user name to ftp access your web site.

User Password

User Password.
This is the password to ftp access your web site.

Save As File Name

Save As File Name.
The name of the file to be saved.

Upload Form Code Complete - Will upload the contents of the Form Code Complete text area.

Upload Form Processing Code Only - Will upload the contents of the Form Processing Code Only text area.

Upload Form Page Layout Code Only - Will upload the contents of the Form Page Layout Code Only text area.

Help

Open the Help file (this file) in a new window.

Back to Index

By building a series of forms and pointing the form action to the following form Multi Page forms can be developed. Simply set the form action of the first form to point to the second form and name the submit button multipage on all pages except the last. Each page will run the processing code on the following page. The form inputs are passed along to each form progressively with the last form action set to point to itself as a standard form1 form. Multipage forms should not be used with file attachments.

To use this feature Session Support must be enabled in the server php configuration. If Form1 Builder is running on your server, and the server supports php from the Upload section you can View Server php Configuration. To use the Multi Page Forms the php configuration session section must be displayed and Session Support must be enabled.

Maintain Form Content

Due to varying behavior between browsers the operation of the browser back button does not always maintain previously entered form input. This can result in lost input when a user submits but the submission is not sent due to missing input (Required Fields etc). This can be overcome by including code to maintain field values.
To do this for input type="text" fields in the input tag set the value attribute to:

<?php $name='FIELDNAME';if(isset($_SESSION['Form1'][$name])){echo $_SESSION['Form1'][$name];}?>

where FIELDNAME is the name of the form field.

Example:

<input type="text" size="34" name="First_Name" value="<?php $name='First_Name';if(isset($_SESSION['Form1'][$name])){echo $_SESSION['Form1'][$name];}?>"/>

When run on a server supporting php none of the code in the value attribute is displayed only the maintained form input.

The following outlines how to maintain input for different form fields.

For an Input, replace FIELDNAME as required:
<input type="text" size="34" name="FIELDNAME" value="<?php $name='FIELDNAME';if(isset($_SESSION['Form1'][$name])){echo $_SESSION['Form1'][$name];}?>" />

For a Text Area, replace FIELDNAME as required:
<textarea><input type="text" size="75" name="FIELDNAME" value="<?php $name='FIELDNAME';if(isset($_SESSION['Form1'][$name])){echo $_SESSION['Form1'][$name];}?>"/> </textarea>

For a Checkbox, replace FIELDNAME as required:
<input type="checkbox" name="FIELDNAME" <?php $name='FIELDNAME';if(isset($_SESSION['Form1'][$name])){echo 'checked="checked"';}?> />

For a Radio Button, replace FIELDNAME and VALUENAME as required:
<input type="radio" name="FIELDNAME" value="VALUENAME" <?php $name='FIELDNAME';$value='VALUENAME';if(isset($_SESSION['Form1'][$name])&&$_SESSION['Form1'][$name]==$value){echo 'checked="checked"';}?> />

For a Single Select, replace FIELDNAME and VALUENAME as required:
<select name="FIELDNAME">
<option <?php $name='FIELDNAME';$value='VALUENAME';if(isset($_SESSION['Form1'][$name])&&$_SESSION['Form1'][$name]==$value){echo 'selected="selected"';}?> >VALUENAME</option>
</select>

For a Multi Select, replace FIELDNAME and VALUENAME as required:
<select name="FIELDNAME" multiple="multiple" >
<option <?php $name='FIELDNAME';$value='VALUENAME';if(isset($_SESSION['Form1'][$name])&&is_array($_SESSION['Form1'][$name])&&in_array($value,$_SESSION['Form1'][$name])){echo 'selected="selected"';}?> >VALUENAME</option>
</select>

Form input is maintained until the form is sent or the user session expires.

To use this feature Session Support must be enabled in the server php configuration. If Form1 Builder is running on your server, and the server supports php from the Upload section you can View Server php Configuration. To use the Maintain Form Content feature the php configuration session section must be displayed and Session Support must be enabled.

Back to Index

Form Processing

Processing - The form information processed for email delivery is determined by the Field Name. Fields that have a name where the first letter is Upper Case (i.e First_Name, Email_Address) will be processed for email delivery and included in the form data email. Fields that have a name where the first letter is lower case (i.e submit, reset) will not be processed for email delivery. Field names that are set in the Required variable are identified as Required. If a Required field has no input on form submission a user prompt is provided.

Submit Button - All forms must include a submit button.

Form Tag - The form tag must include

<form action="<?php if(!isset($_SERVER)){$_SERVER=$HTTP_SERVER_VARS;}echo $_SERVER['PHP_SELF'];?>" method="post">

Or instead of using php code in the form action replace it with the form file name i.e <form action="QuickForm.php" method="post">.

Form processing code is include at the top of the form. Using a text editor or a Form Code text area you can adjust these processing variables. Only the contents between the '' 's in the User Configuration Settings should be changed in the top php code section. Any other changes could corrupt Form1 functionality. A description and example is provided for processing variables in the help sections Form Delivery Email Address and Optional Variables .

Back to Index

Trouble Shooting

Back to Index

Requirements for Use

Form1 Builder runs directly in your browser. Your browser must support JavaScript and the Document Object Model. Current browsers all support these features. If your browser does not support these features a browser upgrade notification will be provided when you open Form1 Builder.

Form1 runs on your web server. To run Form1 your server must support the php scripting language. Most commercial web servers support php.

If your downloaded software is compressed (.zip) it will require unzipping for use. Trial Zip software is available free from Winzip or a simple freeware zip utility is available from JustZIPit .

Back to Index

Install / Uninstall

Form1 Builder runs in your web browser. If software is downloaded as a Self-Extracting SetUp file (.exe) when you run the SetUp file it will extract and install the program. If software is downloaded as a standard Compressed Zip file (.zip) it requires unzipping for use. Trial Zip software is available free from Winzip or a simple freeware zip utility is available from JustZIPit . To install simply unzip or run the downloaded file then open the file Form1BuilderMYSQL.html in your browser and follow the Instructions for Use .

To use the Upload function Form1Builder files must be installed on your server. To do this simply upload all the files installed on your computer when you installed Form1 Builder to your server and open the server based file Form1BuilderMYSQL.html in your browser (ie http://mydomain.com/Form1BuilderMYSQL.html. Make sure you use the exact case as some servers treat upper and lower case letters as different. Some servers require files to have the extension .php before they will execute php code, if this is the case for your server you will need to rename your uploaded Form1BuilderMYSQL.html file to Form1BuilderMYSQL.php.

Form1 (the actual forms) run on your web server. To run Form1 your server must support the php scripting language. Most commercial web servers support php.

Please Note: Form1 code includes php scripting which may be corrupted by some html editors. To directly edit the actual Form1 code without using the Form1 Builder it is recommended that a text editor is used. If you wish to use a html editor we recommend (and use) HTML-Kit . HTML-Kit is a free standards compliant editor that unlike most html editors (Front Page, DreamWeaver etc) produces clean valid html and will not corrupt php scripts.

Once you have made your modifications save your form file and upload it to your web server. Then open Form1 in your browser i.e www.mydomain.com/Form1.php.

You can make modifications to your form and save each with a different file name to create multiple forms.

Back To Index

Back to: Form1 Builder MYSQL Start | See Screen Shots

Form1 Builder MySQL $59.00 Secure Payment Options 30 Day Money Back Guarantee

Special ! Free Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH!  Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

See Also: Database Software Index | GoldMine Form1 Builder | Form Builder Software | All Database Software



Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates