table pagination and filtering with javascript and php

Question

Hello,

Let's say that you have to generate and display a table after querying a database using PHP. The table might have a lot of rows. One must be able to filter the resulting table using different criteria (single or multiple selections), much like an Excel table.

example:

+----------------------------------------------------------------+
|         id    |     name      |   type      |    description   |
+----------------------------------------------------------------+
| input search  | input search  | drop down   | drop down        |
| by id field   | by name field | type select | sort asc/desc    |
+---------------+---------------+-------------+------------------+
| 1             | exampe_name   | type 1      | bla bla          |
+---------------+---------------+-------------+------------------+
| 2             | exampe_name 2 | type 2      | tra la la        |
+---------------+---------------+-------------+------------------+
| ...           | ...           | ...         | ...              |
+---------------+---------------+-------------+------------------+

So, I imagined that there should be two pages:

• one that generates rows and apply selected filters($_GET) on request
• a second page which displays the table, using some javascript stuff to keep track of the selected criteria, pagination, reload content on filter change and smooth display...

Has anybody encountered such kind of tasks? If yes, please share your solution, thanks in advance.

Answer 1

Take a look at the following: http://ideamill.synaptrixgroup.com/?page_id=16 Might that be what you're looking to do?

Answer 2

This one is a JQuery plugin which looks good: http://www.picnet.com.au/blogs/Guido/post/2009/06/29/JQuery-Table-Filter-Plugin.aspx

Thanks