How to properly parse Result Array from database with Jquery?

Question

I have codeigniter application which fetches data from database and this data is manipulated by Jquery. Result array from database used to look like this:

 { "result":[
    {"name":"John","surname":"Smith"}] }

And I use to parse it using code below:

$.get("index.php/getResult",{f_name: $('#fn').val()} ,function(data) {
    var list= "";
    $.each(data, function(index, element) {
        if (index > 0) {list;}
        list+= element.name;
    });
    $('#myid').html(list);
},"json");

My result array has changed to the format below, how can I parse it now? Any help is appreciated.

{
"count": 8,
"result":[
{"name":"John","surname":"Smith"}] }

Lee Taylor · Accepted Answer · 2013-01-08 20:42:50Z

3

You don't need to parse anything:

$.get("index.php/getResult",{f_name: $('#fn').val()} ,function(data) 
{
    alert(data.count);

    for(var i=0; i< data.result.length; i++)
    {
        alert(data.result[i].name + " " + data.result[i].surname);
        // etc.
    }
    // etc.

},"json");

answered Jan 8, 2013 at 20:42

Lee Taylor

7,99416 gold badges38 silver badges53 bronze badges

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

Comments

chsymann · Accepted Answer · 2013-01-08 20:59:33Z

1

As you are using json (what means J ava S cript- O bject- N otation) you can use this object like any ohter JavaScript object. So you can access result[0].name for example. For debugging i recommend to use Firebug Add-On for Firefox or Chrome Webdevelopertool. In both you can write console.log(data) or console.log(result[0].name) for example and view your object in console-tab.

answered Jan 8, 2013 at 20:59

chsymann

1,6801 gold badge15 silver badges15 bronze badges

Collectives™ on Stack Overflow

How to properly parse Result Array from database with Jquery?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related