Plugin data table example jquery data table plugin (Added in version 2.4)

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

Plugin data table example - PDOCrud

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'digjainwi_allsanghinfodev.orders' doesn't exist