Create New Table - mdhemalakhand1999/WordPressPluginDevelopment GitHub Wiki

define("WPDEMO_DB_VERSION", "1.0");

function dbdemo_init() {
    // for deal with db we need first get $wpdb variable
    global $wpdb;
    // get wp table prefix
    $table_name = $wpdb->prefix. "persons";
    // sql query for create table and field
    $sql = "CREATE TABLE {$table_name} (
        id INT NOT NULL AUTO_INCREMENT,
        name VARCHAR(250),
        email VARCHAR(250),
        PRIMARY KEY(id)
    )";
    require_once (ABSPATH. 'wp-admin/includes/upgrade.php');
    dbDelta($sql);
}
register_activation_hook(__FILE__, 'dbdemo_init');