Parsing json in JQuery Ajax Call From PHP

Question

I have seen a bunch of different ways to call a php script via ajax that returns json but i cant seem to get any working I was curious if someone could help me.

Here is my PHP script:

//database connection stuff....
$query = "SELECT * FROM  weather limit 10";
$result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
// get data and store in a json array
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $orders[] = array(
        'zip' => $row['zip'],
        'temp' => $row['temp'],
        'time' => $row['time']
      );
}

echo json_encode($orders);

Next here is my ajax call:

$.ajax({
            url : 'getweather.php',
            type : 'post',
            dataType: 'json',
            success: function(data){
                for (var x = 0; x < data.length; x++) {

                    alert(data['zip']);

                }

            }
        });


    });

With this i just get 10 alerts that say undefined. Can someone please help me figure out what i am doing wrong?

Thanks in advance for the help!

Craig

You are not using your x. Try data[x]['zip']

rjdown
– rjdown

2015-09-28 23:04:59 +00:00
Commented Sep 28, 2015 at 23:04 — rjdown
– rjdown, Commented Sep 28, 2015 at 23:04

jmoerdyk · Accepted Answer · 2015-09-28 23:05:00Z

2

Your data is an array of arrays, you need to index the outer array before the inner array:

alert(data[x]['zip'])

answered Sep 28, 2015 at 23:05

jmoerdyk

5,5448 gold badges43 silver badges58 bronze badges

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

1 Comment

craigtb Over a year ago

i knew it'd be something simple. Thanks!

Collectives™ on Stack Overflow

Parsing json in JQuery Ajax Call From PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related