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] => 267
            [order_no] => 1
            [order_date] => 2023-04-04
            [customer_name] => Xenos Clarke
            [order_amount] => 3212
            [order_status] => 1
        )

    [1] => Array
        (
            [ID] => 268
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => Cooper Jensen
            [order_amount] => 656
            [order_status] => a
        )

    [2] => Array
        (
            [ID] => 269
            [order_no] => 1
            [order_date] => 0000-00-00
            [customer_name] => Xenos Clarke
            [order_amount] => 1
            [order_status] => 1
        )

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

    [4] => Array
        (
            [ID] => 271
            [order_no] => 100
            [order_date] => 2023-04-20
            [customer_name] => 
            [order_amount] => 1020
            [order_status] => Completed
        )

    [5] => Array
        (
            [ID] => 272
            [order_no] => 1
            [order_date] => 2023-04-05
            [customer_name] => 
            [order_amount] => 100
            [order_status] => 2
        )

    [6] => Array
        (
            [ID] => 273
            [order_no] => 12
            [order_date] => 2023-04-06
            [customer_name] => Xenos Clarke
            [order_amount] => 5
            [order_status] => Completed
        )

    [7] => Array
        (
            [ID] => 274
            [order_no] => 3453
            [order_date] => 2023-04-19
            [customer_name] => 
            [order_amount] => 0
            [order_status] => sdaf
        )

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

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

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

    [11] => Array
        (
            [ID] => 278
            [order_no] => 1
            [order_date] => 2023-05-08
            [customer_name] => 
            [order_amount] => 10
            [order_status] => xyz
        )

    [12] => Array
        (
            [ID] => 279
            [order_no] => 123456
            [order_date] => 2023-05-09
            [customer_name] => 
            [order_amount] => 12
            [order_status] => sent
        )

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

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

    [15] => Array
        (
            [ID] => 282
            [order_no] => 23
            [order_date] => 2023-05-12
            [customer_name] => Xenos Clarke
            [order_amount] => 0
            [order_status] => 0,1
        )

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

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

    [18] => Array
        (
            [ID] => 285
            [order_no] => 2
            [order_date] => 2023-05-01
            [customer_name] => qxsd
            [order_amount] => 34
            [order_status] => ssdcsdc
        )

    [19] => Array
        (
            [ID] => 286
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => hfd
            [order_amount] => 323
            [order_status] => 
        )

    [20] => Array
        (
            [ID] => 287
            [order_no] => 3564
            [order_date] => 2023-05-11
            [customer_name] => dssad
            [order_amount] => 23232
            [order_status] => adsd
        )

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

    [22] => Array
        (
            [ID] => 289
            [order_no] => 12336
            [order_date] => 2016-09-08
            [customer_name] => Xenos Clarke
            [order_amount] => 12
            [order_status] => Completed
        )

    [23] => Array
        (
            [ID] => 290
            [order_no] => 12336
            [order_date] => 2016-09-08
            [customer_name] => Xenos Clarke
            [order_amount] => 12
            [order_status] => Completed
        )

    [24] => Array
        (
            [ID] => 291
            [order_no] => 12336
            [order_date] => 2016-09-08
            [customer_name] => Xenos Clarkemm
            [order_amount] => 12
            [order_status] => Completed
        )

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

    [26] => Array
        (
            [ID] => 293
            [order_no] => 55
            [order_date] => 2023-05-01
            [customer_name] => cd
            [order_amount] => 12
            [order_status] => 5
        )

    [27] => Array
        (
            [ID] => 294
            [order_no] => 55
            [order_date] => 2023-05-15
            [customer_name] => cd
            [order_amount] => 12
            [order_status] => 5
        )

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

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

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

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

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

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

    [34] => Array
        (
            [ID] => 301
            [order_no] => 33
            [order_date] => 2023-05-01
            [customer_name] => aaa
            [order_amount] => 111
            [order_status] => 1
        )

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

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

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

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

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

    [40] => Array
        (
            [ID] => 307
            [order_no] => 987663
            [order_date] => 2023-05-23
            [customer_name] => pippo
            [order_amount] => 1299
            [order_status] => ok
        )

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

    [42] => Array
        (
            [ID] => 309
            [order_no] => 0
            [order_date] => 2023-05-22
            [customer_name] => Fred Flintstone
            [order_amount] => 10
            [order_status] => open
        )

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

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

    [45] => Array
        (
            [ID] => 312
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => Xenos Clarke
            [order_amount] => 0
            [order_status] => wergts
        )

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

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

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

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

    [50] => Array
        (
            [ID] => 317
            [order_no] => 5451
            [order_date] => 2023-04-14
            [customer_name] => Xenos Clarke
            [order_amount] => 3212
            [order_status] => AA
        )

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

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

    [53] => Array
        (
            [ID] => 320
            [order_no] => 0
            [order_date] => 0000-00-00
            [customer_name] => Daniel 
            [order_amount] => 4000
            [order_status] => 
        )

    [54] => Array
        (
            [ID] => 321
            [order_no] => 1
            [order_date] => 2023-06-16
            [customer_name] => test
            [order_amount] => 0
            [order_status] => test
        )

)