jQuery based data table plugin is quite useful in term of no. of function it has. With our script, if you want to use the sql and still want search/sorting/pagination etc functions, you can use this plugin. You will have most of the grid/table functionality using this.
$pdocrud = new PDOCrud(); $pdocrud->addPlugin("datatable");//to add plugin $pdocrud->setQuery("select * from orders"); echo $pdocrud->render("SQL"); echo $pdocrud->loadPluginJsCode("datatable",".pdocrud-table");//to add plugin call on input[type=text] elements