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 80 74040 2016-09-10 Xenos Clar 52 Completed
2 82 84334 2016-09-08 7 Completed
3 83 91414 2016-09-08 91 Completed
4 85 71212 2016-09-08 33 Completed
5 86 14459 2016-09-08 43 Completed
6 87 22844 2016-09-08 17 Completed
7 88 43892 2016-09-08 55 Completed
8 89 72412 2016-09-08 22 Completed
9 90 64889 2016-09-08 Xenos Clarke 46 Completed
10 91 5518 2016-09-08 Cooper Jensen 64 Completed
11 92 91680 2016-09-08 Xenos Clarke 84 Completed
12 93 31014 2016-09-08 Deacon Tyson 27 Completed
13 94 92194 2016-09-08 Ivy Vazquez 81 Completed
14 95 12336 2016-09-08 26 Completed
15 96 93197 2016-09-08 Quemby Floyd 88 Completed
16 97 74732 2016-09-08 Aristotle Harris 62 Completed
17 98 81261 2016-09-08 Abel Floyd 43 Completed
18 99 21141 2016-09-08 Liberty Gomez 32 Completed
19 134 20 2016-12-07 ason 200 ok
20 138 444 2016-12-01 ppp 10 0
21 140 1 2019-04-24 111 1 1
22 141 1 2019-04-01 a 1 Pending
23 143 0 0000-00-00 0
24 144 2 2021-04-15 ert 22 22
25 145 0 0000-00-00 d 0 2
26 146 1 2021-04-08 asdfasdf 12 done
27 147 2 2021-04-08 asdfasdf 12 done
28 148 3 2021-04-08 asdfasdf 12 done
29 150 2147483647 2021-04-08 asdfasdf 12 done
30 151 9999999 2021-04-08 asdfasdf 12 done
31 152 99999991 2021-04-08 asdfasdf 12 done
32 153 99999992 2021-04-08 asdfasdf 12 done
33 154 1 2021-04-01 a 0 a
34 156 0 0000-00-00 0
35 157 0 0000-00-00 0
36 158 0 0000-00-00 0
37 160 0 0000-00-00 0
38 161 3 2021-04-16 sfds 0 dfsd
39 162 3 2021-04-16 sfds 0 dfsd
40 163 34490 2016-09-08 Emily Richmond 77 Completed
41 164 0 0000-00-00 0
42 165 333 2021-04-17 teste 34000 3
43 166 12 2021-04-23 qwq 12 0,1
44 167 111 2021-04-01 fuck me in the ass 2 333
45 168 0 0000-00-00 0
46 169 0 0000-00-00 0
47 170 0 0000-00-00 0
48 171 0 0000-00-00 0
49 172 0 0000-00-00 0
50 173 0 0000-00-00 0
51 174 2 2021-04-17 csdcs 0 fsdfsd
52 175 1 2021-04-14 1 2 3
53 176 12 2021-04-20 111 111 1111
54 177 200 2021-04-21 111 111 1111
55 178 1 2021-04-13 sdf 123 ,0,1
56 179 0 0000-00-00 0
57 180 999 2021-04-26 RRR rrr 11 Ok
58 181 999 2021-04-26 RRR rrr 11 Ok
59 182 4 2021-04-15 MR. rrrr 32 1
60 183 123456 2021-04-21 Adam 0 ASDFADSF
61 184 0 0000-00-00 0
62 185 0 0000-00-00 0
63 186 144 2021-04-21 vdy2 222 8
64 187 121 2021-04-22 wqqw 50 qqq
65 188 1 0000-00-00 3 4 45
66 189 75368356 2021-04-15 John Wayne 64000 Comlpeted
67 190 3254235 2021-04-22 mskdfmlksamdf 0 lkmsaflkmasdfm
68 191 1 2021-04-22 csd 3231
69 192 0 0000-00-00 0
70 193 1 2021-04-09 client001 100 draft
71 194 123 2021-04-08 birkner 100 draft
72 195 1 2021-04-13 qwerghjhgfds 0 sdfgbhnmnbgfd
73 196 10 2021-04-09 0111 1 dddd
74 197 100 2021-04-26 BSIM 0 TESE
75 198 1 2021-04-27 test 200 1
76 199 0 0000-00-00 0
77 200 6565 2021-04-10 sara 500 ,1
78 201 1 2021-04-09 test customer 23000 0
79 202 121 2021-04-08 Bloggs Bloggins 23 Bonza
80 203 0 0000-00-00 0
81 204 0 0000-00-00 0
82 205 0 0000-00-00 0
83 206 123 2021-04-01 test test 123 ,0,1
84 207 0 0000-00-00 0
85 208 0 0000-00-00 0
86 209 0 0000-00-00 0
87 210 0 0000-00-00 0
88 211 67 2021-05-19 YJU 0 J
89 212 0 0000-00-00 233 123
90 213 0 0000-00-00 0
91 214 0 0000-00-00 0
92 215 35453 2021-05-04 odjsn 287 ijasoid
93 216 91617 2021-05-12 a 100 ok
94 217 0 0000-00-00 0
95 218 0 0000-00-00 0
96 11111 87594 2016-09-08 Xenos Clarke 77 Pending
97 11113 0 0000-00-00 0
98 11114 1 2022-06-18 cxcxc 0 cxcx
99 11115 0 0000-00-00 0
100 11116 1 0000-00-00 1 1 1
101 11117 1 2021-05-05 cmc 444 333
102 11118 0 0000-00-00 0
103 11119 74040 2016-09-10 Xenos Clarke 52 Completed
104 11120 0 0000-00-00 fghdfgh 0
105 11121 0 0000-00-00 0
# ID Order no Order date Customer name Order amount Order status