Storing array as json in database using codeigniter php not working

Question

i am trying to store an array as json in database using codeigniter website like below:

$this->db->insert('orders', 
                array('orderstatus' => $orderstatus,  
                      'productname' => json_encode($product1)
                    )
    );

the array has values like below:

Array
(
    [0] => Array
        (
            [id] => 8
            [productname] => Couple Combo Sherwani
            [pimage] => _RJ_0149-min.jpg,_RJ_0342-min.jpg,_RJ_0115-min.jpg
            [jrp] => 6000
            [deposit] => 6000
            [size] => XL
            [duration] => 3
            [quantity] => 1
        )

)

the database looks like:

however in database the value is stored as below:

"Array"

can anyone please tell me what is wrong in here, thanks in advance

Please show us what is in $product1, a print_r($product1); for example — RiggsFolly
– RiggsFolly, Commented Jul 8, 2022 at 11:44
But why would you want to store what appears to be a name, so a single string, as a JSON String? — RiggsFolly
– RiggsFolly, Commented Jul 8, 2022 at 11:45
@RiggsFolly actually i want to store all the product info as json inside one field — ZNO
– ZNO, Commented Jul 8, 2022 at 12:01
Why would you use a relational database if you want to do this — RiggsFolly
– RiggsFolly, Commented Jul 8, 2022 at 12:04
@RiggsFolly its actually done in relational database, i need to fix only this thing — ZNO
– ZNO, Commented Jul 8, 2022 at 12:07

Mateusz Nejman · Accepted Answer · 2022-07-08 19:47:27Z

1

For me it works:

$products = [
    (object)[
        "name" => "Test product",
        "attribute1" => "Value1"
    ]
];

$this->db->table("orders")->insert([
    "name" => "Order for client",
    "info" => "Client want this order today",
    "products" => json_encode($products)
]); //In products column i have [{"name":"Test product","attribute1":"Value1"}]

answered Jul 8, 2022 at 19:47

Mateusz Nejman

364 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Storing array as json in database using codeigniter php not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related