Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Функция создания таблицы в БД если она отсутствует
- function create_table() {
- global $wpdb;
- require_once ABSPATH . 'wp-admin/includes/upgrade.php';
- $table_name = $wpdb->get_blog_prefix() . 'applications';
- $charset_collate = "DEFAULT CHARACTER SET {$wpdb->charset} COLLATE {$wpdb->collate}";
- if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) {
- $sql = "CREATE TABLE {$table_name} (
- id int NOT NULL auto_increment,
- name varchar(30) NOT NULL default '',
- email varchar(100) NOT NULL UNIQUE,
- phone varchar(11) NOT NULL default '',
- message text NOT NULL default '',
- product_id int NOT NULL default '',
- status int NOT NULL default '',
- comment text NOT NULL default '',
- created_at datetime NOT NULL default '',
- updated_at datetime NOT NULL default '',
- PRIMARY KEY (id)
- )
- {$charset_collate};";
- dbDelta($sql);
- }
- }
- create_table();
Advertisement
Add Comment
Please, Sign In to add comment