带有DataTable服务器端处理的Wordpress自定义数据库表

function create_custom_table() {
    global $wpdb;
    $table_name = $wpdb->prefix . 'custom_table';

    if ($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) {
        $charset_collate = $wpdb->get_charset_collate();

        $sql = "CREATE TABLE $table_name (
            id mediumint(9) NOT NULL AUTO_INCREMENT,
            name varchar(50) NOT NULL,
            email varchar(100) NOT NULL,
            PRIMARY KEY (id)
        ) $charset_collate;";

        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
        dbDelta($sql);
    }
}
register_activation_hook(__FILE__, 'create_custom_table');

<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.25/css/jquery.dataTables.min.css">
<script type="text/javascript" src="https://cdn.datatables.net/1.10.25/js/jquery.dataTables.min.js"></script>

$(document).ready(function() {
    $('#custom-table').DataTable({
        "processing": true,
        "serverSide": true,
        "ajax": {
            "url": ajaxurl, // WordPress AJAX URL
            "type": "POST",
            "data": function (d) {
                d.action = 'custom_table_ajax_handler';
            }
        },
        "columns": [
            { "data": "id" },
            { "data": "name" },
            { "data": "email" }
        ]
    });
});

function custom_table_ajax_handler() {
    global $wpdb;
    $table_name = $wpdb->prefix . 'custom_table';

    $request = $_REQUEST;
    $columns = array(
        0 => 'id',
        1 => 'name',
        2 => 'email'
    );

    $sql = "SELECT * FROM $table_name WHERE 1=1";
    if (isset($request['search']['value'])) {
        $sql .= " AND (name LIKE '%" . esc_sql($request['search']['value']) . "%' OR email LIKE '%" . esc_sql($request['search']['value']) . "%')";
    }

    if (isset($request['order'][0]['column'])) {
        $sql .= " ORDER BY " . $columns[$request['order'][0]['column']] . " " . esc_sql($request['order'][0]['dir']);
    }

    if ($request['length'] != -1) {
        $sql .= " LIMIT " . esc_sql($request['start']) . ", " . esc_sql($request['length']);
    }

    $data = $wpdb->get_results($sql, ARRAY_A);
    $json = array();

    foreach ($data as $row) {
        $json[] = array(
            'id' => $row['id'],
            'name' => $row['name'],
            'email' => $row['email']
        );
    }

    echo json_encode(array(
        "draw" => intval($request['draw']),
        "recordsTotal" => $wpdb->get_var("SELECT COUNT(*) FROM $table_name"),
        "recordsFiltered" => $wpdb->get_var($sql),
        "data" => $json
    ));

    wp_die();
}
add_action('wp_ajax_custom_table_ajax_handler', 'custom_table_ajax_handler');
add_action('wp_ajax_nopriv_custom_table_ajax_handler', 'custom_table_ajax_handler');