Connect WordPress WPForms to MySQL Database Integration [Plugin]

Connect WPForms to MySQL database integration. DB4 WPForms plugin saves the submissions to MySQL separate tables and columns.

We can save submissions to an internal or external (remote) MySQL database.

It will automatically generate MySQL tables and columns. No need for any extra coding for simple use.

Other Database Plugins

WPForms Form

It is a demo WPForms form’s front view.

WPForms Auto-Generated MySQL Table (phpMyAdmin)

It is an auto-generated MySQL table.

WPForms WP-Admin Dashboard

How to Save WPForms to MySQL Database?

Install DB4 Wpforms WordPress plugin. Then go to DB4 Wpforms > Switch Database > Add MySQL Credentials.

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

How Does it Generate MySQL Table Name?

The default table name is {prefix}_form_{form_id}. Example is wp_form_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.

add_filter('db4wp_form_table_name', 'my_custom_change_entry_table_name', 10, 3);
function my_custom_change_entry_table_name($table_name, $form_id, $prefix){
   if( $form_id == 105){
     $table_name = 'my_custom_table';
   }
   return $table_name;
}

add_filter('db4wp_form_table_name', 'my_custom_change_entry_table_name', 10, 3);

function my_custom_change_entry_table_name($table_name, $form_id, $prefix){

if( $form_id == 105){

$table_name = 'my_custom_table';

}

return $table_name;

}

How Does it Generate MySQL Column Name?

The default column name comes 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

add_filter('db4wp_form_map_data', 'my_custom_change_column_name', 10, 3);
function my_custom_change_column_name($arr, $form_id){
    if( $form_id == 105){
        $arr['first_name'] = 'my_custom_name';
    }
    return $arr;
}

add_filter('db4wp_form_map_data', 'my_custom_change_column_name', 10, 3);

function my_custom_change_column_name($arr, $form_id){

if( $form_id == 105){

$arr['first_name'] = 'my_custom_name';

}

return $arr;

}

FAQ

1. Does it work with the WPForms Lite version?
Yes, it is compatible with both the Lite and Pro versions of WPForms.

2. Do you offer a free version of the WPForms database plugin?
Yes, you can find our free version here: WPFormsDB plugin (The free version stores all form data in a single MySQL table).

$79 for unlimited installation.

WPDebugLog