Author Topic: Server-side Paging + Server-side Filtering (top row)  (Read 3368 times)

nklapper

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 17
    • View Profile
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!

nklapper

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 17
    • View Profile
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.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
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 »