PDOCrud raw data operation/small>

PDOCrud uses PDOModel for database related operations. It supports all pdomodel functions. You can refer pdomodel documentation here.

  
                            $pdocrud = new PDOCrud();               
                            //insert operation
                            $insertData = array("customer_name" => "bob", "email" => "builder@gmail.com", "postal_code" =>99423);
                            $pdocrud->getPDOModelObj()->insert("customertable", $insertData);
                            //update operation
                            //Example 2
                            $updateData = array("first_name"=>"Jon", "last_name"=>"snow", "email"=>"builder@gmail.com");
                            $pdomodel = $pdocrud->getPDOModelObj();
                            $pdomodel->where("id", 1);
                            $pdomodel->update("feedback", $updateData);

                            //Example 3
                            //select operation
                            $data =  $pdocrud->getPDOModelObj()->select("orders");
                            print_r($data);
                            
Array
(
    [0] => Array
        (
            [ID] => 64
            [order_no] => 28431
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 5
            [order_status] => Completed
        )

    [1] => Array
        (
            [ID] => 65
            [order_no] => 94701
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 25
            [order_status] => Completed
        )

    [2] => Array
        (
            [ID] => 66
            [order_no] => 36440
            [order_date] => 2016-09-08
            [customer_name] => Deacon Tyson
            [order_amount] => 8
            [order_status] => Completed
        )

    [3] => Array
        (
            [ID] => 67
            [order_no] => 37251
            [order_date] => 2016-09-08
            [customer_name] => Cooper Jensen
            [order_amount] => 44
            [order_status] => Completed
        )

    [4] => Array
        (
            [ID] => 68
            [order_no] => 35643
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 0
            [order_status] => Completed
        )

    [5] => Array
        (
            [ID] => 69
            [order_no] => 9551
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 89
            [order_status] => Completed
        )

    [6] => Array
        (
            [ID] => 70
            [order_no] => 44898
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 43
            [order_status] => Completed
        )

    [7] => Array
        (
            [ID] => 71
            [order_no] => 91617
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 57
            [order_status] => Completed
        )

    [8] => Array
        (
            [ID] => 72
            [order_no] => 78062
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 56
            [order_status] => Completed
        )

    [9] => Array
        (
            [ID] => 73
            [order_no] => 87594
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 7
            [order_status] => Completed
        )

    [10] => Array
        (
            [ID] => 74
            [order_no] => 24386
            [order_date] => 2016-09-08
            [customer_name] => Amethss faBIO
            [order_amount] => 70
            [order_status] => Completed
        )

    [11] => Array
        (
            [ID] => 75
            [order_no] => 49890
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 27
            [order_status] => Completed
        )

    [12] => Array
        (
            [ID] => 76
            [order_no] => 42911
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 24
            [order_status] => Completed
        )

    [13] => Array
        (
            [ID] => 77
            [order_no] => 75674
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 39
            [order_status] => Completed
        )

    [14] => Array
        (
            [ID] => 78
            [order_no] => 65775
            [order_date] => 2016-09-08
            [customer_name] => Kirsten Martin
            [order_amount] => 25
            [order_status] => Completed
        )

    [15] => Array
        (
            [ID] => 79
            [order_no] => 37102
            [order_date] => 2016-09-08
            [customer_name] => Cade Lowe
            [order_amount] => 7
            [order_status] => Completed
        )

    [16] => Array
        (
            [ID] => 82
            [order_no] => 84334
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 4
            [order_status] => Completed
        )

    [17] => Array
        (
            [ID] => 83
            [order_no] => 91414
            [order_date] => 2016-09-08
            [customer_name] => Kelly Garcia
            [order_amount] => 91
            [order_status] => Completed
        )

    [18] => Array
        (
            [ID] => 84
            [order_no] => 89834
            [order_date] => 2016-09-08
            [customer_name] => Aubrey Leblanc
            [order_amount] => 41
            [order_status] => Completed
        )

    [19] => Array
        (
            [ID] => 85
            [order_no] => 71212
            [order_date] => 2016-09-08
            [customer_name] => Cassidy Dyer
            [order_amount] => 33
            [order_status] => Completed
        )

    [20] => Array
        (
            [ID] => 86
            [order_no] => 14459
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 43
            [order_status] => Completed
        )

    [21] => Array
        (
            [ID] => 87
            [order_no] => 22844
            [order_date] => 2016-09-08
            [customer_name] => Malcolm Richard
            [order_amount] => 17
            [order_status] => Completed
        )

    [22] => Array
        (
            [ID] => 88
            [order_no] => 43892
            [order_date] => 2016-09-08
            [customer_name] => Avye Fowler
            [order_amount] => 55
            [order_status] => Completed
        )

    [23] => Array
        (
            [ID] => 89
            [order_no] => 72412
            [order_date] => 2016-09-08
            [customer_name] => Jeremy Randolph
            [order_amount] => 22
            [order_status] => Completed
        )

    [24] => Array
        (
            [ID] => 90
            [order_no] => 64889
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 46
            [order_status] => Completed
        )

    [25] => Array
        (
            [ID] => 91
            [order_no] => 5518
            [order_date] => 2016-09-08
            [customer_name] => Lynn Turner
            [order_amount] => 64
            [order_status] => Completed
        )

    [26] => Array
        (
            [ID] => 92
            [order_no] => 91680
            [order_date] => 2016-09-08
            [customer_name] => Eric Guzman
            [order_amount] => 84
            [order_status] => Completed
        )

    [27] => Array
        (
            [ID] => 93
            [order_no] => 31014
            [order_date] => 2016-09-08
            [customer_name] => Daphne Preston
            [order_amount] => 27
            [order_status] => Completed
        )

    [28] => Array
        (
            [ID] => 94
            [order_no] => 92194
            [order_date] => 2016-09-08
            [customer_name] => Ivy Vazquez
            [order_amount] => 81
            [order_status] => Completed
        )

    [29] => Array
        (
            [ID] => 95
            [order_no] => 12336
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 26
            [order_status] => Completed
        )

    [30] => Array
        (
            [ID] => 96
            [order_no] => 93197
            [order_date] => 2016-09-08
            [customer_name] => Quemby Floyd
            [order_amount] => 88
            [order_status] => Completed
        )

    [31] => Array
        (
            [ID] => 97
            [order_no] => 74732
            [order_date] => 2016-09-08
            [customer_name] => Aristotle Harris
            [order_amount] => 62
            [order_status] => Completed
        )

    [32] => Array
        (
            [ID] => 98
            [order_no] => 81261
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 43
            [order_status] => Completed
        )

    [33] => Array
        (
            [ID] => 99
            [order_no] => 21141
            [order_date] => 2016-09-08
            [customer_name] => Cooper Jensen
            [order_amount] => 32
            [order_status] => Completed
        )

    [34] => Array
        (
            [ID] => 128
            [order_no] => 5
            [order_date] => 2016-09-09
            [customer_name] => Xenos Clarke
            [order_amount] => 55
            [order_status] => 33
        )

    [35] => Array
        (
            [ID] => 131
            [order_no] => 2222
            [order_date] => 2016-12-08
            [customer_name] => 
            [order_amount] => 34
            [order_status] => yxcyxc
        )

    [36] => Array
        (
            [ID] => 134
            [order_no] => 20
            [order_date] => 2016-12-07
            [customer_name] => 
            [order_amount] => 200
            [order_status] => ok
        )

    [37] => Array
        (
            [ID] => 135
            [order_no] => 1
            [order_date] => 2016-12-15
            [customer_name] => 
            [order_amount] => 33
            [order_status] => 0
        )

    [38] => Array
        (
            [ID] => 138
            [order_no] => 444
            [order_date] => 2016-12-01
            [customer_name] => 
            [order_amount] => 10
            [order_status] => 0
        )

    [39] => Array
        (
            [ID] => 140
            [order_no] => 1
            [order_date] => 2019-04-24
            [customer_name] => 
            [order_amount] => 1
            [order_status] => 1
        )

    [40] => Array
        (
            [ID] => 141
            [order_no] => 1
            [order_date] => 2019-04-01
            [customer_name] => 
            [order_amount] => 1
            [order_status] => Pending
        )

    [41] => Array
        (
            [ID] => 142
            [order_no] => 4
            [order_date] => 2020-05-06
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 1
        )

    [42] => Array
        (
            [ID] => 143
            [order_no] => 1
            [order_date] => 2020-05-06
            [customer_name] => 
            [order_amount] => 0
            [order_status] => dw
        )

    [43] => Array
        (
            [ID] => 144
            [order_no] => 76
            [order_date] => 2020-05-13
            [customer_name] => kjkjkjkjkjk
            [order_amount] => 87878
            [order_status] => 878
        )

    [44] => Array
        (
            [ID] => 151
            [order_no] => 2323
            [order_date] => 2020-05-11
            [customer_name] => Cooper Jensen
            [order_amount] => 0
            [order_status] => sdsds
        )

    [45] => Array
        (
            [ID] => 152
            [order_no] => 123
            [order_date] => 2020-05-01
            [customer_name] => 123
            [order_amount] => 123
            [order_status] => 123
        )

    [46] => Array
        (
            [ID] => 153
            [order_no] => 344
            [order_date] => 2020-05-14
            [customer_name] => 
            [order_amount] => 0
            [order_status] => dfg
        )

    [47] => Array
        (
            [ID] => 154
            [order_no] => 4
            [order_date] => 2020-05-06
            [customer_name] => ggg
            [order_amount] => 343
            [order_status] => 1
        )

    [48] => Array
        (
            [ID] => 155
            [order_no] => 510
            [order_date] => 2020-05-12
            [customer_name] => 111
            [order_amount] => 20
            [order_status] => ok
        )

    [49] => Array
        (
            [ID] => 156
            [order_no] => 1
            [order_date] => 2020-05-06
            [customer_name] => q
            [order_amount] => 2
            [order_status] => q
        )

    [50] => Array
        (
            [ID] => 157
            [order_no] => 1
            [order_date] => 2020-05-06
            [customer_name] => q
            [order_amount] => 2
            [order_status] => q
        )

    [51] => Array
        (
            [ID] => 158
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [52] => Array
        (
            [ID] => 159
            [order_no] => 111111
            [order_date] => 2020-05-14
            [customer_name] => Sebek
            [order_amount] => 100
            [order_status] => Za?atwioen
        )

    [53] => Array
        (
            [ID] => 160
            [order_no] => 75
            [order_date] => 2020-05-18
            [customer_name] => Ggg
            [order_amount] => 0
            [order_status] => Action 
        )

    [54] => Array
        (
            [ID] => 161
            [order_no] => 75
            [order_date] => 2020-05-18
            [customer_name] => Ggg
            [order_amount] => 0
            [order_status] => Action 
        )

    [55] => Array
        (
            [ID] => 162
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [56] => Array
        (
            [ID] => 163
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 6666666666666666666666666666666
            [order_amount] => 55555
            [order_status] => 
        )

    [57] => Array
        (
            [ID] => 164
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [58] => Array
        (
            [ID] => 165
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [59] => Array
        (
            [ID] => 166
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [60] => Array
        (
            [ID] => 167
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [61] => Array
        (
            [ID] => 168
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [62] => Array
        (
            [ID] => 169
            [order_no] => 54
            [order_date] => 2020-05-08
            [customer_name] => AGGA
            [order_amount] => 40
            [order_status] => 1
        )

    [63] => Array
        (
            [ID] => 170
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [64] => Array
        (
            [ID] => 171
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [65] => Array
        (
            [ID] => 172
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [66] => Array
        (
            [ID] => 173
            [order_no] => 35234
            [order_date] => 2020-05-26
            [customer_name] => wetrwet
            [order_amount] => 35345
            [order_status] => twet
        )

    [67] => Array
        (
            [ID] => 174
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [68] => Array
        (
            [ID] => 175
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [69] => Array
        (
            [ID] => 176
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [70] => Array
        (
            [ID] => 177
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => df
            [order_amount] => 0
            [order_status] => clone of 167
        )

    [71] => Array
        (
            [ID] => 178
            [order_no] => 2
            [order_date] => 2020-05-11
            [customer_name] => ernesyo
            [order_amount] => 12
            [order_status] => fatto
        )

    [72] => Array
        (
            [ID] => 179
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [73] => Array
        (
            [ID] => 180
            [order_no] => 1
            [order_date] => 2020-05-12
            [customer_name] => fabio
            [order_amount] => 12
            [order_status] => 12
        )

    [74] => Array
        (
            [ID] => 181
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [75] => Array
        (
            [ID] => 182
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [76] => Array
        (
            [ID] => 183
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [77] => Array
        (
            [ID] => 184
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [78] => Array
        (
            [ID] => 185
            [order_no] => 37748
            [order_date] => 2020-05-18
            [customer_name] => Piccolo
            [order_amount] => 73
            [order_status] => Pending
        )

    [79] => Array
        (
            [ID] => 187
            [order_no] => 1
            [order_date] => 2020-05-13
            [customer_name] => aaa
            [order_amount] => 0
            [order_status] => ,0
        )

    [80] => Array
        (
            [ID] => 188
            [order_no] => 11
            [order_date] => 2020-05-22
            [customer_name] => Ffff
            [order_amount] => 14
            [order_status] => 
        )

    [81] => Array
        (
            [ID] => 189
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [82] => Array
        (
            [ID] => 190
            [order_no] => 1
            [order_date] => 2020-05-01
            [customer_name] => test
            [order_amount] => 1000
            [order_status] => end
        )

    [83] => Array
        (
            [ID] => 191
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [84] => Array
        (
            [ID] => 192
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => sasa
            [order_amount] => 23
            [order_status] => 
        )

    [85] => Array
        (
            [ID] => 193
            [order_no] => 1
            [order_date] => 2020-05-13
            [customer_name] => 2e2
            [order_amount] => 12
            [order_status] => si
        )

    [86] => Array
        (
            [ID] => 194
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [87] => Array
        (
            [ID] => 195
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [88] => Array
        (
            [ID] => 197
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => Nombre
            [order_amount] => 123
            [order_status] => 
        )

    [89] => Array
        (
            [ID] => 198
            [order_no] => 28431
            [order_date] => 2016-09-08
            [customer_name] => Xenos Clarke
            [order_amount] => 5
            [order_status] => Completed
        )

    [90] => Array
        (
            [ID] => 199
            [order_no] => 37748
            [order_date] => 2020-05-18
            [customer_name] => Xenos Clarke
            [order_amount] => 90
            [order_status] => Completed test
        )

    [91] => Array
        (
            [ID] => 200
            [order_no] => 222222
            [order_date] => 2020-05-01
            [customer_name] => dfggg
            [order_amount] => 112
            [order_status] => 1
        )

    [92] => Array
        (
            [ID] => 201
            [order_no] => 28431
            [order_date] => 2016-09-08
            [customer_name] => Xenos Clarke
            [order_amount] => 5
            [order_status] => Completed
        )

    [93] => Array
        (
            [ID] => 202
            [order_no] => 28431
            [order_date] => 2016-09-08
            [customer_name] => Xenos Clarke
            [order_amount] => 5
            [order_status] => Completed
        )

    [94] => Array
        (
            [ID] => 203
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => 
            [order_amount] => 0
            [order_status] => 
        )

    [95] => Array
        (
            [ID] => 204
            [order_no] => 2131
            [order_date] => 2020-05-22
            [customer_name] => 213
            [order_amount] => 123
            [order_status] => 3123
        )

    [96] => Array
        (
            [ID] => 205
            [order_no] => 2131
            [order_date] => 2020-05-22
            [customer_name] => 213
            [order_amount] => 123
            [order_status] => 3123
        )

)