Guest User

Untitled

a guest
Sep 15th, 2020
24
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. // Функция создания таблицы в БД если она отсутствует
  2. function create_table() {
  3. global $wpdb;
  4.  
  5. require_once ABSPATH . 'wp-admin/includes/upgrade.php';
  6.  
  7. $table_name = $wpdb->get_blog_prefix() . 'applications';
  8. $charset_collate = "DEFAULT CHARACTER SET {$wpdb->charset} COLLATE {$wpdb->collate}";
  9.  
  10. if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) {
  11. $sql = "CREATE TABLE {$table_name} (
  12. id int NOT NULL auto_increment,
  13. name varchar(30) NOT NULL default '',
  14. email varchar(100) NOT NULL UNIQUE,
  15. phone varchar(11) NOT NULL default '',
  16. message text NOT NULL default '',
  17. product_id int NOT NULL default '',
  18. status int NOT NULL default '',
  19. comment text NOT NULL default '',
  20. created_at datetime NOT NULL default '',
  21. updated_at datetime NOT NULL default '',
  22. PRIMARY KEY (id)
  23. )
  24. {$charset_collate};";
  25.  
  26. dbDelta($sql);
  27. }
  28. }
  29.  
  30. create_table();
Advertisement
Add Comment
Please, Sign In to add comment