wordpress plugin create table on activation

WordPress plugin tutorial, wordpress plugin create table on activation, If you are making plugin and in plugin many times we need to create new tables. In this article I will show you how easily we can create the wordpress plugin.

wordpress plugin create table on activation

Using following code you can create the table in wordpress database.

01global $jal_db_version;
02$jal_db_version = "1.0";
03 
04function jal_install () {
05   global $wpdb;
06   global $jal_db_version;
07 
08   $table_name = $wpdb->prefix . "liveshoutbox";
09   if($wpdb->get_var("show tables like '$table_name'") != $table_name) {
10 
11      $sql = "CREATE TABLE " . $table_name . " (
12      id mediumint(9) NOT NULL AUTO_INCREMENT,
13      time bigint(11) DEFAULT '0' NOT NULL,
14      name tinytext NOT NULL,
15      text text NOT NULL,
16      url VARCHAR(55) NOT NULL,
17      UNIQUE KEY id (id)
18    );";
19 
20      require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
21      dbDelta($sql);
22 
23      $rows_affected = $wpdb->insert( $table_name, array( 'time' => current_time('mysql'), 'name' => $welcome_name, 'text' => $welcome_text ) );
24 
25      add_option("jal_db_version", $jal_db_version);
26 
27   }
28}

Now that we have the initialization function defined, we want to make sure that WordPress calls this function when the plugin is activated by a WordPress administrator. To do that, we will use the activate_ action hook. If your plugin file is wp-content/plugins/plugindir/pluginfile.php, you’ll add the following line to the main body of your plugin:

`1`	`register_activation_hook(__FILE__,'jal_install');`

Published by

Purab

I am Purab from India, Software development is my profession and teaching is my passion. Programmers blog dedicated to the JAVA, Python, PHP, DevOps and Opensource Frameworks. Purab's Github Repo Youtube Chanel Video Tutorials Connect to on LinkedIn View all posts by Purab