javascript json object decode

Question

I am new to JSON and AJAX and was hoping someone could help me out here.

Using an AJAX request to a PHP script, I get some data from SQL database -> encoded as JSON string and sent it back to the calling javascript.

This is the data i get back

Array[{"categoryName":"Apartments For Rent"},{"categoryName":"Apartments For Sale"},{"categoryName":"Room For Rent (Shared)"},{"categoryName":"Paying Guest"},{"categoryName":"Office\/Shop\/Commercial Space"},{"categoryName":"Land"},{"categoryName":"Parking Spots"},{"categoryName":"Other"}]

How can I get the individual 'CategoryName' values from this (in a while loop)?

EDIT : PHP CODE THAT SENDS THE JSON DATA

    $arr = array();
    while($row = mysql_fetch_array($temp,MYSQL_ASSOC))
    {
        $arr[]=$row;
    }
    echo json_encode($arr);

Thank you for the help
Ankit

That does not seem to be valid JSON. Where does Array come from? — Felix Kling
– Felix Kling, Commented Sep 5, 2011 at 20:10
It seems you are doing another echo somewhere or you just included Array by accident. Make sure it is not in the response. — Felix Kling
– Felix Kling, Commented Sep 5, 2011 at 20:20
@Felix. Thank you for pointing that out. I had missed out on an echo statement that was adding the 'Array' part. Fixing that solved it all. :D — ankit
– ankit, Commented Sep 5, 2011 at 20:27

Shedokan · Accepted Answer · 2011-09-05 20:20:38Z

1

Use eval() to decode it to a javascript object and then loop trough it, but you'll have to remove the "Array" at the start on the php side or using javascript.

var jsonStr = '[{"categoryName":"Apartments For Rent"},{"categoryName":"Apartments For Sale"}]';
jsonObj = eval("("+jsonStr+")");
for(var i in jsonObj){
  categoryName = jsonObj[i].categoryName;
}

From: http://www.json.org/js.html

edited Sep 5, 2011 at 20:20

answered Sep 5, 2011 at 20:14

Shedokan

1,2021 gold badge10 silver badges21 bronze badges

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

1 Comment

Shedokan Over a year ago

It doesn't really matter, I just saw that no one shows the code to use from a string to an object, so I showd it in a basic form

Darin Dimitrov · Accepted Answer · 2011-09-05 20:09:31Z

0

You could loop through the array and access individual elements by their index:

for (var i = 0; i < data.length; i++) {
    alert(data[i].categoryName);
}

answered Sep 5, 2011 at 20:09

Darin Dimitrov

1.0m275 gold badges3.3k silver badges3k bronze badges

3 Comments

ankit Over a year ago

data.length returns 290. So it seems the returned JSON object is being treated as a string.

Darin Dimitrov Over a year ago

@ankit, try parsing it then: JSON.parse(data); and operate on the result of this function. The JSON.parse method can be found in json2.js: github.com/douglascrockford/JSON-js

ankit Over a year ago

Works like a charm now after removing the stray echo statment suggestion !

Simon Arnold · Accepted Answer · 2011-09-05 20:14:49Z

0

i=0;
do{
    alert(data[i].categoryName);
    i++;
}
while(i<=data.length);

As described by Darin Dimitrov, but in a While loop.

answered Sep 5, 2011 at 20:14

Simon Arnold

16.2k8 gold badges70 silver badges89 bronze badges

Collectives™ on Stack Overflow

javascript json object decode

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related