Generate DataTables Dynamically from json array

Question

I am getting JSON data from a php file and want to display it with DataTables. So I am creating DataTables dynamically. But I am getting problem in making following data from the data coming in JSON.

var aDataSet = [
                ['Trident','Internet Explorer 4.0','Win 95+','4','X'],
                ['Trident','Internet Explorer 5.0','Win 95+','5','C']
            ];

I want each entry in this Dataset dynamically. I am using "for loop".

for(i=0;i<count;i++)
{
}

JSON Data coming from PHP file:

{
    "data": [
        {
            "staff_id": "1",
            "staff_name": "Chinu",
            "rig_days": "80",
            "manager_id": "2",
            "grade": "8",
        },
        {
            "staff_id": "2",
            "staff_name": "John",
            "rig_days": "90",
            "manager_id": "3",
            "grade": "10",
        }
]
}

How it should be placed in for loop so that it works well ?

I didn't get how to do it ? Because dataset is not a string that can be made inside for loop. — user2767347
– user2767347, Commented Sep 15, 2013 at 16:34

Explosion Pills · Accepted Answer · 2013-09-15 17:56:48Z

1

If you have control over PHP you could change how the JSON is encoded to send a multidimensional array for the data property, but it's not that difficult to do with JS anyway:

var aDataSet = [];
json.data.forEach(function (elem) {
    aDataSet.push([elem.staff_id, elem.staff_name,
       elem.rig_days, elem.manager_id, elem.grade]);
});

edited Sep 15, 2013 at 17:56

answered Sep 15, 2013 at 17:34

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

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

1 Comment

user2767347 Over a year ago

append is not working :( flow is going inside foreach with json values but append is not working so I am not getting aDataSet.

Collectives™ on Stack Overflow

Generate DataTables Dynamically from json array

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related