Use this below code it will work as I have used this and working fine at my end.
<?php
$querystr = "
SELECT * FROM $wpdb->posts
LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
LEFT JOIN $wpdb->terms ON($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)
WHERE $wpdb->terms.slug = 'branding'
AND $wpdb->term_taxonomy.taxonomy = 'taxonomy_name'
AND $wpdb->posts.post_status="publish"
AND $wpdb->posts.post_type="ce_project"
ORDER BY $wpdb->posts.post_date DESC";
$result1 = $wpdb->get_results($querystr);
$totalPosts = count($result1);
$querystr2 = "
SELECT * FROM $wpdb->posts
LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
LEFT JOIN $wpdb->terms ON($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)
WHERE $wpdb->terms.slug = 'branding'
AND $wpdb->term_taxonomy.taxonomy = 'taxonomy_name'
AND $wpdb->posts.post_status="publish"
AND $wpdb->posts.post_type="ce_project"
ORDER BY $wpdb->posts.post_date DESC LIMIT 0,6";
$result2 = $wpdb->get_results($querystr2);
foreach($result2 as $post){
echo '<h2 class="search-item__title">'.get_the_title($post->ID).'</h2>';
}
?>
<input type="hidden" id="row" value="0" />
<input type="hidden" id="all" value="<?php echo $totalPosts; ?>" />
<input type="hidden" id="taxonomy" value="taxonomy_name" />
<input type="hidden" id="term_id" value="branding" />
<div class="loader" style="display:none;"><img src="<?php echo get_template_directory_uri(); ?>/images/loader-fading.gif" alt="loading.." /></div>
<script>
$(document).ready(function(){
//alert('dfd');
$(window).scroll(function(){
var position = $(window).scrollTop() + 1;
var bottom = $(document).height() - $(window).height();
console.log('Position: '+position);
console.log('Bottom: '+bottom);
if( position > bottom ){
var row = Number($('#row').val());
var allcount = Number($('#all').val());
var taxonomy = $('#taxonomy').val();
var term_id = $('#term_id').val();
var rowperpage = 10;
row = row + rowperpage;
if(row <= allcount){
$('#row').val(row);
jQuery(".loader").css('display','block');
row = "row=" + row + "&cat_name=" + taxonomy + "&cat_id=" + term_id + "&action=get_archive";
$.ajax({
type: 'POST',
url: '<?php echo admin_url( 'admin-ajax.php' ); ?>',
data: row,
success: function(response){
//console.log(response);
setTimeout(function(){
$(".search-item:last").after(response).show().fadeIn("slow");
$(".loader").css('display','none');
}, 1000);
}
});
}
}
});
});
</script>
<?php
// copye and paste the below function in functions.php file.
// AJAX request for auto load listing
function get_archive(){
global $wpdb;
$html="";
$row = $_POST['row'];
$cat_name = $_POST['cat_name'];
$cat_id = $_POST['cat_id'];
$rowperpage = 6;
$querystr2 = "
SELECT * FROM $wpdb->posts
LEFT JOIN $wpdb->term_relationships ON($wpdb->posts.ID = $wpdb->term_relationships.object_id)
LEFT JOIN $wpdb->term_taxonomy ON($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
LEFT JOIN $wpdb->terms ON($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)
WHERE $wpdb->terms.slug = '".$cat_id."'
AND $wpdb->term_taxonomy.taxonomy = '".$cat_name."'
AND $wpdb->posts.post_status="publish"
AND $wpdb->posts.post_type="ce_project"
ORDER BY $wpdb->posts.post_date DESC LIMIT ".$row.",".$rowperpage."";
$result2 = $wpdb->get_results($querystr2);
// Check form ajax action
if($_POST['action'] == 'get_archive')
{
foreach($result2 as $post){
$html .= '<h2 class="search-item__title">'.get_the_title($post->ID).'</h2>';
}
echo $html;
}
else
{
echo "error";
}
exit;
}
add_action( 'wp_ajax_get_archive', 'get_archive' );
add_action( 'wp_ajax_nopriv_get_archive', 'get_archive' );
?>