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 to PostgreSQL plugin
- Contact form 7 database plugin
- Ninja Forms database plugin
- Contact Form 7 Database (wordpress.org)
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.
1 2 3 4 5 6 7 |
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 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
1 2 3 4 5 6 7 |
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; } |
$79 for unlimited installation.