停用插件时如何删除2个表

Question

我在 wordpress 中创建了一个插件，当插件被激活时，以下代码在 db 中创建了 2 个表。如何在停用插件时删除这两个表？register_deactivation 挂钩只删除了第一个表，第二个表在 db 中。我需要在停用插件时删除这两个表，如何编写代码function wnm_install() {    global $wpdb, $wnm_db_version;    $sql = array();    //sms table    $sms_table = $wpdb->prefix . "smsfactory";    if( $wpdb->get_var("show tables like '". $sms_table . "'") !== $sms_table ) {         $sql[] = "CREATE TABLE ". $sms_table . "     (        SfID int(11) NOT NULL AUTO_INCREMENT,        sf_name varchar(128) NOT NULL,        start_duration date NOT NULL,        end_duration date NOT NULL,        activity varchar(500) NOT NULL,        survey_settings varchar(50) NOT NULL,        `limit` varchar(50) NOT NULL,        goal varchar(100) DEFAULT NULL,        PRIMARY KEY  (SfID)        ) ";    }    //sms messages table    $sms_message_table = $wpdb->prefix . "smsfactorymessagetemplate";    if( $wpdb->get_var("show tables like '". $sms_message_table . "'") !== $sms_message_table ) {         $sql[] = "CREATE TABLE ". $sms_message_table . "   (        sfID int(11) NOT NULL AUTO_INCREMENT,        sftemplate_name varchar(256) NOT NULL,        sftemplate_type varchar(128) NOT NULL,        PRIMARY KEY  (sfID)        ) ";    }    if ( !empty($sql) ) {        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');        dbDelta($sql);        add_option("wnm_db_version", $wnm_db_version);    }}register_deactivation_hook(__FILE__, 'on_deactivate' );function on_deactivate()  {    global $wpdb; $sql = "DROP TABLE IF EXISTS techies_datachecker"; $wpdb->query($sql);    delete_option("my_plugin_db_version");}

Answer 1

您需要将表添加到数组中。试试下面的代码：

function on_deactivate() {

    global $wpdb;

    $tables = array(

        $wpdb->prefix . "smsfactory", 

        $wpdb->prefix . "smsfactorymessagetemplate"

    );

    foreach ( $tables as $table ) {

        $sql = "DROP TABLE IF EXISTS $table";

        $wpdb->query($sql);

    }

    delete_option("my_plugin_db_version");

}

register_deactivation_hook( __FILE__, 'on_deactivate'  );

希望能帮到你。

Answer 2

function delete_tbl_from_db(){

    global $wpdb;

    $tbl_array = [   

      $wpdb->prefix . "first_table",

      $wpdb->prefix . "second_table",

  ];

  foreach ($tbl_array as $tbl_name) {

     $wpdb->query("DROP TABLE IF EXISTS $tbl_name");

  }

}

register_uninstall_hook(__FILE__, 'delete_tbl_from_db');

Please check above code.

Answer 3

function delete_tbl_from_db(){

    global $wpdb;

    $tbl_array = [

        $wpdb->prefix . "smsfactory",

        $wpdb->prefix . "smsfactorymessagetemplate",

    ];

    foreach ($tbl_array as $tbl_name) {

     $wpdb->query("DROP TABLE IF EXISTS $tbl_name");

    }

}

register_deactivation_hook( __FILE__, 'delete_tbl_from_db' );

This is working on my site. Please check it