tw_page.php

<?php
/*
Template Name: TW Page Template
*/
$plugin_dir = ABSPATH . 'wp-content/plugins/tw_page/';
include($plugin_dir."includes/TW_Get_Results.class.php");

function tw_pages_scripts() {
    $pluginurl = plugins_url().'/tw_page/';

    wp_enqueue_script( 'tw_pages_script', $pluginurl . 'js/template.js');
}

add_action( 'wp_enqueue_scripts', 'tw_pages_scripts' );

$tw_pages_nonce = wp_create_nonce("tw_pages_nonce");

include("tw_pages_results.php");

$item_per_page = 8;

$TW_Get_Cat_Results_class = new TW_Get_Results($wpdb->prefix."tw_page_categories", "", "order", "ASC", "");
$get_cats = $TW_Get_Cat_Results_class->tw_get_rows();

$catid_options = "";
foreach($get_cats AS $cats) {
    $catid_options .= "<option value='".$cats->id."'>".$cats->title."</option>";
}

$TW_Get_Results = new TW_Get_Results("tw_page_items", "", "", "", "");
$get_total_rows = $TW_Get_Results->tw_get_row_count();

$pages = ceil($get_total_rows[0]/$item_per_page);

$pagination = '';
if($pages > 1)
{
    $pagination .= '<ul class="paginate">';
    for($i = 1; $i<$pages; $i++)
    {
        $pagination .= '<li><a href="#" class="paginate_click" id="'.$i.'-page">'.$i.'</a></li>';
    }
    $pagination .= '</ul>';
}

get_header(); ?>

    <div id="primary" class="content-area">
        <div id="content" class="site-content">
            <input type="hidden" name="itemsperpage" value="<?php echo $item_per_page; ?>" />
            <input type="hidden" name="nonce" value="<?php echo $tw_pages_nonce; ?>" />

            <div>
                <div><?php echo $pagination; ?></div>
                <div>
                    <span>Sort By: </span>
                    <select name="sortby">
                        <option value="order" selected="selected">Order</option>
                        <option value="jackpot">Jackpot</option>
                        <option value="playercount">Player Count</option>
                        <option value="cost">Cost</option>
                    </select>

                    <span>Category: </span>
                    <select name="catid">
                        <option value="" selected="selected">All</option>
                        <?php echo $catid_options; ?>
                    </select>

                    <span>ASC/DESC: </span>
                    <select name="asc_dec">
                        <option value="ASC" selected="selected">Ascending</option>
                        <option value="DESC">Descending</option>
                    </select>
                </div>
            </div>
            <div id="results"></div>

        </div>
    </div>

<?php get_sidebar(); ?>

<script type="text/javascript">
jQuery(document).ready(function() {
    jQuery.ajax({
        type : "post",
        dataType : "html",
        url : "<?php echo site_url(); ?>/wp-admin/admin-ajax.php",
        data : {action : "tw_pages_results", 'page':0, 'itemsperpage':<?php echo $item_per_page; ?>, nonce: "<?php echo $tw_pages_nonce; ?>"},
        success: function(response) {
            jQuery("#results").html(response);
            jQuery("#1-page").addClass('active');
        }
    });
});
</script>

<?php get_footer(); ?>