ParamQuery grid support forum

General Category => ParamQuery Pro Evaluation Support => Topic started by: nklapper on May 18, 2016, 08:23:22 pm

Title: Server-side Paging + Server-side Filtering (top row)
Post by: nklapper 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!

Title: Re: Server-side Paging + Server-side Filtering (top row)
Post by: nklapper 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.

Title: Re: Server-side Paging + Server-side Filtering (top row)
Post by: paramvir 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.