DataTables logo
≡

add $_SESSION['var'] to datatable params ....

add $_SESSION['var'] to datatable params ....

pakypaky Posts: 106Questions: 0Answers: 0
edited January 2010 in General
Hi Allan how can insert my $_SESSION vars in datatable for filter my query ?

thanks

Replies

  • pakypaky Posts: 106Questions: 0Answers: 0
    edited January 2010
    Allan I push in aoData one var
    [code]
    "fnServerData": function ( sSource, aoData, fnCallback ){
    aoData.push( { "name": "session_id", "value": session_id });
    $.ajax( {
    "dataType": 'json',
    "type": "POST",
    "url": sSource,
    "data": aoData,
    "success": fnCallback
    } );
    },
    [/code]

    with POST method I read it in php file, firefox reply is:

    {"sEcho": , "iTotalRecords": 1, "iTotalDisplayRecords": 1, "aaData": [ ["blablabla","28/01/2010","30/01/2010","week end ne...","blabla","blabla"]] }

    ... strange sEcho without value :(
  • pakypaky Posts: 106Questions: 0Answers: 0
    .. solved !!

    Method is GET not POST ...

    [code]
    "fnServerData": function ( sSource, aoData, fnCallback ) {
    aoData.push( { "name": "session_id", "value": session_id });
    $.ajax( {
    "dataType": 'json',
    "type": "GET",
    "url": sSource,
    "data": aoData,
    "success": fnCallback
    } );
    },
    [/code]

    Hi all
This discussion has been closed.