如何在ajax中添加分页结果是wordpress

我想分页我的ajax搜索结果在ajax分页可以任何人帮助分页这我试图搜索谷歌但我没有找到任何东西 . 我发现了更多关于wp_query的信息，但这个数据不适合我，因为我不使用帖子

我在函数.php中的ajax函数用于从表中获取数据：

add_action( 'wp_ajax_search_ajax_call', 'search_ajax_call' ); 
add_action( 'wp_ajax_nopriv_search_ajax_call', 'search_ajax_call' );

function search_ajax_call(){
$country=$_POST['country'];
$date_start=$_POST['date_start'];
$date_end=$_POST['date_end'];
$wm=$_POST['wm'];

if ($country) {
    $searchkeys.=" AND country='".$country."'";
}
if ($date_start) {
    $searchkeys.=" AND date_start>".$date_start;
}if ($date_end) {
    $searchkeys.=" AND date_end<".$date_end;
}if ($wm) {
    $searchkeys.=" AND wm='".$wm."'";
}
 global $wpdb;
$query = "SELECT fe.id, fe.form_id,fe.datestamp, fe.status, MAX(CASE WHEN fev.slug = 'avatar' THEN fev.value END) as avatar, MAX(CASE WHEN fev.slug = 'user_name' THEN fev.value END) as user_name, MAX(CASE WHEN fev.slug = 'message' THEN fev.value END) as message, MAX(CASE WHEN fev.slug = 'date_end' THEN fev.value END) as date_end, MAX(CASE WHEN fev.slug = 'date_start' THEN fev.value END) as date_start, MAX(CASE WHEN fev.slug = 'country' THEN fev.value END) as country, MAX(CASE WHEN fev.slug = 'tel' THEN fev.value END) as tel, MAX(CASE WHEN fev.slug = 'email' THEN fev.value END) as email, MAX(CASE WHEN fev.slug = 'age' THEN fev.value END) as age, MAX(CASE WHEN fev.slug = 'city' THEN fev.value END) as city, MAX(CASE WHEN fev.slug = 'wm' THEN fev.value END) as wm FROM wp_cf_form_entries fe INNER JOIN wp_cf_form_entry_values fev ON fev.entry_id = fe.id GROUP BY fe.id, fe.form_id, fe.status HAVING fe.id>'0' ".$searchkeys."";

$items_per_page = 10;
$page = isset( $_GET['cpage'] ) ? abs( (int) $_GET['cpage'] ) : 1;
$offset = ( $page * $items_per_page ) - $items_per_page;
$total_query = "SELECT COUNT(1) FROM (${query}) AS combined_table";
$total = $wpdb->get_var( $total_query );
$result = $wpdb->get_results( $query.' ORDER BY id DESC LIMIT '. $offset.', '. $items_per_page, OBJECT );
if (!$result) {
    echo "Нет результатов";
}
   foreach( $result as $results ) {

if ( $post = get_page_by_path( $results->country, OBJECT, 'country' ) )
    $id = $post->ID;
else
    $id = 0;

?>
<style type="text/css">
    #searchresults .row div{
        font-size: 20px;
        line-height: 1.5;
        color:  white;
    }
    #searchresults img {
        max-height: 250px;
    }
</style>
<div class="row ">
    <div class="col-md-6 col-sm-12 data-traveler">
        <div><span>Имя: </span><?=$results->user_name;?></div>
        <div><span>Возвраст: </span><?=$results->age;?></div>
        <div><span>Ищет попутчика(Пол): </span><?=$results->wm;?></div>
        <div><span>Страна отдыха: </span><?=get_the_title($id);?></div>
        <div><span>Дата поездки: </span><?=$results->date_start;?></div>
        <div><span>Email: </span><?=$results->email;?></div>
        <div><span>Тел: </span><?=$results->tel;?></div>
        <div><span>Cообщение: </span><?=$results->message;?></div>
    </div>
    <div class="col-md-6 col-sm-12"><img src="<?=$results->avatar;?>"></div>
    <div class="col-md-12 col-sm-12 data-traveler">
        <div class="date"><span>Дата размещение: </span><?=$results->datestamp;?></div>
    </div>
</div>
 <?php


   }
echo paginate_links( array(
                        'base' => add_query_arg( 'cpage', '%#%' ),
                        'format' => '',
                        'prev_text' => __('&laquo;'),
                        'next_text' => __('&raquo;'),
                        'total' => ceil($total / $items_per_page),
                        'current' => $page
                    ));


    die; // даём понять, что обработчик закончил выполнение
}

我从jp-admin-ajax.php调用ajax函数的javascript：

<script>

jQuery(function($){
    $('#fld_551620_1').click(function(){
        $('#searchresults').html('');

        var country = document.getElementById("fld_8091734_1");
    var date_start =$('#fld_7900131_1').val();
    var date_end =$('#fld_6539646_1').val();
    var wm =$( "input[name='fld_3061011']:checked" ).val();
        $.ajax({
            url:"<?php bloginfo('wpurl'); ?>/wp-admin/admin-ajax.php",     
            type: 'POST', 
            data: {
    action:'search_ajax_call',
    country: country.options[country.selectedIndex].value,
    date_start: date_start,
    date_end: date_end,
    wm: wm,
},
beforeSend: function() {
        $('#loader').show();
    },
    complete: function() {
        $('#loader').hide();
    },
            success: function( data ) {
                $('#searchresults').html(data); 
            }
        });
        // если элемент – ссылка, то не забываем:
        // return false;
    });
});


</script>