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.3K
All Categories
56
Priority support
24K
Free community support
996
General
14
Announcements
2.5K
DataTables
75
DataTables 2
1.3K
DataTables 1.10
92
DataTables 1.9
35
DataTables 1.8
9
CloudTables
2.2K
Editor
2.8K
Extensions
20
AutoFill
310
Buttons
50
ColVis
30
DateTime
68
FixedColumns
50
FixedHeader
31
ColReorder
30
KeyTable
103
Responsive
23
RowReorder
41
Scroller
163
SearchBuilder
193
SearchPanes
107
Select
26
StateRestore
22
TableTools
219
Bug reports
67
Feature requests
100
Plug-ins
11
Blog
69
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