· 6 years ago · Jun 26, 2019, 11:16 PM
1<?php
2$cr_table_array = array(
3array(
4'data_field' => "id",
5'data_type' => "mediumint(12) NOT NULL AUTO_INCREMENT"
6),
7array(
8'data_field' => "your_name",
9'data_type' => "varchar(200) NOT NULL"
10),
11array(
12'data_field' => "your_eamil",
13'data_type' => "varchar(200) NOT NULL"
14)
15);
16
17
18global $wpdb;
19$sql = "CREATE TABLE IF NOT EXISTS " . $wpdb->prefix.'credofy_contact_form'. " (
20foreach($cr_table_array as $file) {
21 echo $file['data_field'] .' '. $file['data_type'].' '
22 }
23 PRIMARY KEY (id));";
24$wpdb->query($sql);
25require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
26dbDelta($sql);
27echo $sql;
28?>