Wordpress install and uninstall plugin table during activation and deactivation of plugin

<?php
/*

Plugin Name: sample plugin

Plugin URI: http://URI_Of_Page_Describing_Plugin_and_Updates

Description: This plugin is used to add youtube embeded video code and show video in widgets.

Version: 2.1

Author: Arunendra Pratap Rai

Author URI: http://URI_Of_The_Plugin_Author

License: A "Slug" license name e.g. GPL2

*/

register_activation_hook(__FILE__,'pro_install'); // table installation hook

register_deactivation_hook(__FILE__ , 'pro_uninstall' ); //table uninstallation hook

function pro_install()

{

    global $wpdb;

    $table = wp_."table_name";

    $structure = "CREATE TABLE $table (

        id INT(9) NOT NULL AUTO_INCREMENT,

        fname VARCHAR(255) NOT NULL,

        lname VARCHAR(255) NOT NULL,

      


    UNIQUE KEY id (id)

    );";

    $wpdb->query($structure);

      // Populate table

    $wpdb->query("INSERT INTO $table(id,fname,lname)

        VALUES('1', 'arunendra','Pratap rai')");


}

function pro_uninstall()

{

    global $wpdb;

    $table = wp_."table_name";

    $structure = "drop table if exists $table";

    $wpdb->query($structure); 

}
?>

No comments:

Post a Comment