make database table when plugin install

 

  Make database table:-

//====================activation and database table create ====================

function custom_plugin_create_table(){

global $wpdb;

require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );

$sql = "CREATE TABLE `wp_custom_table` (

`id` int(11) NOT NULL,

`name` varchar(255) NOT NULL,

`email` varchar(255) NOT NULL,

`address` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

";

dbDelta( $sql );

}

register_activation_hook(__FILE__, 'custom_plugin_create_table');

//ei code tuku use korle database e table create hobe jokhon plugin active kora hobe.