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 62 34490 2016-09-08 Cooper Jensen 88 Completed
2 63 37920 2016-09-08 0 Completed
3 64 28431 2016-09-08 0 Completed
4 65 94701 2016-09-08 0 Completed
5 66 36440 2016-09-08 0 Completed
6 67 37251 2016-09-08 64 Completed
7 68 35643 2016-09-08 95 Completed
8 69 9551 2016-09-08 89 Completed
9 70 44898 2016-09-08 43 Completed
10 71 91617 2016-09-08 57 Completed
11 72 78062 2016-09-08 56 Completed
12 73 87594 2016-09-08 7 Completed
13 74 24386 2016-09-08 70 Completed
14 75 49890 2016-09-08 27 Completed
15 76 42911 2016-09-08 24 Completed
16 77 75674 2016-09-08 39 Pending
17 78 65775 2016-09-08 25 Completed
18 79 37102 2016-09-08 7 Completed
19 80 74040 2016-09-08 59 Completed
20 81 89592 2016-09-08 76 Completed
21 82 84334 2016-09-08 4 Completed
22 83 91414 2016-09-08 91 Completed
23 84 89834 2016-09-08 41 Completed
24 85 71212 2016-09-08 33 Completed
25 86 14459 2016-09-08 43 Completed
26 87 22844 2016-09-08 17 Completed
27 88 43892 2016-09-08 55 Completed
28 89 72412 2016-09-08 22 Completed
29 90 64889 2016-09-08 46 Completed
30 91 5518 2016-09-08 64 Completed
31 92 91680 2016-09-08 84 Completed
32 93 31014 2016-09-08 27 Completed
33 94 92194 2016-09-08 81 Completed
34 95 12336 2016-09-08 26 Completed
35 96 93197 2016-09-08 88 Completed
36 97 74732 2016-09-08 62 Completed
37 98 81261 2016-09-08 43 Completed
38 99 21141 2016-09-08 32 Completed
39 128 5 2016-09-09 55 33
40 131 2222 2016-12-08 0 yxcyxc
41 135 1 2016-12-15 0 0
42 138 444 2016-12-01 10 0
43 140 1 2019-04-24 1 1
44 141 1 2019-04-01 1 Pending
45 142 23 2020-09-10 400 emi
46 143 23 2020-09-10 400 emi
47 144 0 0000-00-00 0
48 145 0 0000-00-00 0
49 146 0 0000-00-00 0
50 147 0 0000-00-00 0
51 148 0 0000-00-00 0
52 149 0 0000-00-00 0
53 150 44 2020-09-02 5 placed
54 151 66 2020-09-03 0
55 152 66 2020-09-03 0 1
56 153 0 0000-00-00 0
57 154 0 0000-00-00 0
58 155 0 0000-00-00 0
59 156 0 0000-00-00 0
60 157 2222 0000-00-00 150 1
61 158 0 0000-00-00 231132
62 159 888 2020-09-19 3333 3
63 160 2147483647 2020-09-24 44 44
64 161 0 0000-00-00 0
65 162 0 0000-00-00 0
66 163 0 0000-00-00 0
67 164 12 2020-09-03 44 goof
68 165 0 0000-00-00 Cooper Jensen 100
69 166 181 2020-09-17 7500 Active
70 167 0 0000-00-00 0
71 168 10 2020-09-03 100 0
72 169 10 2020-09-02 100 0
73 171 10 2020-09-02 100 0
74 172 444 2020-09-09 122333 sdfdff
75 173 444 2020-09-09 122333 sdfdff
76 174 90 2020-09-10 0 lkj
77 175 3 2020-09-30 0 Hoooo
78 176 10 2020-09-16 123 1
79 177 19 2020-09-30 Sis 200 Shipping
80 178 0 0000-00-00 0
81 179 0 0000-00-00 0
82 180 45 2020-09-09 45 45 45
83 181 48121 2016-09-08 Deacon Tyson 0 Completed
84 182 0 0000-00-00 0
85 183 0 0000-00-00 0
86 184 0 0000-00-00 0
87 185 48121 2016-09-08 Deacon Tyson 0 Completed
88 186 12 2020-09-02 jdfj 1 1
89 187 0 0000-00-00 0
90 188 0 0000-00-00 0
91 189 0 0000-00-00 0
# ID Order no Order date Customer name Order amount Order status