function clean_data($type) { global $wpdb; switch ($type) { case 1: $delete = new delete_data(); $where = array(); $where["post_status"] = "auto-draft"; $delete->delete_revision($where); break; case 2: $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s OR option_name LIKE %s OR option_name LIKE %s", "_site_transient_browser_%", "_site_transient_timeout_browser_%", "_transient_feed_%", "_transient_timeout_feed_%")); break; case 3: $delete = new delete_data(); $where = array(); $where["post_status"] = "draft"; $delete->delete_revision($where); break; case 5: $wpdb->query("DELETE FROM {$wpdb->commentmeta} WHERE comment_id NOT IN (SELECT comment_id FROM {$wpdb->comments})"); break; case 6: $wpdb->query("DELETE pm FROM {$wpdb->postmeta} pm LEFT JOIN {$wpdb->posts} wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL"); break; case 7: $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->term_relationships} WHERE term_taxonomy_id=%d AND object_id NOT IN (SELECT id FROM {$wpdb->posts})", 1)); break; case 8: $delete = new delete_data(); $where = array(); $where["post_type"] = "revision"; $delete->delete_revision($where); break; case 9: $delete = new delete_data(); $where = array(); $where["comment_type"] = "pingback"; $delete->delete_comments($where); break; case 10: $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s", "_transient_%", "_site_transient_%")); break; case 11: $delete = new delete_data(); $where = array(); $where["comment_type"] = "trackback"; $delete->delete_comments($where); break; case 12: $delete = new delete_data(); $where = array(); $where["comment_approved"] = "spam"; $delete->delete_comments($where); break; case 13: $delete = new delete_data(); $where = array(); $where["comment_approved"] = "trash"; $delete->delete_comments($where); break; } }
<?php require "data_operate.php"; if ($_REQUEST['operate_type'] === "delete") { //创建操作对象 $request = new delete_data($_REQUEST['id'], $_REQUEST['table_name']); //连接数据库 $request->connect_database(); //执行sql代码 $request->query(); //查询并返回最新状态 echo $request->select_new_data(); //关闭数据库连接 $request->close(); }