 
                        我正在尝试使用 codeigniter 网站将数组作为 json 存储在数据库中,如下所示:
$this->db->insert('orders', 
                array('orderstatus' => $orderstatus,  
                      'productname' => json_encode($product1)
                    )
    );
数组的值如下:
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
        )
)
数据库看起来像:
但是在数据库中,该值存储如下:
"Array"
谁能告诉我这里出了什么问题吗,提前谢谢
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
对我来说它有效:
$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"}]