Remote Sorting Data Grid (With Paging)
I'm sure this has been asked before, but I couldn't find anything through googling :-\
Basically, I have a database with ~ 1300 rows. I'm displaying this in a data grid. I have paging setup, with this grid, to display 30 rows per page.
I'd like to add sorting to this, but, (of course) that's page specific. I know I'll have to do some kind of "remote sorting", but I'm not sure exactly how this is done.
If anyone can give me hints as to how to do that (using PHP server-side), I'd be very happy.
Also, I plan to add the filtering plugin to this page, will that affect my sorting?
Thanks in advance!
Actually, I may have figured it out (wasn't aware clicking a sort header, would send two new
post values, sort and dir, with remoteSorting enabled).
Anyway, will this be affected by my filtering?
You might be interested in the Grid FAQ, not to mention the example in my signature (php, filtering, remote sorting, yada, yada, and yada).