Ajax query with table filtering (by date) + calculating total of value?

ronylicha

Hello!
i had a table with more than 100 000 rows and i have a input with datepicker than filtering the table by an date interval and also an automatic calculating of the value of those filtered row, i want to do that with an ajax requete and an sql query.
Do you have any idea that how can i do that?

Here is my actually code:

[code]
var oTable1 = $('#table_report').dataTable( {
"oLanguage": {
"sUrl": "/js/fr/dataTables.french.txt"
},
"aoColumns": [
null,
null,
null,
null,
null,
null,
null,
{ "bSortable": false }
],
'bRetrieve': true,
"fnFooterCallback": function ( nRow, aaData, iStart, iEnd, aiDisplay ) {


var iTotalMarket = 0;
for ( var i=0 ; i