Trouble parsing JSON with jQuery

Question

I am playing around with parsing JSON in jQuery and I am having trouble. I want to check the value of 'time' in the JSON object. Here is my trial function:

$.ajax({
     url: 'do_chat.php5',
     type: 'post',
     data: ({'message':'','poster':poster,'logged_in':logged_in}),
     dataType: 'json',
     success: function(data) {
       $.each(data, function(interval, message) {
       if(message['time']) {
     $('#chatWindow').append('<p>hi</p>');
       }
 });
     }
     });

The string being returned from my server looks like:

{"poster":"","message":"No messages!","time":1256084677}

I am not sure of the syntax of $.each. I am using PHP to encode the JSON string, which started life as a php assoc array. I'm sure my mistakes are plenty and any help is greatly appreciated!

Edit: follow up question - how do I make PHP generate a JSON array? At the moment I use this to generate the single object:

$messages = mysqli_fetch_assoc($new_res);
 $msg = $messages["content"];
 $who = $messages["poster"];
 $time = $messages["time_added"];
$message = array(
  'poster' => $who,
  'message' => $msg,
  'time' => $time
);

echo json_encode($message);

But if I were to get more than one row from my database query, how do I do that?

Idris Mokhtarzada · Accepted Answer · 2009-10-21 01:36:57Z

2

The problem with your code is that you are returning a single JSON Object {"poster":"","message":"No messages!","time":1256084677}, but you are then iterating through it with $.each.

$.each expects an array, and since you are not returning an array, the $.each is looping through the elements of your JSON object instead.

To fix your code, you need to either make sure your server is returning an array, like: [{"poster":"","message":"No messages!","time":1256084677}]

or

Remove the $.each, so that you have:

$.ajax({
    url: 'do_chat.php5',
    type: 'post',
    data: ({'message':'','poster':poster,'logged_in':logged_in}),
    dataType: 'json',
    success: function(data) {
        if(data['time']) {
            $('#chatWindow').append('<p>hi</p>');
        }
    }
});

answered Oct 21, 2009 at 1:36

Idris Mokhtarzada

1,04412 silver badges21 bronze badges

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

Comments

Corey Ballou · Accepted Answer · 2009-10-21 00:34:22Z

0

$.ajax({
     url: 'do_chat.php5',
     type: 'post',
     data: ({'message':'','poster':poster,'logged_in':logged_in}),
     dataType: 'json',
     success: function(data) {
         if (typeof data.time != 'undefined') {
             $('#chatWindow').append('<p>' + data.poster + ' - ' + data.message + '</p>');
         }
     });
});

answered Oct 21, 2009 at 0:34

Corey Ballou

43.7k8 gold badges66 silver badges77 bronze badges

Comments

James Black · Accepted Answer · 2009-10-21 01:09:15Z

0

I end up using a JSON parser from http://json.org:

$.ajax({
    type: "POST",
    url: "getData.asmx/retrieveSubcontractorList",
    contentType: "application/json; charset=utf-8",
    dataType: "json",
    data: "{}",
    success: function(result2) {
        var toolsData = JSON.parse(result2.d);

The trick was that the data is actually in a property called d.

answered Oct 21, 2009 at 1:09

James Black

41.8k10 gold badges92 silver badges173 bronze badges

Collectives™ on Stack Overflow

Trouble parsing JSON with jQuery

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related