How to get all data?

chucky2183

Hi. I'm new with this excellent framework.

Well i use DT for an invoice details. I create a new table and i add data very fine. Now i want to know how i get all data from the datatable. I fill all, and then when i finished, i need to get data to save in the database.

Can anyone help me please?

Sorry for my english, isn't very good

Thanks

allan

The fnGetData API method?

Allan

chucky2183

Ty Allan. Can you put an example? Because i need all data.

allan

[code]
var oTable = $('#whatever').dataTable();
oTable.fnGetData();
[/code]

Allan

n3wb13

fnGetData(); returns a 2D array of the entire table. But is there any way to return a multi-dimension array or convert the data in the table to JSON format and then post it back to the server?

allan

I don't understand - the 2D array is multi-dimensional (two dimensional to be exact!). It contains all of the data in the table. It is just a Javascript array so you can use JSON.strigify to send it as a string.

Allan

n3wb13

Yeah it works fine. So sorry for my stupidity.

maadso

Hi Allan,

I'm trying to get all the data from the table, but when I use fnGetData(), it leaves out the header. Is there another call I can use to get everything in the entire table?

Thanks!

--edit: saw your response to my other post, so sorry for duplicate questions! Check Allan's answer here: http://www.datatables.net/forums/discussion/comment/60182#Comment_60182