Load the next posts ajax

I use the below code to display the first 5 results.

<ul class="category_list_view" id="widget_index_upcomming_events_id">
<?php
global $post,$wpdb;
$post_number = 5;
$category1 = $category;
$today = date('Y-m-d G:i:s');
if($category) {
 $category = "'".str_replace(",","','",$category)."'";
 $where .= "and p.ID in (select tr.object_id from $wpdb->term_relationships tr join $wpdb->term_taxonomy t on t.term_taxonomy_id=tr.term_taxonomy_id where t.term_id in ($category))";
}
$today = date('Y-m-d G:i:s');
@$where .= " AND (p.ID in (select $wpdb->postmeta.post_id from $wpdb->postmeta where $wpdb->postmeta.meta_key='st_date' and date_format($wpdb->postmeta.meta_value,'%Y-%m-%d %G:%i:%s') >'".$today."')) ";

$sql = "select p.* from $wpdb->posts p where p.post_type='".CUSTOM_POST_TYPE1."' and p.post_status='publish' $where order by $orderby limit $post_number";

$latest_menus = $wpdb->get_results($sql);
 if($latest_menus) {

    foreach($latest_menus as $post) :
    setup_postdata($post);
?>
    <li>
    <h3><a href="<?php the_permalink(); ?>"><?php the_title(); ?></a></h3>
        <?php echo get_post_meta($post->ID,'address',true); ?>
    </li>

<?php 
        endforeach;
 } else {
  echo "<p>".UPCOMING_NOT_FOUND_TEXT."</p>";
 } 
?>
</ul>

I wanted to display the next 5 results from the last displayed result of the code above using ajax.

Read More

Adding <a>Load More</a> at the end if there is more than 5 results and add No more results if there is only 5 results. Also, when I click the <a>Load More</a> and there are no more results to display, then replace <a>Load More</a> with <b>No more results</b>

I don’t know how to do ajax with the code above since im not familiar with jquery.

Please help..

Related posts

Leave a Reply