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
server-side (1.91) add extra where clause in query
server-side (1.91) add extra where clause in query
paky
Posts: 106
Questions: 0
Answers: 0
April 2012
edited April 2012
in
General
How can do it ? Thanks
Replies
koosvdkolk
Posts: 169
Questions: 0
Answers: 0
April 2012
What language? PHP, ASP.NET, JSP?
paky
Posts: 106
Questions: 0
Answers: 0
April 2012
ops sorry, php.
koosvdkolk
Posts: 169
Questions: 0
Answers: 0
April 2012
http://datatables.net/development/server-side/php_mysql
Add SQL to $sWhere on line >=114?
paky
Posts: 106
Questions: 0
Answers: 0
April 2012
I wrote this ;) thanks
[code]
/**
* EXTRA WHERE
*
*/
$sWhere .= $sWhere == "" ?" WHERE my_condition AND my_condition2":" AND my_condition AND my_condition2";[/code]
koosvdkolk
Posts: 169
Questions: 0
Answers: 0
April 2012
edited April 2012
-double post-
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.5K
All Categories
56
Priority support
24.2K
Free community support
1K
General
14
Announcements
2.5K
DataTables
88
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
311
Buttons
50
ColVis
30
DateTime
68
FixedColumns
50
FixedHeader
33
ColReorder
31
KeyTable
104
Responsive
23
RowReorder
42
Scroller
166
SearchBuilder
193
SearchPanes
107
Select
26
StateRestore
22
TableTools
220
Bug reports
67
Feature requests
100
Plug-ins
11
Blog
70
Web-site
Replies
Add SQL to $sWhere on line >=114?
[code]
/**
* EXTRA WHERE
*
*/
$sWhere .= $sWhere == "" ?" WHERE my_condition AND my_condition2":" AND my_condition AND my_condition2";[/code]