Passing dynamic values through ajax

Question

I hav this code in jquery which is written in such a way that when i scroll down my mouse next set of records are fetched from db and displayed. Initially my page shows 25 records, and when i scroll down next 15 records r fetched from db. My problem is that i am not able set a counter and increment the counter whenever scroll function is called. And also when ever i scroll down same 15 records r displayed. This is my code...

$(window).on('scroll',function(){
  if($(window).scrollTop()==($(document).height()-$(window).height())){

    $.ajax({
        type: 'POST',
        url: 'getdata.php',
        success: function(nxt_data){
           $('#data').append(nxt_data);
        }
    });
  } 
});

Adam Merrifield · Accepted Answer · 2013-01-12 07:08:28Z

2

Create a page variable and then add to it everytime the ajax is called.

var page = 1;
$(window).on('scroll', function () {
  if ($(window).scrollTop() == ($(document).height() - $(window).height())) {
    page++;

    $.ajax({
      type: 'POST',
      data: 'page=' + page,
      url: 'getdata.php',
      success: function (nxt_data) {
        $('#data').append(nxt_data);
      }
    });
  }
});

answered Jan 12, 2013 at 7:08

Adam Merrifield

10.4k4 gold badges45 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

PassKit · Accepted Answer · 2013-01-12 07:39:52Z

1

Your issue appears to be because getdata.php has no way of knowing what records to return, so it is just returning the same 15 rows.

var counter=25;

$(window).on('scroll',function(){
  if($(window).scrollTop()==($(document).height()-$(window).height())){

    $.ajax({
        type: 'GET',
        url: 'getdata.php?start_row=' + counter,
        success: function(nxt_data){
           $('#data').append(nxt_data);
           counter += 15;
        }
    });
  } 
});

In your PHP file you can access the counter variable using $_GET['start_row'];

edited Jan 12, 2013 at 7:39

answered Jan 12, 2013 at 7:10

PassKit

12.6k5 gold badges60 silver badges78 bronze badges

Collectives™ on Stack Overflow

Passing dynamic values through ajax

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related