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 67 37251 2016-09-16 Cooper Jensen 64 Completed
2 68 35643 2016-09-08 95 Completed
3 69 9551 2016-09-08 89 Completed
4 70 44898 2016-09-08 43 Completed
5 71 91617 2016-09-08 57 Completed
6 72 78062 2016-09-08 56 Completed
7 73 87594 2016-09-08 7 Completed
8 74 24386 2016-09-08 70 Completed
9 75 49890 2016-09-08 27 Completed
10 76 42911 2016-09-08 Sybil Watts 24 Completed
11 77 75674 2016-09-08 Warren Hays 39 Completed
12 78 65775 2016-09-08 Kirsten Martin 25 Completed
13 79 37102 2016-09-08 7 Completed
14 80 74040 2016-09-08 Penelope Moss 59 Completed
15 81 89592 2016-09-08 Chase Andrews 76 Completed
16 82 84334 2016-09-08 4 Completed
17 83 91414 2016-09-08 Kelly Garcia 91 Completed
18 84 89834 2016-09-08 Aubrey Leblanc 41 Completed
19 85 71212 2016-09-08 Cassidy Dyer 33 Completed
20 86 14459 2016-09-08 Rina Lawrence 43 Completed
21 87 22844 2016-09-08 Malcolm Richard 17 Completed
22 88 43892 2016-09-08 Avye Fowler 55 Completed
23 89 72412 2016-09-08 Jeremy Randolph 22 Completed
24 90 64889 2016-09-08 Ray Clayton 46 Completed
25 91 5518 2016-09-08 Lynn Turner 64 Completed
26 92 91680 2016-09-08 Eric Guzman 84 Completed
27 93 31014 2016-09-08 Daphne Preston 27 Completed
28 94 92194 2016-09-08 Ivy Vazquez 81 Completed
29 95 12336 2016-09-08 Teegan Jimenez 26 Completed
30 96 93197 2016-09-08 Xenos Clarke 88 Completed
31 97 74732 2016-09-08 62 Completed
32 98 81261 2016-09-08 43 Completed
33 99 21141 2016-09-08 32 Completed
34 128 5 2016-09-09 55 33
35 131 2222 2016-12-08 Xenos Clarke 600 yxcyxc
36 134 20 2016-12-07 200 ok
37 135 1 2016-12-15 0 0
38 138 444 2016-12-01 10 0
39 140 1 2019-04-24 1 1
40 141 1 2019-04-01 1 Pending
41 142 123 2020-03-11 poiuytrewq 123456 yes
42 143 8977 2020-03-18 Rolf 767 Complet
43 144 12323456 2020-03-11 0 asads
44 145 0 0000-00-00 Hhh 45
45 146 0 0000-00-00 Hhh 45
46 147 0 2020-03-18 dfgafadfaf 10000 1
47 148 0 0000-00-00 0
48 149 0 0000-00-00 0
49 150 0 0000-00-00 0
50 151 353 2020-03-11 Cooper Jensenh 45535 53535
51 152 0 0000-00-00 0
52 153 11 2020-03-22 11 11 11
53 154 44 2020-03-24 44 44 44
54 155 0 0000-00-00 0
55 156 9182 2020-03-20 Ksk 23 tmm
56 157 0 0000-00-00 0
57 158 48 2020-03-20 111 11 11
58 159 0 0000-00-00 0
59 160 -1 2020-03-17 t3425 23425 0,1
60 161 0 0000-00-00 0
61 162 22222 2020-03-26 ss 0 ss
62 163 0 0000-00-00 0
63 164 0 0000-00-00 0
64 165 0 0000-00-00 0
65 166 0 0000-00-00 0
66 167 0 0000-00-00 0
67 168 0 0000-00-00 0
68 169 0 0000-00-00 fgfg 232
69 170 7 2020-03-13 41414 88 Completed
70 171 2 2020-03-26 dsds 0 0,1
71 172 0 0000-00-00 0
72 173 0 0000-00-00 0
73 174 0 0000-00-00 0
74 175 0 0000-00-00 0
75 176 90 2020-03-01 sriram 2000 pending
76 177 0 0000-00-00 0
77 178 0 0000-00-00 0
78 179 93063 2016-09-09 Xenos Clarke 900 Pending1
79 180 93063 2016-09-09 Xenos Clarke 900 Pending1
80 181 7667676 2020-03-10 yuyjyujuyjyujyuj 6786 6786
81 182 93064 2016-09-09 Xenos Clark 0 Completed
82 183 55 2020-03-20 Rolf 767 sent
83 184 0 0000-00-00 0
84 185 0 0000-00-00 0
85 186 0 2016-09-09 Xenos Clark 4 Completed
86 187 0 2016-09-09 Xenos Clark 4 Completed
87 188 0 2016-09-09 Xenos Clark 4 Completed
88 189 111 2016-09-09 Xenos Clark 4 Completed
89 190 30771 2016-09-08 Xenos Clarke 4610 Completed
90 191 0 2016-09-09 AO 4 Completed
91 192 69 2020-03-28 Cooper Jensen 1 Now
92 193 1 2020-03-27 Deacon Tyson 1 1
93 194 2147483647 2020-03-12 -73 Completed
94 195 2147483647 2020-03-12 -73 Completed
95 196 4 0000-00-00 450 completo
96 197 4 0000-00-00 450 completo
97 198 45 0000-00-00 450 completo
98 199 5 2020-03-19 55 55 55
99 200 0 0000-00-00 0
100 201 0 0000-00-00 0
101 202 0 0000-00-00 0
102 203 2 2016-09-05 mumu 95 noy complet*
103 204 1 2016-09-05 sa 87 Completed
104 205 0 0000-00-00 0
105 206 0 0000-00-00 0
106 207 0 0000-00-00 0
107 208 0 0000-00-00 0
108 209 -2 2020-03-03 dirt 55 test
109 210 0 0000-00-00 0
110 211 0 0000-00-00 0
111 212 0 0000-00-00 0
112 213 0 0000-00-00 0
113 214 0 0000-00-00 0
114 215 1 2020-03-24 dssssssssssssssssssssssssgfsg fdsgdfdfjlghkldfjgkljdfklgj dssssssssssssssssssssssssgfsg fdsgdfdfjlghkldfjgkljdfklgjdssssssssssssssssssssssssgfsg fdsgdfdfjlghkldfjgkljdfklgj dssssssssssssssssssssssssgfsg fdsgdfdfjlghkldfjgkljdfklgj dssssssssssssssssss 33 a
115 216 0 0000-00-00 0
116 217 81 2020-04-07 ASD 0 213
117 218 5 2020-04-08 fdsgfdsf 43242 dsfsdf
118 220 94701 2016-09-08 Xenos Clarke 25 Completed
119 221 1 2020-04-08 Test 1 1
# ID Order no Order date Customer name Order amount Order status