JSON to DataTable

Topic: JSON to DataTable

sergeyzh free asked 6 years ago

Is there any chance to feed DataTable with JSON data without making AJAX requests (just need to add JSON data into the DataTable)? Thank you!

Add comment

sergeyzh free answered 6 years ago

1 0 Best answer

Please insert min. 20 characters.

I found a way to do this:

var myData = [{

name: "value",

age: "20"

},{...},...,{...}]

var data = jQuery.map(myData, function (el, i) {

return [

[el.name, el.age]

];

$(document).ready(function () {

$('#dtBasicExample').DataTable({

"aaData": data,

"aoColumns": [{

"sTitle": "Name"

{

"sTitle": "Age"

}]

});

Mikołaj Smoleński staff commented 6 years ago

Thanks for publishing Your answer! It might be helpful for other users.

Add comment

Mikołaj Smoleński staff answered 6 years ago

0 0 Best answer

Hi there, For this moment You can put data inside datatables in two ways: 1) manually using html 2) using php (You can use PHP for statemant) Best Regards

gravey16 free commented 5 years ago

A good enhancement to the plugin would be JSON based a data set option. I didn't see a place to add enhancement ideas, but i could envision something like this. columns[ {field:'firstname', title:'First Name', width:'200', class:'format_class'}, {field:'lastname', title:'Last Name', width:'200', class:'format_class'}, ...... ], data:[{firstname:Jim, lastname:Dugan},{firstname:Steve,lastname:Dawkins }......]

This would be very helpful to people who use database driven tables, as you can simply match the table field names with the Database field names.

Add comment

Write

Create snippet

FREE CONSULTATION

Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.

Status

Answered

Specification of the issue

ForumUser: Free
Premium support: No
Technology: MDB jQuery
MDB Version: 4.5.10
Device: PC
Browser: Chrome
OS: Windows 10
Provided sample code: No
Provided link: No

sergeyzh

17Support score
1Questions 1Answers 0Snippets