table pagination and filtering with javascript and php
<p>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.</p>

<p>example:</p>

<pre>
+----------------------------------------------------------------+
|         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        |
+---------------+---------------+-------------+------------------+
| ...           | ...           | ...         | ...              |
+---------------+---------------+-------------+------------------+
</pre>

<p>So, I imagined that there should be two pages: </p>

<ul>
<li>one that generates rows and apply selected filters($_GET) on request </li>
<li>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...</li>
</ul>

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