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");

Deprecated: Optional parameter $op declared before required parameter $task is implicitly treated as a required parameter in /home3/openscri/public_html/masinosinaga/pdo-crud/script/classes/PDOCrud.php on line 983

Deprecated: Creation of dynamic property PDOCrud::$langData is deprecated in /home3/openscri/public_html/masinosinaga/pdo-crud/script/classes/PDOCrud.php on line 2227

Deprecated: Optional parameter $page declared before required parameter $totalrecords is implicitly treated as a required parameter in /home3/openscri/public_html/masinosinaga/pdo-crud/script/classes/PDOCrudHelper.php on line 191

Deprecated: Optional parameter $parameters declared before required parameter $data is implicitly treated as a required parameter in /home3/openscri/public_html/masinosinaga/pdo-crud/script/classes/PDOCrudTableFormat.php on line 122

Deprecated: Creation of dynamic property PDOModel::$characterSet is deprecated in /home3/openscri/public_html/masinosinaga/pdo-crud/script/classes/PDOModel.php on line 119

Deprecated: strtoupper(): Passing null to parameter #1 ($string) of type string is deprecated in /home3/openscri/public_html/masinosinaga/pdo-crud/script/classes/PDOModel.php on line 1011

Deprecated: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /home3/openscri/public_html/masinosinaga/pdo-crud/script/classes/PDOCrud.php on line 3104

Deprecated: Creation of dynamic property PDOCrud::$dataHTML is deprecated in /home3/openscri/public_html/masinosinaga/pdo-crud/script/classes/PDOCrud.php on line 2379

Deprecated: Creation of dynamic property PDOCrud::$fieldList is deprecated in /home3/openscri/public_html/masinosinaga/pdo-crud/script/classes/PDOCrud.php on line 2380

# ID Order no Order date Customer name Order amount Order status
1 41 76778 2016-09-08 Xenos Clarke 77 Pending
2 42 66729 2016-09-08 Deacon Tyson 90 Completed
3 43 62940 2016-09-08 Xenos Clarke 20 Completed
4 44 22241 2016-09-08 Cecilia Carney 29 Completed
5 45 40334 2016-09-08 Connor Marquez 87 Completed
6 46 30771 2016-09-08 Gillian Kirk 461 Completed
7 47 96349 2016-09-08 Wallace Gillespie 71 Completed
8 48 72881 2016-09-08 Risa Ayers 18 Completed
9 49 3691 2016-09-08 Callum Solomon 75 Completed
10 50 77099 2016-09-08 Nola Rojas 20 Completed
11 51 37429 2016-09-08 Talon Rowland 77 Completed
12 52 44144 2016-09-08 Cheryl Bowers 26 Completed
13 53 62391 2016-09-08 Bree Gaines 96 Completed
14 54 54999 2016-09-08 Lacota Bonner 5 Completed
15 55 83323 2016-09-08 Bradley Freeman 37 Completed
16 56 409 2016-09-08 Jasper Santiago 68 Completed
17 57 50683 2016-09-08 Hilary Conner 28 Completed
18 58 931435 2016-09-08 Zena Fox 37 Completed
19 59 48121 2016-09-08 Britanni Schmidt 1 Completed
20 60 74815 2016-09-08 Caleb Lynn 95 Completed
21 61 37748 2016-09-08 Madeson Robbins 73 Completed
22 62 34490 2016-09-08 Emily Richmond 77 Completed
23 63 37920 2016-09-08 Damian Wilson 67 Completed
24 64 28431 2016-09-08 Mikayla Mendez 5 Completed
25 65 94701 2016-09-08 Igor Gutierrez 25 Completed
26 66 36440 2016-09-08 Heather Terrell 8 Completed
27 67 37251 2016-09-08 Rose Barry 64 Completed
28 68 35643 2016-09-08 Bernard Gilmore 95 Completed
29 69 9551 2016-09-08 Meghan Mack 89 Completed
30 70 44898 2016-09-08 Lillith Terrell 43 Completed
31 71 91617 2016-09-08 Jaquelyn James 57 Completed
32 72 78062 2016-09-08 Karly Beard 56 Completed
33 73 87594 2016-09-08 Kareem Cooke 7 Completed
34 74 24386 2016-09-08 Amethyst Bass 70 Completed
35 75 49890 2016-09-08 Silas Bates 27 Completed
36 76 42911 2016-09-08 Sybil Watts 24 Completed
37 77 75674 2016-09-08 Warren Hays 39 Completed
38 78 65775 2016-09-08 Kirsten Martin 25 Completed
39 79 37102 2016-09-08 Cade Lowe 7 Completed
40 80 74040 2016-09-08 Penelope Moss 59 Completed
41 81 89592 2016-09-08 Chase Andrews 76 Completed
42 82 84334 2016-09-08 Fatima Mcconnell 4 Completed
43 83 91414 2016-09-08 Kelly Garcia 91 Completed
44 84 89834 2016-09-08 Aubrey Leblanc 41 Completed
45 85 71212 2016-09-08 Cassidy Dyer 33 Completed
46 86 14459 2016-09-08 Rina Lawrence 43 Completed
47 87 22844 2016-09-08 Malcolm Richard 17 Completed
48 88 43892 2016-09-08 Avye Fowler 55 Completed
49 89 72412 2016-09-08 Jeremy Randolph 22 Completed
50 90 64889 2016-09-08 Ray Clayton 46 Completed
51 91 5518 2016-09-08 Lynn Turner 64 Completed
52 92 91680 2016-09-08 Eric Guzman 84 Completed
53 93 31014 2016-09-08 Daphne Preston 27 Completed
54 94 92194 2016-09-08 Ivy Vazquez 81 Completed
55 95 12336 2016-09-08 Teegan Jimenez 26 Completed
56 96 93197 2016-09-08 Quemby Floyd 88 Completed
57 97 74732 2016-09-08 Aristotle Harris 62 Completed
58 98 81261 2016-09-08 Abel Floyd 43 Completed
59 99 21141 2016-09-08 Liberty Gomez 32 Completed
60 128 5 2016-09-09 44 55 33
61 131 2222 2016-12-08 sdfsdfc 0 yxcyxc
62 134 20 2016-12-07 ason 200 ok
63 135 1 2016-12-15 qsd 0 0
64 138 444 2016-12-01 ppp 10 0
65 140 1 2019-04-24 111 1 1
66 141 1 2019-04-01 a 1 Pending
67 142 0 0000-00-00 0
68 143 23 2021-09-08 rrr 0 ee
69 144 0 0000-00-00 0
# ID Order no Order date Customer name Order amount Order status