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

Question

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.

Answer 1

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