dsxi70423 2013-12-31 12:39
浏览 44
已采纳

将AJAX查询结果的每个值存储到Javascript变量

Here's a jQuery-ajax function that returns some data from a php file.

$('.up').click(function() {
    var act = $('.active').val();

    $.ajax({
        type: "POST",
        url: "database.php",
        data: {
            value: act
        }
    }).done(function(result) {
        $('#msg').html(result)
    });
});

I get the array result of the query. I have no problem with.

PHP Result :

array(2) {
  [0]=> array(2) { ["Label"]=> string(3) "Group1" ["Count"]=> string(1) "244" }
  [1]=> array(2) { ["Status"]=> string(7) "Group2" ["Count"]=> string(1) "125" }
}

Actual query result is this.

Label   Count
Group1  244
Group2  125

Now that I get the result. I wanted to store the numbers of the Count column to two different javascript variables.

So far I tried with this.

var value1 = "<?php echo htmlentities($data[0]['Count']) ?>";
var value2 = "<?php echo htmlentities($data[1]['Count']) ?>";

Tried replacing with the above piece of code with result in the ajax call.

But when I did this the click event itself was not triggered.

I've saved the numbers to two php variables namely value1 and value2.

And in the result of the ajax call i get the result like 244125.

Help me saving that number to two different javascript variables.

  • 写回答

1条回答 默认 最新

  • doule6314 2013-12-31 14:00
    关注

    I am assuming you are going to do something with this data so you'll need to know what you are looking for.

    Get your PHP to serve up JSON with keys like so:

    {"Bob": "24", "Sue": "12"}
    

    This way you can access the information you need or just loop through the whole lot. I've made a little fiddle which I am hoping will help you understand.

    Ultimately you simply want to use the jQuery $.getJSON to pull the information and then deal with it however you please.

    http://jsfiddle.net/PgVkL/

    If you need PHP to output in the format you specified then you can do:

    $people = array("24", "12", "16", "48");
    var_dump(json_encode($people));
    

    Here's the docs: http://uk3.php.net/json_encode

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

报告相同问题?

悬赏问题

  • ¥50 用logisim设计16位单时钟周期cpu
  • ¥15 IDEA中圈复杂度如何具体设置
  • ¥50 labview采集不了数据
  • ¥15 请上面代码做什么处理或什么混淆
  • ¥15 英雄联盟自定义房间置顶
  • ¥15 W5500网线插上无反应
  • ¥15 如何用字典的Key,显示在WPF的xaml中
  • ¥15 weautomate读取Excel表格信息然后填写到网页一直报错,如何解决?
  • ¥15 C#如何在Webview2中获取网页验证码
  • ¥15 esp32烧录失败,具体情况在图片上