Databases
StackOverflow2013
Postsdbo
POHow to parse JSON array in jQuery?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to parse JSON array in jQuery?
    primarykey
    data
    text
    <p><strong>EDIT</strong> I checked the jQuery documentation and using $.ajax with the json datatype specified returns an evaluated javascript object, so eval() isn't the answer here. I knew that anyway, since I am able to parse single JSON objects, just not arrays. The problem is the $.each-ing my way through them :)</p> <p>I have followed the syntax for parsing a JSON array in jQuery to the letter, but it doesn't work for some reason. I am fetching the array using $.ajax, have specified the correct datatype, and in Firebug can see that the response from my PHP script is []. Yet when I try to use $.each to iterate through the array, all I get is undefined values when I try to console.log various parts of the array. Here is where my php script makes and encodes the array:</p> <pre><code>if(mysqli_num_rows($new_res) &gt; 0) { $messages = array(); while($message_data = mysqli_fetch_assoc($query_res)) { $message = array( 'poster' =&gt; $message_data['poster'], 'message' =&gt; $message_data['message'], 'time' =&gt; $message_data['time'] ); $messages[] = $message; } echo json_encode($messages); } else if(mysqli_num_rows($new_res) == 0) { $message = array( 'poster' =&gt; '', 'message' =&gt; 'No messages!', 'time' =&gt; 1 ); echo json_encode($message); } </code></pre> <p>And here is my attempt to parse it:</p> <pre><code> var logged_in = '&lt;?php echo $logged_in; ?&gt;'; var poster = '&lt;?php echo $_SESSION["poster"];?&gt;'; $.ajax({ url: 'do_chat.php5', type: 'post', data: ({'poster':poster,'logged_in':logged_in}), dataType: 'json', success: function(data) { $.each(data, function(messageIndex, message) { console.log(parseInt($('#chatWindow :last-child &gt; span').html())+' '+message['time']); if((parseInt(message['time']) &gt; parseInt($('#chatWindow :last-child &gt; span').html()))) { $('#chatWindow').append('&lt;div class="poster"&gt;'+message['poster']+'&lt;/div&gt;&lt;div class="message"&gt;&lt;span&gt;'+message['time']+'&lt;/span&gt;'+message['message']+'&lt;/div&gt;'); } }); } }); </code></pre> <p>Without the $.each function I am able to successfully parse single JSON objects, but not an array. This is my first outing with JSON and $.each, and I'm pretty new to jQuery, so go easy if my code has ugly bits!</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser97410
    1. USuser97410
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to parse JSON array in jQuery?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow to parse JSON array in jQuery?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow to parse JSON array in jQuery?
      1. USjonascw
      1. VTFavorite
    1. CODid you manage to find a solution? If so I suggest selecting an answer :p
      singulars
      1. POHow to parse JSON array in jQuery?
      1. USmeder omuraliev
    2. COI didn't yet, no. I edited but got no further replies. The problem either lies with the way PHP is encoding the JSON object or with the $.each syntax. I console.logged the response data, and then eval()-ed it and console logged it and I get the same thing, so eval was not the answer.
      singulars
      1. POHow to parse JSON array in jQuery?
      1. USuser97410
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload