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 267 1 2023-04-04 Xenos Clarke 3212 1
2 268 0 0000-00-00 Cooper Jensen 656 a
3 269 1 0000-00-00 Xenos Clarke 1 1
4 270 0 0000-00-00 0
5 271 100 2023-04-20 1020 Completed
6 272 1 2023-04-05 100 2
7 273 12 2023-04-06 Xenos Clarke 5 Completed
8 274 3453 2023-04-19 0 sdaf
9 275 0 0000-00-00 0
10 276 0 0000-00-00 0
11 277 0 0000-00-00 0
12 278 1 2023-05-08 10 xyz
13 279 123456 2023-05-09 12 sent
14 280 0 0000-00-00 0
15 281 0 0000-00-00 0
16 282 23 2023-05-12 Xenos Clarke 0 0,1
17 283 0 0000-00-00 0
18 284 0 0000-00-00 0
19 285 2 2023-05-01 qxsd 34 ssdcsdc
20 286 0 0000-00-00 hfd 323
21 287 3564 2023-05-11 dssad 23232 adsd
22 288 0 0000-00-00 0
23 289 12336 2016-09-08 Xenos Clarke 12 Completed
24 290 12336 2016-09-08 Xenos Clarke 12 Completed
25 291 12336 2016-09-08 Xenos Clarkemm 12 Completed
26 292 0 0000-00-00 0
27 293 55 2023-05-01 cd 12 5
28 294 55 2023-05-15 cd 12 5
29 295 0 0000-00-00 0
30 296 0 0000-00-00 0
31 297 0 0000-00-00 0
32 298 0 0000-00-00 0
33 299 0 0000-00-00 0
34 300 0 0000-00-00 0
35 301 33 2023-05-01 aaa 111 1
36 302 0 0000-00-00 0
37 303 0 0000-00-00 0
38 304 0 0000-00-00 0
39 305 0 0000-00-00 0
40 306 0 0000-00-00 0
41 307 987663 2023-05-23 pippo 1299 ok
42 308 0 0000-00-00 0
43 309 0 2023-05-22 Fred Flintstone 10 open
44 310 0 0000-00-00 0
45 311 0 0000-00-00 sean 123
46 312 0 0000-00-00 Xenos Clarke 0 wergts
47 313 0 0000-00-00 0
48 314 0 0000-00-00 0
49 315 0 0000-00-00 0
50 316 0 0000-00-00 0
51 317 5451 2023-04-14 Xenos Clarke 3212 AA
52 318 0 0000-00-00 111 222
53 319 0 0000-00-00 varun 50
54 320 0 0000-00-00 Daniel 4000
55 321 1 2023-06-16 test 0 test
# ID Order no Order date Customer name Order amount Order status