php - 在 Laravel 中的 MySQL 中插入 JSON 对象

Question

我正在努力在 JSON 类型 MySQL 列 中插入 JSON 对象。

我尝试插入的示例数据如下:

示例 Laravel 代码

public function store(Request $request)
{
    $layaway = new Layaway;

    foreach($request->selected_products as $p) {
        $layaway->selected_products = json_encode([
            'id' => $p['id'],
            'sku' => $p['sku'],
            'name' => $p['name'],
            'image' => $p['image'],
            'description' => $p['description'],
            'category_id' => $p['category_id'],
            'regular_price' => $p['regular_price']
        ]);

    }

    $layaway->save();

    return response()->json([
        'success' => true,
        'message' => 'Layaway Program has been successfully saved!'
    ]);

}

dd() 的示例响应

问题如何将 $request->selected_products 中的所有数据保存到我的 MYSQL json 类型列中？

Answer 1

正如 Wreigh 在评论中所说，

我刚刚更改了这段代码:

foreach($request->selected_products as $p) {
    $layaway->selected_products = json_encode([
        'id' => $p['id'],
        'sku' => $p['sku'],
        'name' => $p['name'],
        'image' => $p['image'],
        'description' => $p['description'],
        'category_id' => $p['category_id'],
        'regular_price' => $p['regular_price']
    ]);

}

进入这段代码:

$layaway->selected_products = json_encode($request->selected_products);

谢谢。