Search jQuery

jQuery Forum

Selecting values from a JSON return object

in Getting Started • 11 years ago

First post from a newbie, I am learning by doing.

I've been able to read data out of mysql, put it into a JSON object and return that data into a browser. There are currently five rows in the db and my query is selecting all rows. What I would like to do is return the five most recent rows (in the JSON object) and then pull out the first field of each row as the title in a collapsible panel (jam) with the third field of each row as the content in that drop down collapsible div.

Can't seem to figure out how to pull a specific pair from the JSON return object. I hope my post makes sense. I appreciate any pointers, doc, tutorial, sample where I can learn how to do this.

Thank you!

Replies(1)

kbwood.au

Re: Selecting values from a JSON return object

11 years ago

Returning the five most recent rows is something you would do in the database query or on the server, i.e. not with jQuery.

Assuming your JSON contains a rows array, each entry of which has a fields array, it would look something like this:

$.getJSON('mydata.php', function(data) {
var html = '';
$.each(data.rows, function(i, row) {
html += '<div class="entry"><h2>' + row.fields[0] + '</h2>' +
'<div class="content">' + row.fields[2] + '</div></div>'
});
$('#container').html(html);
});

Top Reply

Response title

Attachments

jQuery Forum

Selecting values from a JSON return object

Replies(1)

Re: Selecting values from a JSON return object

Statistics

Tags

Actions

Related Posts