How do I retrieve objects from JSON received from a php file?

Question

I have a places.php file on my server that returns the following json:

{"places":[{"poi_id":"1","poi_latitude":"53.9606","poi_longitude":"27.6103","poi_title":"Shop1","poi_category":"Shopping","poi_subcategory":"Grocery Store","poi_address":"Street 1, 1","poi_phone":null,"poi_website":null},{"poi_id":"2","poi_latitude":"53.9644","poi_longitude":"27.6228","poi_title":"Shop2","poi_category":"Shopping","poi_subcategory":"Grocery Store","poi_address":"Street 2","poi_phone":null,"poi_website":null}]}

In my javascript I use the following piece of code:

$(document).ready(function() {
   var url="places.php";
   $.getJSON(url,function(data){
       $.each(data.places, function(i,place){
          var new1 = place.poi_id;
          alert(new1);
       });
   });              
});

However the message box with the poi_id doesn't pop up. What am I doing wrong?

can you console.log the data and see what you get ? Do you get any error in console ? — Vinod Louis
– Vinod Louis, Commented Jul 16, 2014 at 9:56
neither console.log(data); nor alert(data); didn't work at all. No errors in console detected — Jan Guardian
– Jan Guardian, Commented Jul 16, 2014 at 10:01
weird thing for trouble shooting can you try all cases like success,fail,error i guess u will get to some case from here api.jquery.com/jquery.getjson — Vinod Louis
– Vinod Louis, Commented Jul 16, 2014 at 10:06

Latheesan · Accepted Answer · 2014-07-16 21:36:01Z

How about like this.

<script type="text/javascript" src="http://code.jquery.com/jquery-1.11.1.min.js"></script>
<script type="text/javascript">

// data source
var jsonStr = '{"places":[{"poi_id":"1","poi_latitude":"53.9606","poi_longitude":"27.6103","poi_title":"Shop1","poi_category":"Shopping","poi_subcategory":"Grocery Store","poi_address":"Street 1, 1","poi_phone":null,"poi_website":null},{"poi_id":"2","poi_latitude":"53.9644","poi_longitude":"27.6228","poi_title":"Shop2","poi_category":"Shopping","poi_subcategory":"Grocery Store","poi_address":"Street 2","poi_phone":null,"poi_website":null}]}';

// parse json string to object
var jsonObj = JSON.parse(jsonStr);

// usage 1
console.log('iterate - without jQuery');
for (var i = 0; i < jsonObj.places.length; i++)
{
    var place = jsonObj.places[i];
    console.log(place.poi_id);
}

// usage 2
console.log('iterate - with jQuery');
$(jsonObj.places).each(function(index, place)
{
    console.log(place.poi_id);
});

</script>

Output:

enter image description here

How to use this in your code:

$(document).ready(function()
{
    $.getJSON("/path/to/places.php", function(data)
    {
        // data here will be already decoded into json object, 
        // so... you do this
        $(data.places).each(function(index, place)
        {
            console.log(place.poi_id);
        });
    });             
});

Take a look at the manual also: http://api.jquery.com/jquery.getjson/

Should work, if not leave a comment with an error or reason.

Ok. This solution works fine. Now the question is - how to fetch the json string from my places.php file?

Swiffy · Accepted Answer · 2014-07-16 09:56:59Z

0

Does this do / get you closer:

for (var property in data) 
{
    if (data.hasOwnProperty(property)) 
    {
        console.log(property);
    }
}

answered Jul 16, 2014 at 9:56

Swiffy

4,7453 gold badges28 silver badges56 bronze badges

1 Comment

Jan Guardian Over a year ago

No, it doesn't, unfortunately

nepeo · Accepted Answer · 2014-07-16 10:19:29Z

Is your php actually generating the JSON? If it's only getting a particular file it may be easier to choose your file using JS and AJAX it. Here's the code I use for php anyway.

function callPHP(dataToSend)
{
    $.post( "places.php", dataToSend )
        .done(function( phpReturn ) {
            console.log( phpReturn );
            var data = JSON.parse(phpReturn);
            for(var i = 0;i<data.places.length;i++)
                console.log(data.places[i].poi_id);
    });}
}

Jan Guardian · Accepted Answer · 2014-07-16 12:21:06Z

0

Setting places.php file encoding to UTF-8 solved the problem

answered Jul 16, 2014 at 12:21

Jan Guardian

3133 silver badges14 bronze badges

Collectives™ on Stack Overflow

How do I retrieve objects from JSON received from a php file?

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Related