How to get DataTables Ajax parameters

Question

I am using jQuery DataTables with server-side processing.

I want to create a button. When that button is clicked, it should send current DataTable parameters (search, sort, etc) to the server-side script to generate MS Excel file using PHPExcel.

What have you tried to accomplish that? It's important to know how to ask to improve the chances of getting a good answer. Please, edit your question to include that information. — Marcos Dimitrio
– Marcos Dimitrio, Commented Jul 22, 2015 at 2:27

Gyrocode.com · Accepted Answer · 2015-08-14 17:47:21Z

2

You can use ajax.params() to get the data submitted by DataTables to the server in the last Ajax request.

Then you can redirect to script that generates Excel file with these parameters using jQuery helper function $.param that converts array into query string.

For example:

window.location = '/getFile.php?' + $.param($('#example').DataTable().ajax.params());

where example is table ID.

edited Aug 14, 2015 at 17:47

answered Jul 22, 2015 at 2:35

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

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

Collectives™ on Stack Overflow

How to get DataTables Ajax parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related