MySQL Mapping
Description of MySQL Mapping settings in WordPress Form Maker plugin
WordPress Form Maker stores the submitted information into [prefix]_formmaker_submits MySQL database table of your website by default. However, with MySQL Mapping functionality of Form Maker you can save this data on a local or remote table of your choice.
Edit your form, then navigate to Form Options > MySQL Mapping page and press Add Query button to configure the first query for this form. This will open a toolbox popup, where all form fields will be listed, along with their indicators.
Connection type. Choose to connect to a Local or Remote database table. Type option lets you configure Insert, Update or Delete queries. Press Connect after selecting these two settings.
In case you choose to connect to a Remote database table, you need to provide the Username, Password and the Database title.
Select a table. Use this drop-down menu to choose the MySQL Table, where you would like to store the submitted information, for instance, [db_prefix]_posts.
Under SET section you will see all fields of this database table, e.g. ID, post_content, post_title and more. Mark the checkbox next to each input to activate it.
Afterwards, click on the inputs and choose the field of your form. The value of this field will be inserted into the selected database field. It is also possible to specify the form fields by clicking on the inputs and pressing the buttons indicating form fields. For instance, activate post_author field and choose Name as its value:
Afterwards, click on Generate Query button to create the query, and display it in the box below the database fields. In this case, the query will be the following:
INSERT INTO wp_posts (`post_author`) VALUES ("{5}")`1
You can also make custom changes to the query after it is generated. Make sure to press Save button to keep the query, or click the X button in case you wish to start over.
The query above inserts a new line in the database table each time users hit submit. But you can also create UPDATE or DELETE queries, which will be executed in case WHERE condition is fulfilled.
Click the Plus (+) icon next to WHERE to add a condition. You are able to add multiple conditions, which will run when users press submit.
Where. Select the table field and provide the condition, which can be set to equal to, not equal to, larger than and more. Afterwards you will need to provide the value of the condition.
You can remove created queries anytime by pressing Delete button from Form Options > MySQL Mapping page.
 Previous Step
|
Next Step
|