Send parameters with ajax call from jquery datatables

Question

I want to load data into a jquery datatable with ajax. Also I want to send parameters to the function that pulls the data from the database.

So what I want to do:

$('#datatables').dataTable( {
    "bProcessing": true,
    "bServerSide": true,
    "sAjaxSource": "/results/load-results",
    "fnServerParams": function ( aoData ) {
        aoData.push( { "quizid": quizid, "questionid": qid } );
    }
} );

I want to so send the quizid and questionid and use them in my function. How can I pull them in my function? Tried $_GET but didn't work ..

Have you read this? datatables.net/forums/discussion/6600/… (TLDR: are you running version 1.8.2?) — Alasjo
– Alasjo, Commented Sep 25, 2013 at 8:01
Ok, but my questions is: how can I get these variables in my php function? — nielsv
– nielsv, Commented Sep 25, 2013 at 8:14
Have you tried dumping GET and/or POST vars in your php script (load_results) to see what values you have? — Alasjo
– Alasjo, Commented Sep 25, 2013 at 8:20

Se0ng11 · Accepted Answer · 2013-09-25 08:43:41Z

15

Format must be

"fnServerParams": function ( aoData ) {
      aoData.push( { "name": "quizid", "value": quizid },{ "name": "questionid", "value": qid } );
},

edited Sep 25, 2013 at 8:43

answered Sep 25, 2013 at 8:22

Se0ng11

2,3342 gold badges29 silver badges45 bronze badges

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

1 Comment

Freddy Sidauruk Over a year ago

well how about if datatable has filtering multiple columns send variable by onclick, thanks

Collectives™ on Stack Overflow

Send parameters with ajax call from jquery datatables

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related