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] => 80
            [order_no] => 74040
            [order_date] => 2016-09-10
            [customer_name] => 
            [order_amount] => 52
            [order_status] => Completed
        )

    [1] => Array
        (
            [ID] => 82
            [order_no] => 84334
            [order_date] => 2016-09-08
            [customer_name] => Xenos Clarke
            [order_amount] => 7
            [order_status] => Completed
        )

    [2] => Array
        (
            [ID] => 83
            [order_no] => 91414
            [order_date] => 2016-09-08
            [customer_name] => Xenos Clarke
            [order_amount] => 91
            [order_status] => Completed
        )

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

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

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

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

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

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

    [9] => Array
        (
            [ID] => 91
            [order_no] => 5518
            [order_date] => 2016-09-08
            [customer_name] => Cooper Jensen
            [order_amount] => 64
            [order_status] => Completed
        )

    [10] => Array
        (
            [ID] => 92
            [order_no] => 91680
            [order_date] => 2016-09-08
            [customer_name] => Xenos Clarke
            [order_amount] => 84
            [order_status] => Completed
        )

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

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

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

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

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

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

    [17] => Array
        (
            [ID] => 99
            [order_no] => 21141
            [order_date] => 2016-09-08
            [customer_name] => Liberty Gomez
            [order_amount] => 32
            [order_status] => Completed
        )

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

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

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

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

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

    [23] => Array
        (
            [ID] => 144
            [order_no] => 2
            [order_date] => 2021-04-15
            [customer_name] => ert
            [order_amount] => 22
            [order_status] => 22
        )

    [24] => Array
        (
            [ID] => 145
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => d
            [order_amount] => 0
            [order_status] => 2
        )

    [25] => Array
        (
            [ID] => 146
            [order_no] => 1
            [order_date] => 2021-04-08
            [customer_name] => asdfasdf
            [order_amount] => 12
            [order_status] => done
        )

    [26] => Array
        (
            [ID] => 147
            [order_no] => 2
            [order_date] => 2021-04-08
            [customer_name] => asdfasdf
            [order_amount] => 12
            [order_status] => done
        )

    [27] => Array
        (
            [ID] => 148
            [order_no] => 3
            [order_date] => 2021-04-08
            [customer_name] => asdfasdf
            [order_amount] => 12
            [order_status] => done
        )

    [28] => Array
        (
            [ID] => 150
            [order_no] => 2147483647
            [order_date] => 2021-04-08
            [customer_name] => asdfasdf
            [order_amount] => 12
            [order_status] => done
        )

    [29] => Array
        (
            [ID] => 151
            [order_no] => 9999999
            [order_date] => 2021-04-08
            [customer_name] => asdfasdf
            [order_amount] => 12
            [order_status] => done
        )

    [30] => Array
        (
            [ID] => 152
            [order_no] => 99999991
            [order_date] => 2021-04-08
            [customer_name] => asdfasdf
            [order_amount] => 12
            [order_status] => done
        )

    [31] => Array
        (
            [ID] => 153
            [order_no] => 99999992
            [order_date] => 2021-04-08
            [customer_name] => asdfasdf
            [order_amount] => 12
            [order_status] => done
        )

    [32] => Array
        (
            [ID] => 154
            [order_no] => 1
            [order_date] => 2021-04-01
            [customer_name] => a
            [order_amount] => 0
            [order_status] => a
        )

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

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

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

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

    [37] => Array
        (
            [ID] => 161
            [order_no] => 3
            [order_date] => 2021-04-16
            [customer_name] => sfds
            [order_amount] => 0
            [order_status] => dfsd
        )

    [38] => Array
        (
            [ID] => 162
            [order_no] => 3
            [order_date] => 2021-04-16
            [customer_name] => sfds
            [order_amount] => 0
            [order_status] => dfsd
        )

    [39] => Array
        (
            [ID] => 163
            [order_no] => 34490
            [order_date] => 2016-09-08
            [customer_name] => Emily Richmond
            [order_amount] => 77
            [order_status] => Completed
        )

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

    [41] => Array
        (
            [ID] => 165
            [order_no] => 333
            [order_date] => 2021-04-17
            [customer_name] => teste
            [order_amount] => 34000
            [order_status] => 3
        )

    [42] => Array
        (
            [ID] => 166
            [order_no] => 12
            [order_date] => 2021-04-23
            [customer_name] => qwq
            [order_amount] => 12
            [order_status] => 0,1
        )

    [43] => Array
        (
            [ID] => 167
            [order_no] => 111
            [order_date] => 2021-04-01
            [customer_name] => fuck me in the ass
            [order_amount] => 2
            [order_status] => 333
        )

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

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

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

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

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

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

    [50] => Array
        (
            [ID] => 174
            [order_no] => 2
            [order_date] => 2021-04-17
            [customer_name] => csdcs
            [order_amount] => 0
            [order_status] => fsdfsd
        )

    [51] => Array
        (
            [ID] => 175
            [order_no] => 1
            [order_date] => 2021-04-14
            [customer_name] => 1
            [order_amount] => 2
            [order_status] => 3
        )

    [52] => Array
        (
            [ID] => 176
            [order_no] => 12
            [order_date] => 2021-04-20
            [customer_name] => 111
            [order_amount] => 111
            [order_status] => 1111
        )

    [53] => Array
        (
            [ID] => 177
            [order_no] => 200
            [order_date] => 2021-04-21
            [customer_name] => 111
            [order_amount] => 111
            [order_status] => 1111
        )

    [54] => Array
        (
            [ID] => 178
            [order_no] => 1
            [order_date] => 2021-04-13
            [customer_name] => sdf
            [order_amount] => 123
            [order_status] => ,0,1
        )

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

    [56] => Array
        (
            [ID] => 180
            [order_no] => 999
            [order_date] => 2021-04-26
            [customer_name] => RRR rrr
            [order_amount] => 11
            [order_status] => Ok
        )

    [57] => Array
        (
            [ID] => 181
            [order_no] => 999
            [order_date] => 2021-04-26
            [customer_name] => RRR rrr
            [order_amount] => 11
            [order_status] => Ok
        )

    [58] => Array
        (
            [ID] => 182
            [order_no] => 4
            [order_date] => 2021-04-15
            [customer_name] => MR. rrrr
            [order_amount] => 32
            [order_status] => 1
        )

    [59] => Array
        (
            [ID] => 183
            [order_no] => 123456
            [order_date] => 2021-04-21
            [customer_name] => Adam
            [order_amount] => 0
            [order_status] => ASDFADSF
        )

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

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

    [62] => Array
        (
            [ID] => 186
            [order_no] => 144
            [order_date] => 2021-04-21
            [customer_name] => vdy2
            [order_amount] => 222
            [order_status] => 8
        )

    [63] => Array
        (
            [ID] => 187
            [order_no] => 121
            [order_date] => 2021-04-22
            [customer_name] => wqqw
            [order_amount] => 50
            [order_status] => qqq
        )

    [64] => Array
        (
            [ID] => 188
            [order_no] => 1
            [order_date] => 0000-00-00
            [customer_name] => 3
            [order_amount] => 4
            [order_status] => 45
        )

    [65] => Array
        (
            [ID] => 189
            [order_no] => 75368356
            [order_date] => 2021-04-15
            [customer_name] => John Wayne
            [order_amount] => 64000
            [order_status] => Comlpeted
        )

    [66] => Array
        (
            [ID] => 190
            [order_no] => 3254235
            [order_date] => 2021-04-22
            [customer_name] => mskdfmlksamdf
            [order_amount] => 0
            [order_status] => lkmsaflkmasdfm
        )

    [67] => Array
        (
            [ID] => 191
            [order_no] => 1
            [order_date] => 2021-04-22
            [customer_name] => csd
            [order_amount] => 3231
            [order_status] => 
        )

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

    [69] => Array
        (
            [ID] => 193
            [order_no] => 1
            [order_date] => 2021-04-09
            [customer_name] => client001
            [order_amount] => 100
            [order_status] => draft
        )

    [70] => Array
        (
            [ID] => 194
            [order_no] => 123
            [order_date] => 2021-04-08
            [customer_name] => birkner
            [order_amount] => 100
            [order_status] => draft
        )

    [71] => Array
        (
            [ID] => 195
            [order_no] => 1
            [order_date] => 2021-04-13
            [customer_name] => qwerghjhgfds
            [order_amount] => 0
            [order_status] => sdfgbhnmnbgfd
        )

    [72] => Array
        (
            [ID] => 196
            [order_no] => 10
            [order_date] => 2021-04-09
            [customer_name] => 0111
            [order_amount] => 1
            [order_status] => dddd
        )

    [73] => Array
        (
            [ID] => 197
            [order_no] => 100
            [order_date] => 2021-04-26
            [customer_name] => BSIM
            [order_amount] => 0
            [order_status] => TESE
        )

    [74] => Array
        (
            [ID] => 198
            [order_no] => 1
            [order_date] => 2021-04-27
            [customer_name] => test
            [order_amount] => 200
            [order_status] => 1
        )

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

    [76] => Array
        (
            [ID] => 200
            [order_no] => 6565
            [order_date] => 2021-04-10
            [customer_name] => sara
            [order_amount] => 500
            [order_status] => ,1
        )

    [77] => Array
        (
            [ID] => 201
            [order_no] => 1
            [order_date] => 2021-04-09
            [customer_name] => test customer
            [order_amount] => 23000
            [order_status] => 0
        )

    [78] => Array
        (
            [ID] => 202
            [order_no] => 121
            [order_date] => 2021-04-08
            [customer_name] => Bloggs Bloggins
            [order_amount] => 23
            [order_status] => Bonza
        )

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

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

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

    [82] => Array
        (
            [ID] => 206
            [order_no] => 123
            [order_date] => 2021-04-01
            [customer_name] => test test
            [order_amount] => 123
            [order_status] => ,0,1
        )

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

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

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

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

    [87] => Array
        (
            [ID] => 211
            [order_no] => 67
            [order_date] => 2021-05-19
            [customer_name] => YJU
            [order_amount] => 0
            [order_status] => J
        )

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

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

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

    [91] => Array
        (
            [ID] => 215
            [order_no] => 35453
            [order_date] => 2021-05-04
            [customer_name] => odjsn
            [order_amount] => 287
            [order_status] => ijasoid
        )

    [92] => Array
        (
            [ID] => 216
            [order_no] => 91617
            [order_date] => 2021-05-12
            [customer_name] => a
            [order_amount] => 100
            [order_status] => ok
        )

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

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

    [95] => Array
        (
            [ID] => 11111
            [order_no] => 87594
            [order_date] => 2016-09-08
            [customer_name] => Xenos Clarke
            [order_amount] => 77
            [order_status] => Pending
        )

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

    [97] => Array
        (
            [ID] => 11114
            [order_no] => 1
            [order_date] => 2022-06-18
            [customer_name] => cxcxc
            [order_amount] => 0
            [order_status] => cxcx
        )

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

    [99] => Array
        (
            [ID] => 11116
            [order_no] => 1
            [order_date] => 0000-00-00
            [customer_name] => 1
            [order_amount] => 1
            [order_status] => 1
        )

    [100] => Array
        (
            [ID] => 11117
            [order_no] => 1
            [order_date] => 2021-05-05
            [customer_name] => cmc
            [order_amount] => 444
            [order_status] => 333
        )

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

    [102] => Array
        (
            [ID] => 11119
            [order_no] => 74040
            [order_date] => 2016-09-10
            [customer_name] => Xenos Clarke
            [order_amount] => 52
            [order_status] => Completed
        )

    [103] => Array
        (
            [ID] => 11120
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => fghdfgh
            [order_amount] => 0
            [order_status] => 
        )

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

)