ParamQuery Grid
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Home
Help
Search
Login
Register
ParamQuery grid support forum
»
General Category
»
ParamQuery Pro Evaluation Support
»
Server-side Paging + Server-side Filtering (top row)
« previous
next »
Print
Pages: [
1
]
Author
Topic: Server-side Paging + Server-side Filtering (top row) (Read 3368 times)
nklapper
Pro Deluxe
Newbie
Posts: 17
Server-side Paging + Server-side Filtering (top row)
«
on:
May 18, 2016, 08:23:22 pm »
I am trying to accomplish Server-side Paging + Server-side Filtering (top row) on the same grid.
Can anyone point me to an example with complete Javascript and PHP files available?
Thanks in advance!
Logged
nklapper
Pro Deluxe
Newbie
Posts: 17
Re: Server-side Paging + Server-side Filtering (top row)
«
Reply #1 on:
May 19, 2016, 10:40:14 pm »
I received no response, so...
Should I assume that Server-side Filtering and Servier-side Paging on the same grid is NOT supported?
Please let me know.
Logged
paramvir
Administrator
Hero Member
Posts: 6310
Re: Server-side Paging + Server-side Filtering (top row)
«
Reply #2 on:
May 20, 2016, 09:06:02 pm »
All the relevant PHP scripts are there in the PHP tabs under corresponding demos. Separate PHP file are not available.
Remote paging:
http://paramquery.com/pro/demos/paging
Remote header filtering:
http://paramquery.com/pro/demos/filter_header
Remote sorting:
http://paramquery.com/pro/demos/sorting_remote
When remote paging/filtering/sorting are combined, parameters are send together to the server scripts as mentioned in this topic:
http://paramquery.com/pro/tutorial#topic-remote-requests
In terms of sql query, they can be combined together as:
$sql = "Select field1, field2, ... from table_name ".$filterQuery. " " . $sortQuery. " limit ".$skip." , ".$pq_rPP;
There is also an introductory tutorial which shows how remote filtering/sorting/paging can be combined together.
http://paramquery.com/tutorial/php
but there is difference in name and structure of variables in Pro version.
«
Last Edit: May 20, 2016, 09:07:52 pm by paramquery
»
Logged
Print
Pages: [
1
]
« previous
next »
ParamQuery grid support forum
»
General Category
»
ParamQuery Pro Evaluation Support
»
Server-side Paging + Server-side Filtering (top row)