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] => 65
            [order_no] => 94701
            [order_date] => 2016-09-08
            [customer_name] => Cooper Jensen
            [order_amount] => 589
            [order_status] => Completed
        )

    [1] => Array
        (
            [ID] => 66
            [order_no] => 36440
            [order_date] => 2016-09-08
            [customer_name] => Xenos Clarke
            [order_amount] => 8
            [order_status] => Completed
        )

    [2] => Array
        (
            [ID] => 67
            [order_no] => 37251
            [order_date] => 2016-09-08
            [customer_name] => 
            [order_amount] => 64
            [order_status] => Completed
        )

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

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

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

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

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

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

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

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

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

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

    [13] => Array
        (
            [ID] => 80
            [order_no] => 74040
            [order_date] => 2016-09-08
            [customer_name] => Penelope Moss
            [order_amount] => 59
            [order_status] => Completed
        )

    [14] => Array
        (
            [ID] => 81
            [order_no] => 89592
            [order_date] => 2016-09-08
            [customer_name] => Chase Andrews
            [order_amount] => 76
            [order_status] => Completed
        )

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

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

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

    [18] => Array
        (
            [ID] => 85
            [order_no] => 71212
            [order_date] => 2016-09-08
            [customer_name] => Cooper Jensen
            [order_amount] => 334455
            [order_status] => Completed
        )

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

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

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

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

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

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

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

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

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

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

    [29] => Array
        (
            [ID] => 96
            [order_no] => 93197
            [order_date] => 2016-09-08
            [customer_name] => Cooper Jensen
            [order_amount] => 88
            [order_status] => Completed
        )

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

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

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

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

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

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

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

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

    [38] => Array
        (
            [ID] => 142
            [order_no] => 1
            [order_date] => 2024-11-07
            [customer_name] => 
            [order_amount] => 0
            [order_status] => dd
        )

    [39] => Array
        (
            [ID] => 143
            [order_no] => 93062
            [order_date] => 2016-09-08
            [customer_name] => Cooper Jensen
            [order_amount] => 32
            [order_status] => qsdCompleted
        )

    [40] => Array
        (
            [ID] => 144
            [order_no] => 93062
            [order_date] => 2016-09-08
            [customer_name] => Cooper Jensen
            [order_amount] => 32
            [order_status] => qsdCompleted
        )

    [41] => Array
        (
            [ID] => 145
            [order_no] => 93062
            [order_date] => 2016-09-08
            [customer_name] => Cooper Jensen
            [order_amount] => 32
            [order_status] => qsdCompleted
        )

    [42] => Array
        (
            [ID] => 146
            [order_no] => 93062
            [order_date] => 2016-09-08
            [customer_name] => Cooper Jensen
            [order_amount] => 32
            [order_status] => qsdCompleted
        )

    [43] => Array
        (
            [ID] => 147
            [order_no] => 1212
            [order_date] => 2024-12-06
            [customer_name] => 
            [order_amount] => 12
            [order_status] => dead
        )

    [44] => Array
        (
            [ID] => 148
            [order_no] => 3
            [order_date] => 2024-12-11
            [customer_name] => hk
            [order_amount] => 0
            [order_status] => ads
        )

    [45] => Array
        (
            [ID] => 151
            [order_no] => 1
            [order_date] => 2024-12-12
            [customer_name] => asd
            [order_amount] => 12
            [order_status] => ,0,1
        )

    [46] => Array
        (
            [ID] => 152
            [order_no] => 2
            [order_date] => 2024-12-04
            [customer_name] => Xenos Clark
            [order_amount] => 6
            [order_status] => t
        )

    [47] => Array
        (
            [ID] => 153
            [order_no] => 1
            [order_date] => 2024-12-03
            [customer_name] => Test
            [order_amount] => 1
            [order_status] => dome
        )

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

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

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

    [51] => Array
        (
            [ID] => 157
            [order_no] => 1111
            [order_date] => 2024-12-11
            [customer_name] => mohan
            [order_amount] => 12
            [order_status] => 22
        )

    [52] => Array
        (
            [ID] => 158
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => Xenos Clarke
            [order_amount] => 78
            [order_status] => 
        )

    [53] => Array
        (
            [ID] => 159
            [order_no] => 3
            [order_date] => 2024-12-26
            [customer_name] => MIROS?AW J?DRASIAK
            [order_amount] => 34
            [order_status] => 
        )

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

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

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

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

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

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

    [60] => Array
        (
            [ID] => 166
            [order_no] => 788
            [order_date] => 2024-12-18
            [customer_name] => Florin
            [order_amount] => 62
            [order_status] => Completed
        )

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

    [62] => Array
        (
            [ID] => 168
            [order_no] => 1
            [order_date] => 2024-12-11
            [customer_name] => arno
            [order_amount] => 38
            [order_status] => Complet
        )

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

    [64] => Array
        (
            [ID] => 355
            [order_no] => 833234
            [order_date] => 2016-09-08
            [customer_name] => Cooper Jensen
            [order_amount] => 339
            [order_status] => Completed
        )

    [65] => Array
        (
            [ID] => 356
            [order_no] => 450
            [order_date] => 2024-12-30
            [customer_name] => Pedro
            [order_amount] => 694
            [order_status] => Completed
        )

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

    [67] => Array
        (
            [ID] => 358
            [order_no] => 123452
            [order_date] => 2025-01-09
            [customer_name] => Cooper Jensen
            [order_amount] => 12
            [order_status] => 1
        )

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

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

    [70] => Array
        (
            [ID] => 361
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => werqwer
            [order_amount] => 344344
            [order_status] => 
        )

    [71] => Array
        (
            [ID] => 362
            [order_no] => 5
            [order_date] => 2025-01-17
            [customer_name] => Charles Charles
            [order_amount] => 100
            [order_status] => Processing
        )

    [72] => Array
        (
            [ID] => 363
            [order_no] => 1
            [order_date] => 2025-01-10
            [customer_name] => ZDV
            [order_amount] => 677
            [order_status] => YES
        )

    [73] => Array
        (
            [ID] => 364
            [order_no] => 0
            [order_date] => 2025-01-09
            [customer_name] => r
            [order_amount] => 4
            [order_status] => a
        )

    [74] => Array
        (
            [ID] => 365
            [order_no] => 0
            [order_date] => 2025-01-09
            [customer_name] => r
            [order_amount] => 4
            [order_status] => a
        )

    [75] => Array
        (
            [ID] => 366
            [order_no] => 12322
            [order_date] => 2025-01-27
            [customer_name] => tr?ng
            [order_amount] => 111111
            [order_status] => ok
        )

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

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

    [78] => Array
        (
            [ID] => 369
            [order_no] => 21
            [order_date] => 2016-09-08
            [customer_name] => Xenos Clarke
            [order_amount] => 394
            [order_status] => Completed
        )

    [79] => Array
        (
            [ID] => 370
            [order_no] => 12322
            [order_date] => 2025-01-27
            [customer_name] => tr?ng111
            [order_amount] => 111111
            [order_status] => ok
        )

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

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

    [82] => Array
        (
            [ID] => 373
            [order_no] => 1111
            [order_date] => 2025-02-12
            [customer_name] => rtersts
            [order_amount] => 121212
            [order_status] => 12121212
        )

    [83] => Array
        (
            [ID] => 374
            [order_no] => 500
            [order_date] => 2025-02-04
            [customer_name] => Jojo Isgone
            [order_amount] => 19
            [order_status] => on
        )

    [84] => Array
        (
            [ID] => 375
            [order_no] => 1111
            [order_date] => 2025-02-04
            [customer_name] => ??c Tr?ng
            [order_amount] => 1111
            [order_status] => ok
        )

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

    [86] => Array
        (
            [ID] => 377
            [order_no] => 1
            [order_date] => 2025-02-11
            [customer_name] => joe
            [order_amount] => 100
            [order_status] => picked
        )

    [87] => Array
        (
            [ID] => 378
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => joe doe
            [order_amount] => 100
            [order_status] => 
        )

    [88] => Array
        (
            [ID] => 379
            [order_no] => 1
            [order_date] => 2025-02-08
            [customer_name] => shankar tormal
            [order_amount] => 788
            [order_status] => active
        )

)