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 70 58 2016-09-08 Xenos Clarke 43 Completed
2 76 18 2016-09-08 Xenos Clarke 24 Completed
3 77 75674 2016-09-08 Xenos Clarke 39 Completed
4 78 65775 2016-09-10 Xenos Clarke 25 Completed
5 79 37102 2016-09-08 Xenos Clarke 7 Completed
6 80 74040 2016-09-08 Xenos Clarke 59 Completed
7 81 89592 2016-09-08 Xenos Clarke 76 Completed
8 82 84334 2016-09-08 Deacon Tyson 4 Completed
9 83 91414 2016-09-08 Deacon Tyson 91 Completed
10 84 89834 2016-09-08 Xenos Clarke 41 Completed
11 85 71212 2016-09-08 Cassidy Dyer 33 Completed
12 86 14416 2016-09-08 Rina Lawrence 43 Completed
13 87 22844 2016-09-08 Malcolm Richard 17 Completed
14 88 43892 2016-09-08 Avye Fowler 55 Completed
15 89 72412 2016-09-08 Jeremy Randolph 22 Completed
16 90 64889 2016-09-08 Ray Clayton 46 Completed
17 91 5518 2016-09-08 Lynn Turner 64 Completed
18 92 91680 2016-09-08 Eric Guzman 84 Completed
19 93 31014 2016-09-08 Daphne Preston 27 Completed
20 94 92194 2016-09-08 Ivy Vazquez 81 Completed
21 95 12336 2016-09-08 Teegan Jimenez 26 Completed
22 96 93197 2016-09-08 Quemby Floyd 88 Completed
23 97 74732 2016-09-08 Aristotle Harris 62 Completed
24 98 81261 2016-09-08 Abel Floyd 43 Completed
25 99 21141 2016-09-08 Liberty Gomez 32 Completed
26 128 5 2016-09-09 44 55 33
27 131 2222 2016-12-08 sdfsdfc 0 yxcyxc
28 134 20 2016-12-07 ason 200 ok
29 135 1 2016-12-15 qsd 0 0
30 138 444 2016-12-01 ppp 10 0
31 140 1 2019-04-24 111 1 1
32 141 1 2019-04-01 a 1 replace
33 142 12323 0000-00-00 weqe 0 qweq
34 143 12345 0000-00-00 123123 123123123 123123
35 144 3 2024-01-18 Fart 3 1
36 145 3 2024-01-18 Fart 3 1
37 146 0 2024-01-01 Mustermann 2500 ok
38 147 0 0000-00-00 0
39 148 3 0000-00-00 vvvvvvvvvvvvvvvvvvvvvvvvvvvvvv 0 gh
40 149 9 2024-01-11 Johnny OrderBadass 199 Pending
41 150 23 2024-01-03 kjhgvfcx 45 Completed2
42 151 0 0000-00-00 kjhgvfcx 45
43 152 30771 2016-09-08 Cooper Jensen 45 Completed
44 153 30 2024-01-17 kjhgvfcx 45 Completed2
45 154 96349 2016-09-08 Deacon Tyson 88 Completed
46 155 30771 2016-09-08 Cooper Jensen 45 Completed22
47 156 299 2024-01-10 Carlos 123 New
48 157 388 2024-01-10 Amilcar 1200 New
49 158 0 0000-00-00 564563 10
50 159 0 0000-00-00 0
51 160 101010 2024-01-26 Daniel Lewis 123 sent
52 161 -1 2024-01-11 Thomas 750 Pending
53 162 123 2024-01-11 123 12312312 123
54 163 1 2024-01-09 gggg 0 ggggggggggg
55 164 3 2024-02-08 kjhgvfcx 45 0,1
56 166 555 2024-02-01 fdsdf 0 fsdfdsf
57 167 0 0000-00-00 0
58 168 0 0000-00-00 Xenos ClarkeOOO 500
59 169 1212121212 2024-02-16 DSDSD 12233 121212
60 170 1 2024-02-16 511652 55 Completed
61 171 123 2024-02-01 123 312 0
62 172 1 0000-00-00 1 1 sada
63 173 58 2024-02-07 TTB 123 0
# ID Order no Order date Customer name Order amount Order status