Create Table In WordPress Plugin

<?php
function table_create()
{
global $wpdb;
$table_name = $wpdb->prefix . "wpactable";
$charset_collate = $wpdb->get_charset_collate();
 $sql = "CREATE TABLE IF NOT EXISTS $table_name (
 id mediumint(9) NOT NULL AUTO_INCREMENT,
 name tinytext NOT NULL,
 email tinytext NOT NULL,
 number tinytext NOT NULL,
 Website text NOT NULL,
 PRIMARY KEY (id)
) $charset_collate";
require_once( ABSPATH .'wp-admin/includes/upgrade.php' );
dbDelta( $sql );
}

?>

Leave a Comment