PDOCrud sql operation

Render sql helps to display the data in grid/table format. You can write sql select statement to display data in the grid format. Please note that since sql statement can be of any type so the default grid function will not work with this sql render. From version 2.4, the pagination, records per page and display of total records is also removed. A better option to use the sql render with the jquery datatable plugin. You can see example here

  
                                 $pdocrud = new PDOCrud();
                                $pdocrud->setQuery("select * from orders");                
                                echo $pdocrud->render("SQL");
                                

# 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