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] => 46
            [order_no] => 30771
            [order_date] => 2016-09-08
            [customer_name] => Gillian 
            [order_amount] => 461
            [order_status] => Completed
        )

    [1] => Array
        (
            [ID] => 47
            [order_no] => 96349
            [order_date] => 2016-09-08
            [customer_name] => Wallace Gillespie
            [order_amount] => 71
            [order_status] => Completed
        )

    [2] => Array
        (
            [ID] => 48
            [order_no] => 72881
            [order_date] => 2016-09-08
            [customer_name] => Risa Ayers
            [order_amount] => 18
            [order_status] => Completed
        )

    [3] => Array
        (
            [ID] => 49
            [order_no] => 3691
            [order_date] => 2016-09-08
            [customer_name] => Callum Solomon
            [order_amount] => 75
            [order_status] => Completed
        )

    [4] => Array
        (
            [ID] => 50
            [order_no] => 77099
            [order_date] => 2016-09-08
            [customer_name] => Nola Rojas
            [order_amount] => 20
            [order_status] => Completed
        )

    [5] => Array
        (
            [ID] => 51
            [order_no] => 37429
            [order_date] => 2016-09-08
            [customer_name] => Talon Rowland
            [order_amount] => 77
            [order_status] => Completed
        )

    [6] => Array
        (
            [ID] => 52
            [order_no] => 44144
            [order_date] => 2016-09-08
            [customer_name] => Cheryl Bowers
            [order_amount] => 26
            [order_status] => Completed
        )

    [7] => Array
        (
            [ID] => 53
            [order_no] => 62391
            [order_date] => 2016-09-08
            [customer_name] => Bree Gaines
            [order_amount] => 96
            [order_status] => Completed
        )

    [8] => Array
        (
            [ID] => 54
            [order_no] => 54999
            [order_date] => 2016-09-08
            [customer_name] => Lacota Bonner
            [order_amount] => 5
            [order_status] => Completed
        )

    [9] => Array
        (
            [ID] => 55
            [order_no] => 83323
            [order_date] => 2016-09-08
            [customer_name] => Bradley Freeman
            [order_amount] => 37
            [order_status] => Completed
        )

    [10] => Array
        (
            [ID] => 56
            [order_no] => 409
            [order_date] => 2016-09-08
            [customer_name] => Jasper Santiago
            [order_amount] => 68
            [order_status] => Completed
        )

    [11] => Array
        (
            [ID] => 57
            [order_no] => 50683
            [order_date] => 2016-09-08
            [customer_name] => Hilary Conner
            [order_amount] => 28
            [order_status] => Completed
        )

    [12] => Array
        (
            [ID] => 58
            [order_no] => 93143
            [order_date] => 2016-09-08
            [customer_name] => Zena Fox
            [order_amount] => 37
            [order_status] => Completed
        )

    [13] => Array
        (
            [ID] => 59
            [order_no] => 48121
            [order_date] => 2016-09-08
            [customer_name] => Britanni Schmidt
            [order_amount] => 1
            [order_status] => Completed
        )

    [14] => Array
        (
            [ID] => 60
            [order_no] => 74815
            [order_date] => 2016-09-08
            [customer_name] => Caleb Lynn
            [order_amount] => 95
            [order_status] => Completed
        )

    [15] => Array
        (
            [ID] => 61
            [order_no] => 37748
            [order_date] => 2016-09-08
            [customer_name] => Madeson Robbins
            [order_amount] => 73
            [order_status] => Completed
        )

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

    [17] => Array
        (
            [ID] => 63
            [order_no] => 37920
            [order_date] => 2016-09-08
            [customer_name] => Damian Wilson
            [order_amount] => 67
            [order_status] => Completed
        )

    [18] => Array
        (
            [ID] => 64
            [order_no] => 28431
            [order_date] => 2016-09-08
            [customer_name] => Mikayla Mendez
            [order_amount] => 5
            [order_status] => Completed
        )

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

    [20] => Array
        (
            [ID] => 66
            [order_no] => 36440
            [order_date] => 2016-09-08
            [customer_name] => Heather Terrell
            [order_amount] => 8
            [order_status] => Completed
        )

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

    [22] => Array
        (
            [ID] => 68
            [order_no] => 35643
            [order_date] => 2016-09-08
            [customer_name] => Bernard Gilmore
            [order_amount] => 95
            [order_status] => Completed
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [58] => Array
        (
            [ID] => 132
            [order_no] => -1
            [order_date] => 2016-12-18
            [customer_name] => gggg
            [order_amount] => 12
            [order_status] => p
        )

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

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

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

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

    [63] => Array
        (
            [ID] => 137
            [order_no] => -1
            [order_date] => 2016-12-21
            [customer_name] => candikel
            [order_amount] => 12
            [order_status] => p
        )

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

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

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

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

    [68] => Array
        (
            [ID] => 143
            [order_no] => 0
            [order_date] => 2017-08-17
            [customer_name] => johhny
            [order_amount] => 3939
            [order_status] => UCODE-002
        )

    [69] => Array
        (
            [ID] => 144
            [order_no] => 0
            [order_date] => 2017-08-17
            [customer_name] => johhny
            [order_amount] => 3939
            [order_status] => UCODE-002
        )

    [70] => Array
        (
            [ID] => 145
            [order_no] => 45
            [order_date] => 2017-08-01
            [customer_name] => Jamie Spencer
            [order_amount] => 7282
            [order_status] => Completed
        )

    [71] => Array
        (
            [ID] => 146
            [order_no] => 45
            [order_date] => 2017-08-01
            [customer_name] => Jamie Spencer
            [order_amount] => 7282
            [order_status] => Completed
        )

)