doushua7737 2018-07-20 08:53
浏览 72
已采纳

使用预设值初始化第一个ajax数据,然后从成功响应中传递它

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

<script>
        $(document).ready(function () {
            var lastID = 0;
            function getData() {
                $.ajax({
                    type: 'GET',
                    url: 'data.php',
                    data: {lastID: lastID},
                    dataType: 'json',
                    success: function (data) {
                        lastID = data[0].id;
                        console.log(lastID);
                            $.each(data, function (i, item) {
                                var $tr = $('<tr>').append(
                                        $('<td>').text(item.id),
                                        $('<td>').text(item.name),
                                        $('<td>').text(item.details)
                                        ).appendTo('#output');
                            });



                    }
                });
            }


            getData();


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

        });
    </script>

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条回答 默认 最新

  • douzhang1955 2018-07-20 09:01
    关注

    Where does your $lastID variable come from, how is it defined?

    It looks like you are not getting the correct value from the $_GET array.

    What you should do to both solve that problem and the sql injection problem you have, is switch to a prepared statement:

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

    And bind $_GET['lastID'] to the placeholder before / during the execution of your query (depending on whether you are using mysqli or PDO).

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥55 AD844 howland电流源如何驱动大额负载
  • ¥15 C++ /QT 内存权限的判断函数列举
  • ¥15 深度学习GFnet理解问题
  • ¥15 单细胞小提琴堆叠图代码
  • ¥50 升级strust2版本到2.3.15.1后使用ognl3.0.6.jar windows环境中没有问题,但部署到linux环境报错
  • ¥15 vue页面,node封装接口
  • ¥15 求TMS320F280039C工程模板!
  • ¥15 delphi+fastreport实现分组补空打印问题
  • ¥15 使用python把两台mysql数据库服务器数据导出和导入
  • ¥15 NodeBB论坛配置Apache Solr中文搜索引擎的详细教程