2018-07-20 08:53
浏览 72


How can I initialize the lastID in jquery only first time with the value 0 because var lastID = 0; does not work.

I have this ajax script in index.php

        $(document).ready(function () {
            var lastID = 0;
            function getData() {
                    type: 'GET',
                    url: 'data.php',
                    data: {lastID: lastID},
                    dataType: 'json',
                    success: function (data) {
                        lastID = data[0].id;
                            $.each(data, function (i, item) {
                                var $tr = $('<tr>').append(



            setInterval(function () {
            }, 10000);  // it will refresh your data every 10 seconds


This is the url: 'data.php' :

$sql = "select * from oders where id > ".$lastID." ORDER BY id DESC"; ... echo json_encode($dataArray);

With this query I get 0 results, and in console (console.log(lastID);) I have no data.

If I change the query like this :

$sql = "select * from oders where id > 0 ORDER BY id DESC";

In console.log(lastID); I get the correct last id. And in html I get the correct data and every 10 seconds it keeps adding same results over and over again.

I can't figure out how to initialize lastID first time as 0 (or the last ID in the database), and on every 10 seconds refresh, take the last ID from the ajax success data.

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

1条回答 默认 最新

相关推荐 更多相似问题