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
75.1K
All Categories
57
Priority support
24.7K
Free community support
1K
General
14
Announcements
2.6K
DataTables
132
DataTables 2
1.3K
DataTables 1.10
93
DataTables 1.9
35
DataTables 1.8
9
CloudTables
2.3K
Editor
2.8K
Extensions
20
AutoFill
314
Buttons
34
ColReorder
4
ColumnControl
34
DateTime
68
FixedColumns
51
FixedHeader
31
KeyTable
106
Responsive
24
RowReorder
43
Scroller
168
SearchBuilder
201
SearchPanes
107
Select
27
StateRestore
220
Bug reports
68
Feature requests
101
Plug-ins
11
Blog
73
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]