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();
}
