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

# ID Order no Order date Customer name Order amount Order status
1 172 27 2025-11-04 5006 67
2 173 33 2025-09-02 Cooper Jensen 1112 Completed
3 174 0 0000-00-00 Cooper Jensen 10
4 176 0 0000-00-00 10
5 178 33 2025-09-02 Deacon Tyson 111 ok
6 179 33 2025-09-02 Deacon Tyson 111 ok
7 182 1 2025-07-01 Deacon Tyson 82325 Pending
8 184 576749678 2025-09-03 Cooper Jensen 798797 asdas
9 185 0 0000-00-00 Xenos Clarke 0 1
10 186 -1 2025-10-02 Cooper Jensen 0 ??
11 187 34 2025-10-16 111 g
12 188 4343 2025-10-16 4 r
13 189 0 0000-00-00 0
14 190 27 0000-00-00 Xenos Clarke 500 67
15 191 28 0000-00-00 Xenos Clarke 500 67
16 193 234234 0000-00-00 32????? 34 ?????
# ID Order no Order date Customer name Order amount Order status