DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
Examples
Manual
Reference
Extensions
Plug-ins
Blog
Forums
Discussions
Sign In
Support
FAQs
Download
Purchase
≡
Show site navigation
add $_SESSION['var'] to datatable params ....
add $_SESSION['var'] to datatable params ....
paky
Posts: 106
Questions: 0
Answers: 0
January 2010
edited January 2010
in
General
Hi Allan how can insert my $_SESSION vars in datatable for filter my query ?
thanks
Replies
paky
Posts: 106
Questions: 0
Answers: 0
January 2010
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 :(
paky
Posts: 106
Questions: 0
Answers: 0
January 2010
.. 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.
Sign In
·
Register
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Sign In
Register
Quick Links
Categories
Recent Discussions
Unanswered
Categories
74.9K
All Categories
57
Priority support
24.5K
Free community support
1K
General
14
Announcements
2.6K
DataTables
120
DataTables 2
1.3K
DataTables 1.10
93
DataTables 1.9
35
DataTables 1.8
9
CloudTables
2.2K
Editor
2.8K
Extensions
20
AutoFill
313
Buttons
51
ColVis
30
DateTime
68
FixedColumns
51
FixedHeader
33
ColReorder
31
KeyTable
106
Responsive
24
RowReorder
43
Scroller
168
SearchBuilder
200
SearchPanes
107
Select
26
StateRestore
22
TableTools
220
Bug reports
67
Feature requests
100
Plug-ins
11
Blog
72
Web-site
Replies
[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 :(
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