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