Formidable Forms + MySQL Database [Plugin] – Develop CRM


 

The Formidable Forms MySQL integration plugin (Formidable DB) saves entries to the MySQL database.

It saves data to MySQL’s separate tables and columns. Each form will save to a separate table.

The column name is based on the input label or placeholder. We can change the table or column name by filter hooks.

It helps you to save submissions to an internal or external (remote) MySQL database.

 

Other Database Plugins

  1. WPForms to PostgreSQL plugin
  2. Contact form 7 database plugin 
  3. Ninja Forms database  plugin
  4. Contact Form 7 Database (wordpress.org)
  5. More plugins

Formidable Form

It is a demo Formidable form’s front view.

 

Formidable Forms + MySQL Auto-Generated MySQL Table (phpMyAdmin)

It is an auto-generated MySQL table.

 

Formidable Forms + MySQLWP-Admin Dashboard

 

 

How to Save Formidable Forms to MySQL Database?

Install the Formidable Forms + MySQL WordPress plugin. Then go to Formidable DB > Switch Database > Add MySQL Credentials.  Enable remote MYSQL server if you want to connect remote MYSQL.

Now, We can see new tables created in our MySQL database. We can add an internal or remote database.

wpforms switch database

 

 

How Does it Generate MySQL Table Name?

The default table name is {prefix}_db4frm_{form_id}. Example is wp_db4frm_105.

If we need to change the MySQL table name,  then add the following code to theme functions.php then we can change the table name.

How Does it Generate MySQL Column Name?

The default column name is coming from the input field label or placeholder.

Example: Label is First Name then the MySQL column name is first_name.

We can change the column name by following the code. Add the following code to theme functions.php

 

$79 for an unlimited installation. No monthly or yearly fees.