/** * Action for generating a WP-based MySQL query */ function wpdatatables_generate_mysql_based_query() { global $wpdb; $table_data = $_POST['table_data']; $table_data = apply_filters('wpdatatables_before_generate_mysql_based_query', $table_data); // Create a new Constructor object $constructor = new wpDataTableConstructor(); // Generate and return a new 'Manual' type table $constructor->generateMySQLBasedQuery($table_data); $result = array('query' => $constructor->getQuery(), 'preview' => $constructor->getQueryPreview()); echo json_encode($result); exit; }