getJSON and retrieving data from an Array

Question

I made a PHP script:

function getData(){

  $DBH = connectDB(********);

  $STH = $DBH->query('SELECT * FROM table');

  $tData = $STH->fetchAll(PDO::FETCH_ASSOC);

    echo json_encode($tData);

}

This is executed in getData.php. The fields are ID, name, lastname, age. Basically, get's all the table's values and put them in a JSON array.

I dont know how to complete the JQuery's getJSON function to retrieve, for example, the ID 5 register or the name = "John" one.

The examples at JQuery.com are a bit complex due my little understanding of how all this stuff works.

Luca Filosofi · Accepted Answer · 2010-12-05 23:47:55Z

1

UPDATED:

$(function() {
    $.getJSON('getData.php',function(data) {
        $.each(data,function(i, item) {
            alert(item.ID + '->' + item.name + '->' + item.lastname );
        });
    });
});

NB: the way on how you get the single ID, NAME depend on how the json_encode($tData) is formatted, so, you do better if you post to us the echoed json!

edited Dec 5, 2010 at 23:47

answered Dec 5, 2010 at 23:19

Luca Filosofi

31.2k9 gold badges72 silver badges77 bronze badges

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

4 Comments

Gabriel Over a year ago

[{"ID":"1","name":"John","lastname":"Doe","age":"22"}...]

Luca Filosofi Over a year ago

i have updated the code, sorry my bad, now it should work as expected! ;)

Gabriel Over a year ago

What's the i for in $.each(data,function(i, item) { ??

Luca Filosofi Over a year ago

@Gabriel A. Zorrilla - i is the incrementer like i++ in a classic for loop

Marco Leo · Accepted Answer · 2010-12-05 23:22:59Z

1

$.getJSON("you page.php", { format: "json" }, function(data) { $.each(data.items, function(i,item){ Alert(item["yourfildname"]); }); });

edited Dec 5, 2010 at 23:22

answered Dec 5, 2010 at 22:48

Marco Leo

5164 silver badges9 bronze badges

2 Comments

Gabriel Over a year ago

Thanks Marco. But where are you supposed to call the PHP script to retreive the data?

Gabriel Over a year ago

It does not use $.getJSON and i get "undefined" in the alert prompt.

Collectives™ on Stack Overflow

getJSON and retrieving data from an Array

2 Answers 2

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related