How to connect 123FormBuilder forms with your own database

123FormBuilder is a professional web form builder that not only creates user-friendly contact forms but also covers them with many features that you might find useful.

It was possible to connect your web forms with a CSV file, however, we facilitate the process. Now you can also send form submissions to your own MySQL or MariaDB database.

Starting with our Corporate plans you will be able to make the connection. Once upgraded, go to Integrations and look for Virtual Database.

Virtual Database 123FormBuilder integration

After adding, you will notice two options:

Connect database manager

Select the second one. In the lightbox that appears enter your database details and test the connection.

For the MySQL connection, we support version 5.7

Connect to external database

Below we provided two syntaxes as a starting point.

Inserting into the table:
INSERT (IGNORE) INTO table_name SET column_name=:field_control (SET second_column_name=:other_field_control, etc.)

Update the table info:
table_name SET column_name=:field_control WHERE other_column_name=:other_field_control (AND second_column_name=:second_field_control, etc.)
*Include REMOTE at the beginning of the above syntaxes if table is stored on remote server.

Here is an example:
When the form is submitted, the action should store the data in the contacts table.

Normally, if you fill the form twice using the same code, you will have 2 rows inserted, with the same code, and the corresponding data.

If you wish to only keep the latest data, you have to set the code column as unique. This is done from the Explore database panel. After selecting a table from the list also click on the key symbol at the bottom of the list. This will open up a separate view of the table columns and their type, from which you can enable/disable the primary key lock.

Edit indexes

You will be able to use INSERT INTO IGNORE as a function so that you do not get entry rows with the same primary key.

Even if you are not familiar with SQL queries, our Corporate plans have an advantage. Once you sign up, a dedicated Account Manager will help you develop your forms based on your needs.

Related articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Frequently Asked Questions

Here is a list of the most frequently asked questions. For more FAQs, please browse through the  FAQs page.

Is this service free?
Yes, we offer a free form builder service. Just sign up to the Basic plan and you are all set. This plan is forever free, but you are limited with a few features only, such as 5 forms per account, 100 submissions per month and you have to keep the backlink to 123FormBuilder on your forms. Check out our features matrix for more information.
How many forms can I create?
It depends on the service plan you are on. Higher service plans enable more features, including more web forms for your account. If you need more forms, go to the My Account section of your account and click the upgrade button. To create an unlimited number of forms, either upgrade to the Platinum service plan or higher. Consult our features matrix for more information.
How can I publish my forms?
You can publish your forms in many ways, by using their direct URL or HTML link, embedding them with a JavaScript code, Inline HTML or iFrame, using the Facebook app or the WordPress plugin, using popups, the Blogger code snippet and many more. Once you have created and customized your form, go to the Publish section to complete your work. Read more in our documentation.
How do I change my form design?
You can change the design of your form for more information. in the Themes section, which is located in your form settings. We offer a set of more than 30 predefined form themes for your forms, but you can also create your own from scratch. You can customize the submit button, the logo and more. To apply your own stylesheets, all forms come with a custom CSS editor.

Can't find what you're looking for?