book Examples & Instructions

On this page, you will find examples on how to use Free, Online Form Generator PHP Generator & MySQL Generator (FPMG).

Example 1(a): Before using FPMG

You may click on the images below to launch the Photo gallery and to see the screenshots in full page view.

Form Example

Example 1(b): Results after using FPMG

Form Example
Result - PHP Parameters
Result - MySQL code

Instructions for Form Generator PHP Generator & MySQL Generator:

  • Syntax: Select all the Syntax that you want to be generated automatically for you.
  • Table: This would be the Database table that you to perform the operation on. So in the earlier step, if you have checked "SELECT" syntax and you enter "members" in Table field, then the resultant MySQL query would perform a "SELECT" operation on the "members" table.
  • Form Action: Enter the page URL that you want the form to post the input information when a user clicks on the Submit button, once you use the generated form on your website.
  • Input Label: This is the Label that you want to appear for the form element.
  • Input Type: Select the type of input you want this to be, when the form is generated. For example, if you select "Textarea", then a Textarea will be generated for you. If you select "Submit", then a Submit button will be generated.
  • Process: It so happens that sometimes you want to pass some information via a form, but want to use it only for other purposes than actually inserting the value of this input element in database. Select "yes" if you would like to insert this field into database. Or select "no", if you don't want to. A good example that you will find a use of this option is when you are passing hidden fields for validation but don't want to insert the hidden field itself in the database.
  • Input Name: This is the most important part. This would be the name of the input element that you wish to generate. For example, if you want to generate a Form, which has provides an input field for user to enter his "First Name", then you can enter the input name as: "first_name". Please note that this input name is transparent to the user. What they see is the Input Label. So for the Input Name "first_name", you may want to enter the corresponding "Input Label" as "First Name", so that it makes sense to them.
  • DB* Col. name (if different) : In general, the Input Name and the Column name into which the Input value is inserted are same. For example, if you want to generate a HTML Form elements that says: "First Name", you can name the Input Name as "first_name". The MySQL query generated will insert the $_POST data of "first_name" into a database column with the name "first_name". In database, if you have a different column name and you would rather insert into another column, such as "last_name" instead of "first_name", then simply enter "last_name" in this field.