jQuery JSON and PHP Associative arrays arrays issues

Question

Hi there I was wondering if somebody could help me?

I have the following code. It retrieves JSON data from a php file. The Json is the following format :

{"Title":"rose","Price":1.25,"Number":15},{"Title":"daisy","Price":0.75,"Number":25},{"Title":"orchid","Price":1.15,"Number":7}

This JSON is created using the following php code:

$shop = array();
$shop = array( array( Title => "rose", 
                  Price => 1.25,
                  Number => 15 
                ),
           array( Title => "daisy", 
                  Price => 0.75,
                  Number => 25,
                ),
           array( Title => "orchid", 
                  Price => 1.15,
                  Number => 7 
                )
         );

 echo json_encode($shop);

Whenever i try and access the data using obj.Title I get an undefined message.

 $.ajax({
        type: "GET",
        url: "data.php",
        success: jsonDo
    });

    //JSON DATA = {"Title":"rose","Price":1.25,"Number":15},{"Title":"daisy","Price":0.75,"Number":25},{"Title":"orchid","Price":1.15,"Number":7}

    function jsonDo(data) {

        var obj = jQuery.parseJSON(data);

        alert(obj.Title)

    }

I was wondering how I can access the keys in the JSON and display the data?

Thanks a million.

jQuery is probably parsing the JSON for you, so data is already a JS object. Try alert(data.Title); — lonesomeday
– lonesomeday, Commented Jul 4, 2012 at 21:28
When in doubt, console.log()! In your case, console.log(data). — Matthew Blancarte
– Matthew Blancarte, Commented Jul 4, 2012 at 21:35

Alex Ball · Accepted Answer · 2012-07-04 22:00:57Z

2

var obj = jQuery.parseJSON('{"Title":"rose","Price":"1.25","Number":"15"}');

alert(obj.Title);

This work. Check difference in your code.

OK this is more correct:

var obj = [
    {"Title":"rose","Price":"1.25","Number":"15"},
    {"Title":"daisy","Price":"0.75","Number":"25"},
    {"Title":"orchid","Price":"1.15","Number":"7"}
    ];


 alert(obj[1].Title);

edited Jul 4, 2012 at 22:00

answered Jul 4, 2012 at 21:33

Alex Ball

4,4842 gold badges20 silver badges23 bronze badges

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

1 Comment

user774715 Over a year ago

Thanks. Except my JSON is {"Title":"rose","Price":1.25,"Number":15},{"Title":"daisy","Price":0.75,"Number":25},{"Title":"orchid","Price":1.15,"Number":7}

Ricardo Souza · Accepted Answer · 2012-07-04 21:38:58Z

1

You have to specify that you are expecting a JSON object by informing the dataType: "JSON" parameter to the ajax() function, so you will not have to parse the data.

answered Jul 4, 2012 at 21:38

Ricardo Souza

16.5k6 gold badges40 silver badges70 bronze badges

Comments

shxfee · Accepted Answer · 2012-07-04 21:49:48Z

1

There seems to be some PHP errors in your code. This could cause php to raise a notice / warning which might break the Json output and cause javascript to raise errors when trying to parse it.

The correct jSon output should have been

[{"Title":"rose","Price":1.25,"Number":15},{"Title":"daisy","Price":0.75,"Number":25},{"Title":"orchid","Price":1.15,"Number":7}]

Since it is in an array, the JS should be: $.ajax({ type: "GET", url: "data.php", success: jsonDo });

function jsonDo(data) {
    var obj = jQuery.parseJSON(data);
    alert(obj[0].Title)

}

edited Jul 4, 2012 at 21:49

answered Jul 4, 2012 at 21:43

shxfee

5,3166 gold badges33 silver badges29 bronze badges

Comments

Korvin Szanto · Accepted Answer · 2012-07-04 21:30:45Z

0

You should just use jQuery's $.getJSON method:

$.getJSON('data.php',function(data) {
    alert(obj.Title);
});

answered Jul 4, 2012 at 21:30

Korvin Szanto

4,5194 gold badges22 silver badges49 bronze badges

Comments

Tschallacka · Accepted Answer · 2012-07-04 21:32:49Z

0

try obj[0]["Title"] or obj[0].Title

dont forget that you have nested a lot of arrays and that yoyu need to access them that way again.

answered Jul 4, 2012 at 21:32

Tschallacka

28.9k15 gold badges99 silver badges140 bronze badges

Collectives™ on Stack Overflow

jQuery JSON and PHP Associative arrays arrays issues

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related