tw_pages_results.php

<?php
add_action( 'init', 'tw_pages_script_enqueuer' );

function tw_pages_script_enqueuer() {
   wp_register_script( "tw_pages_script", WP_PLUGIN_URL.'/tw_page/js/template.js', array('jquery') );
   wp_localize_script( 'tw_pages_script', 'myAjax', array( 'ajaxurl' => admin_url( 'admin-ajax.php' )));

   wp_enqueue_script( 'jquery' );
   wp_enqueue_script( 'tw_pages_script' );

}

add_action("wp_ajax_tw_pages_results", "tw_pages_results");
add_action("wp_ajax_nopriv_tw_pages_results", "tw_pages_results");

function tw_pages_results() {
    if ( !wp_verify_nonce( $_POST['nonce'], "tw_pages_nonce")) {
      exit("No naughty business please");
    }
    global $wpdb;
echo "fghn";
    $plugin_dir = ABSPATH . 'wp-content/plugins/tw_page/';
    include($plugin_dir."includes/TW_Get_Results.class.php");

    //sanitize post value
    $page_number = filter_var($_POST["page"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH);
    $item_per_page = filter_var($_POST["itemsperpage"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH);

    $jackpot = $_POST["jackpot"];
    $playercount = $_POST["playercount"];
    $cost = $_POST["cost"];

    $where = "";
    if(!isset($_POST["catid"])) {
        $where .= "connect.catid = ".$_POST["catid"];
    }

    if(!isset($_POST["orderby"])) {
        $orderby = "order";
    } else {
        $orderby = $_POST["orderby"];
    }

    if(!isset($_POST["asc_dec"])) {
        $asc_dec = "ASC";
    } else {
        $asc_dec = $_POST["asc_dec"];
    }

    //validate page number is really numaric
    if(!is_numeric($page_number)){die('Invalid page number!');}

    //get current starting point of records
    $position = ($page_number * $item_per_page);

    if(!empty($_POST["catid"])) {
        $TW_Get_Results_class = new TW_Get_Results($wpdb->prefix."tw_page_items AS items",
                                                   "$where",
                                                   "$orderby",
                                                   "$asc_dec",
                                                   "$position, $item_per_page",
                                                   "items.id AS id, items.title AS title, items.img AS img, items.url AS url, items.jackpot AS jackpot, items.playercount AS playercount, items.cost AS cost, items.order AS `order`, connect.catid AS catid",
                                                   $wpdb->prefix."tw_page_connectors AS connect ON connect.itemid = items.id");
        $get_rows = $TW_Get_Results_class->tw_get_rows_leftjoin();
    } else {
        $TW_Get_Results = new TW_Get_Results("tw_page_items", "", "order", "ASC", "$position, $item_per_page");
        $results = $TW_Get_Results->tw_get_rows();
    }

    ?>
    <ul class="page_result">
        <?php
        foreach($results AS $row)
        {
        ?>
            <li id="item_<?php echo $row->id; ?>"><span class="page_name"><?php echo $row->title; ?></span></li>
        <?php
        }
        ?>
    </ul>
<?php
die();
}
?>