{"id":6864,"date":"2022-10-21T09:32:30","date_gmt":"2022-10-21T13:32:30","guid":{"rendered":"https:\/\/themespress.ca\/?p=6864"},"modified":"2022-10-30T12:03:25","modified_gmt":"2022-10-30T16:03:25","slug":"wordpress-table-formidable-form-data","status":"publish","type":"post","link":"https:\/\/themespress.ca\/en\/wordpress-table-formidable-form-data\/","title":{"rendered":"WordPress Table: Formidable Form Data"},"content":{"rendered":"
\n\t
\n\t\t
\n\t\t\t

You want to create a new data entry in a custom WordPress table from a Formidable form? Let’s say you want to create a table in order to get data from a form or generate stats. <\/p>\n

Once your table has been created with the required columns, you need to make sure that the columns matches your form’s fields.<\/strong><\/p>\n

If you want to create a table with a function, here’s an interesting article that explains a function that will create a WordPress table<\/strong><\/a><\/p>\n\n\t\t<\/div>\n\t<\/div>\n\n\t

\n\t\t\n\t\t
\n\t\t\t
\"Create<\/div>\n\t\t<\/figure>\n\t<\/div>\n
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\/\/ Create database table\n\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nfunction database_wooclassementstats() {\n\tglobal $wpdb;\n\t$charset_collate = $wpdb->get_charset_collate();\n\t$table_name = $wpdb->prefix . 'wooclassementstats';\n\t\t$sql = "CREATE TABLE $table_name (\n\t\tid mediumint(9) NOT NULL AUTO_INCREMENT,\n\t\tviewdate date DEFAULT '0000-00-00' NOT NULL,\n\t\tviewtime time DEFAULT '00:00:00' NOT NULL,\n\t\tproductid int(11) NOT NULL,\n\t\tproductname varchar(60) NOT NULL,\n\t\tproducturl text NOT NULL,\n\t\tuserip varchar(60) NOT NULL,\n\t\tusername varchar(60) NOT NULL,\n\t\tuserid bigint(20) NOT NULL,\n\t\tusercountry text NOT NULL,\n\t\tusercity varchar(255) NOT NULL,\n\t\tuserbrowser varchar(255) NOT NULL,\n\t\tuserbrowserversion varchar(255) NOT NULL,\n\t\tuserbrowserplateform varchar(255) NOT NULL,\t\n\t\tuserviews smallint(5) NOT NULL,\n\t\tuserclicks smallint(5) NOT NULL,\n\t\turlfrom text NOT NULL,\n\t\ttype varchar(60) DEFAULT 'vue' NOT NULL,\n\t\tlanguage varchar(60) NOT NULL,\n\t\tUNIQUE KEY id (id)\n\t\t) $charset_collate;";\n\trequire_once( ABSPATH . 'wp-admin\/includes\/upgrade.php' );\n\tdbDelta( $sql );\n}\t\nadd_action( 'init', 'database_wooclassementstats');<\/pre><\/div>\n\t
\n\t\t
\n\t\t\t
Here’s our table within phpMyAdmin.<\/strong><\/p>\n\n\t\t<\/div>\n\t<\/div>\n\n\t
\n\t\t\n\t\t
\n\t\t\t
\"Possible<\/div>\n\t\t<\/figure>\n\t<\/div>\n\n\t
\n\t\t
\n\t\t\t
As you can see there are multiple columns in our WordPress table.<\/p>\n
First, change the name of the table, wooclassementstats<\/strong> to the naming convention of your table<\/strong>.<\/p>\n
You’ll also need to replace the columns’ names and adapting them to the data you’re looking for.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n
Adding Formidable fields data<\/h2>\n\t
\n\t\t
\n\t\t\t
For that we’re gonna need the hook Formidable Form<\/strong><\/a> called frm_after_create_entry<\/a><\/p>\n
Within our hook, we will add a condition where it’ll need to fetch data from the form according to the specific form ID.<\/p>\n
The $values<\/strong> variable includes all the data fetched from the form. Change the columns’ names<\/strong> and IDs of the matching fields<\/strong> for each field.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n
add_action('frm_after_create_entry', 'copy_into_my_table', 20, 2);\nfunction copy_into_my_table($entry_id, $form_id){ \n  if($form_id == 2){ \/\/change 4 to the form id of the form to copy\n    global $wpdb;\n    $values = array(\n    'col_name'         => $_POST['item_meta'][24], \n    'col_name'         => $_POST['item_meta'][25], \n    'col_name'         => $_POST['item_meta'][22],\n    'col_name'         => $_POST['item_meta'][21],\n    'col_name'         => $_POST['item_meta'][26],\n    'col_name'         => $_POST['item_meta'][23],\n    'col_name'         => '',\n    'col_name'         => '', \n    'col_name'         => $_POST['item_meta'][27],\n    );\n    \/\/replace 25 and 26 with the field ids of the Formidable form. Change col_name to the column names in your table\n    $wpdb->insert('wpeo_LDAAnalytics', $values); \n  }\n}<\/pre><\/div>
For Multi-sites websites<\/h2>\n\t
\n\t\t
\n\t\t\t
If you have a multisite, first thing you’ll need to do is make sure all forms have their own unique IDs. You will need the switch_to_blog<\/strong><\/a> function.<\/p>\n
Our form’s condition will need to be set between switch_to_blog<\/strong> and restore_current_blog();<\/strong> which will respect the blog’s query.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div>
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ Insert datas after create entry from Form  \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nadd_action('frm_after_create_entry', 'copy_into_my_table', 20, 2);\nfunction copy_into_my_table($entry_id, $form_id){ \n\tswitch_to_blog(2);\n\tif($form_id == 2){ \/\/change 4 to the form id of the form to copy\n\t\tglobal $wpdb;\n\t\t$values = array(\n\t\t'col_name'         => $_POST['item_meta'][24], \n\t\t'col_name'         => $_POST['item_meta'][25], \n\t\t'col_name'         => $_POST['item_meta'][22],\n\t\t'col_name'         => $_POST['item_meta'][21],\n\t\t'col_name'         => $_POST['item_meta'][26],\n\t\t'col_name'         => $_POST['item_meta'][23],\n\t\t'col_name'         => '',\n\t\t'col_name'         => '', \n\t\t'col_name'         => $_POST['item_meta'][27],\n\t\t);\n\t\t\/\/replace 25 and 26 with the field ids of the Formidable form. Change col_name to the column names in your table\n\t\t$wpdb->insert('wpeo_LDAAnalytics', $values); \n\t}\n\trestore_current_blog();\n}<\/pre><\/div>\n\t
\n\t\t
\n\t\t\t
In conclusion, injecting data in a WordPress table will allow you to have duplicates of the data or offering stats to your clients.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"You want to create a new data entry in a custom Wordpress table from a Formidable form? Let's say you want to create a table in order to get data
Read More<\/a><\/div>","protected":false},"author":81,"featured_media":6853,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[283],"tags":[],"class_list":["post-6864","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts\/6864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/users\/81"}],"replies":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/comments?post=6864"}],"version-history":[{"count":0,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts\/6864\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/media\/6853"}],"wp:attachment":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/media?parent=6864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/categories?post=6864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/tags?post=6864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}