Using WinMySQL Professional

Client generators - Web generators - HTML - Input form from current table structure

Only accessible when connected and a table is active, the «Client generators>Web generators>HTML>Input form from current table structure» submenu allows a user to choose, in the current table structure, the columns which he wants to put on the HTML form to be generate.

How to create an HTML input form ?

To create an HTML form, click on the «Client generators>Web generators>HTML>Input form from current table structure» submenu. It displays the HTML form generator window, which includes a top field «URL of script or cgi to be processed after submit on current form» to enter the internet address of the script to be performed once the form is submited (the default value is «mysql.php» to be the same as the default name of PHP scripts generated with the «Client generators>Web generators>PHP» submenus). The «HTML form generator» window also includes two listboxes with list management buttons to allow you to choose columns in the left listbox (representing the structure of the current table), picking up to switch these columns to the right listbox (representing the list of fields asked by the input form to be generated).

So, select from the left listbox the first column that you wish to see appear in the HTML input form, click on the «>>» button to put it on the right listbox (or just double-click on the column to select). Repeat this operation for every column that you want to have in the HTML input form and click on the «Generate form» button to choose a filename (*.html or *.htm) to store the generated form. Then, export this file to your website by a FTP transfer or any other transfer way.

You may also include fields «Login name» and «Password» in the input form to allow the server side script to connect to a MySQL® database with a dynamic authentication. To do it, check the «Input form requires authentication» checkbox.

Tip: you may put all the columns, if you want to obtain a input form linked with a script which inserts lines into a MySQL® database.

Note : The input fields will appear in the same order than in the right listbox. Then, before generating a form, use the «Up» and «Down» buttons to change this order in the right listbox. If the «Input form requires authentication» checkbox is checked, the fields «Login name» and «Password» will appear first in the HTML input form.

The example above shows the result obtained by the first screenshot.