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 66 36440 2016-09-08 Heather Terrell 8 Completed
2 67 37251 2016-09-08 Rose Barry 64 Completed
3 68 35643 2016-09-08 Bernard Gilmore 95 Completed
4 69 9551 2016-09-08 Meghan Mack 89 Completed
5 70 44898 2016-09-08 Lillith Terrell 43 Completed
6 71 91617 2016-09-08 Jaquelyn James 57 Completed
7 72 78062 2016-09-08 Karly Beard 56 Completed
8 73 87594 2016-09-08 Kareem Cooke 7 Completed
9 74 24386 2016-09-08 Amethyst Bass 70 Completed
10 75 49890 2016-09-08 Silas Bates 27 Completed
11 76 42911 2016-09-08 Sybil Watts 24 Completed
12 77 75674 2016-09-08 Warren Hays 39 Completed
13 78 65775 2016-09-08 Kirsten Martin 25 Completed
14 79 37102 2016-09-08 Cade Lowe 7 Completed
15 80 74040 2016-09-08 Penelope Moss 59 Completed
16 81 89592 2016-09-08 Chase Andrews 76 Completed
17 82 84334 2016-09-08 Fatima Mcconnell 4 Completed
18 83 91414 2016-09-08 Kelly Garcia 91 Completed
19 84 89834 2016-09-08 Aubrey Leblanc 41 Completed
20 85 71212 2016-09-08 Cassidy Dyer 33 Completed
21 86 14459 2016-09-08 Rina Lawrence 43 Completed
22 87 22844 2016-09-08 Malcolm Richard 17 Completed
23 88 43892 2016-09-08 Avye Fowler 55 Completed
24 89 72412 2016-09-08 Jeremy Randolph 22 Completed
25 90 64889 2016-09-08 Ray Clayton 46 Completed
26 91 5518 2016-09-08 Lynn Turner 64 Completed
27 92 91680 2016-09-08 Eric Guzman 84 Completed
28 93 31014 2016-09-08 Daphne Preston 27 Completed
29 94 92194 2016-09-08 Ivy Vazquez 81 Completed
30 95 12336 2016-09-08 Teegan Jimenez 26 Completed
# ID Order no Order date Customer name Order amount Order status