New MySQL database integration module

Good afternoon.

Today I am pleased to present you our new MySQL database integration module. MySQL is a free relational database management system, which you can use on your own server.

By configuring the integration of web form with MySQL database, you can send defined data from the form to the right mysql table, configuring the correspondence of table columns and data in the form.

To set up the integration, go to the "Modules" tab, where you will find a new "MySQL" module at the bottom of the list. Point the link to it and click on the "Add" button:

Adding the module integration with mysql database

After that a window will open with the basic settings of the MySQL module:

Basic settings of the mysql integration module

Here you should enter the database connection parameters:

  • Host (domain name or IP address)
  • MySQL user name, under which all queries will be executed
  • MySQL user password
  • Port
  • Name of the database to connect to
  • Encoding

Please note that your database must have remote access enabled, and the user has the right to access from the ip address of our server - 188.124.47.199

How to configure this is better to clarify with the technical support of your hosting provider.

Once all the data is specified, you must click on the button "Get access" and if everything is in order and we have access to your database, then below will appear a drop-down list in which you must select the table in which you will go to record:

Select mysql database table

In order to configure the correspondence of the columns of the database table with the fields in the form, you need to go to the "Advanced Options" tab:

Configuring mysql table columns.

Here you add necessary table fields, which will be filled with data from the form. You should pay attention to correspondence of column type and form field.

Once all data are filled in, you should click on "Save" button..

Now, after sending the form, all data will be transferred directly to your MySQL database and you will have full access to this data.

That is all for today. Have a nice day.

Comments
Ready-made templates of web forms
Gold

How much does it cost to rebuilt a car

Specify parameters of disks and find out the cost of tire service for your car. Details
Gold

House construction calculator

This online calculator calculates the cost of a box house in various configurations and shows the price of erecting a house Details
Gold

Oceans of the Earth

The test allows you to learn the level of knowledge about the oceans of the Earth Details
Gold

Calculate delivery cost

Answer a few simple questions and get a rough estimate of the shipping cost of your shipment. Details

We use cookies to make it easier for you to use the website. By using this page, you agree to our cookie policy.