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 51 37429 2021-03-11 Xenos Clarke 78 Completed
2 52 1234567 2016-09-08 Xenos Clarke 26 Completed
3 55 83323 2016-09-08 Xenos Clarke 37 Completed
4 56 409 2016-09-08 Cooper Jensen 68 Completed
5 57 50683 2016-09-08 Deacon Tyson 28 Completed
6 59 48121 2016-09-08 1 Completed
7 61 37748 2016-09-08 Cooper Jensen 73 Completed
8 63 37920 2016-09-08 67 Completed
9 64 28431 2016-09-08 5 Completed
10 65 94701 2016-09-08 25 Completed
11 66 36440 2016-09-08 Heather Terrell 8 Completed
12 67 37251 2016-09-08 64 Completed
13 68 35643 2016-09-08 Bernard Gilmore 95 Completed
14 69 9551 2016-09-08 Meghan Mack 89 Completed
15 70 44898 2016-09-08 Lillith Terrell 43 Completed
16 71 91617 2016-09-08 Jaquelyn James 57 Completed
17 72 78062 2016-09-08 Karly Beard 56 Completed
18 73 87594 2016-09-08 Kareem Cooke 7 Completed
19 74 24386 2016-09-08 Amethyst Bass 70 Completed
20 78 65775 2016-09-08 Kirsten Martin 25 Completed
21 79 37102 2016-09-08 Cade Lowe 7 Completed
22 80 74040 2016-09-08 Penelope Moss 59 Completed
23 81 89592 2016-09-08 Chase Andrews 76 Completed
24 82 84334 2016-09-08 Fatima Mcconnell 4 Completed
25 83 91414 2016-09-08 Kelly Garcia 91 Completed
26 84 89834 2016-09-08 Aubrey Leblanc 41 Completed
27 85 71212 2016-09-08 Cassidy Dyer 33 Completed
28 86 14459 2016-09-08 43 Completed
29 87 22844 2016-09-08 Malcolm Richard 17 Completed
30 88 43892 2016-09-08 Avye Fowler 55 Completed
31 89 72412 2016-09-08 Jeremy Randolph 22 Completed
32 90 64889 2016-09-08 46 Completed
33 91 5518 2016-09-08 Lynn Turner 64 Completed
34 92 91680 2016-09-08 Eric Guzman 84 Completed
35 93 31014 2016-09-08 Daphne Preston 27 Completed
36 94 92194 2016-09-08 Ivy Vazquez 81 Completed
37 95 12336 2016-09-08 26 Completed
38 96 93197 2016-09-08 Quemby Floyd 88 Completed
39 97 74732 2016-09-08 Aristotle Harris 62 Completed
40 98 81261 2016-09-08 Abel Floyd 43 Completed
41 99 21141 2016-09-08 Liberty Gomez 32 Completed
42 134 20 2016-12-07 ason 200 ok
43 138 444 2016-12-01 ppp 10 0
44 140 1 2019-04-24 111 1 1
45 141 1 2019-04-01 a 1 Pending
46 143 0 0000-00-00 0
47 144 2 2021-04-15 ert 22 22
48 145 0 0000-00-00 0
49 146 1 2021-04-08 asdfasdf 12 done
50 147 2 2021-04-08 asdfasdf 12 done
51 148 3 2021-04-08 asdfasdf 12 done
52 150 2147483647 2021-04-08 asdfasdf 12 done
53 151 9999999 2021-04-08 asdfasdf 12 done
54 152 99999991 2021-04-08 asdfasdf 12 done
55 153 99999992 2021-04-08 asdfasdf 12 done
56 154 1 2021-04-01 a 0 a
57 155 23 2021-04-14 xxxxxxx 33333 Y
58 156 0 0000-00-00 0
59 157 0 0000-00-00 0
60 158 0 0000-00-00 0
61 159 77 2021-04-17 Test User 123 done
62 160 0 0000-00-00 0
63 161 3 2021-04-16 sfds 0 dfsd
64 162 3 2021-04-16 sfds 0 dfsd
65 163 34490 2016-09-08 Emily Richmond 77 Completed
66 164 0 0000-00-00 0
67 165 333 2021-04-17 teste 34000 3
68 166 12 2021-04-23 qwq 12 0,1
69 167 111 2021-04-01 fuck me in the ass 2 333
70 168 0 0000-00-00 0
71 169 0 0000-00-00 0
72 170 0 0000-00-00 0
73 171 0 0000-00-00 0
74 172 0 0000-00-00 0
75 173 0 0000-00-00 0
76 174 2 2021-04-17 csdcs 0 fsdfsd
77 175 1 2021-04-14 1 2 3
78 176 12 2021-04-20 111 111 1111
79 177 200 2021-04-21 111 111 1111
80 178 1 2021-04-13 sdf 123 ,0,1
81 179 0 0000-00-00 0
82 180 999 2021-04-26 RRR rrr 11 Ok
83 181 999 2021-04-26 RRR rrr 11 Ok
84 182 4 2021-04-15 MR. rrrr 32 1
85 183 123456 2021-04-21 Adam 0 ASDFADSF
# ID Order no Order date Customer name Order amount Order status