PDO PDOCrud

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] => 66
            [order_no] => 36440
            [order_date] => 2016-09-08
            [customer_name] => Heather Terrell
            [order_amount] => 8
            [order_status] => Completed
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [16] => Array
        (
            [ID] => 82
            [order_no] => 84334
            [order_date] => 2016-09-08
            [customer_name] => Fatima Mcconnell
            [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] => Rina Lawrence
            [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] => Ray Clayton
            [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] => Teegan Jimenez
            [order_amount] => 26
            [order_status] => Completed
        )

)