Inserting JSON object in MySQL in Laravel

Question

I am working on inserting a JSON object in JSON-type MySQL column.

Sample data that I am trying to insert is like this:

Sample Laravel code

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!'
    ]);

}

Sample response from dd()

Question How can I save all of the data in the $request->selected_products into my MYSQL json-type column?

why don't just json_encode($request->selected_products) and then save it to $layaway->selected_products? saves you a for loop. — Wreigh
– Wreigh, Commented Oct 12, 2018 at 0:13
Thank you. it is working. I don't know that it is just as easy as that. silly me. — Emjey23
– Emjey23, Commented Oct 12, 2018 at 1:32

Emjey23 · Accepted Answer · 2018-10-12 01:36:32Z

2

As said in the comment by Wreigh,

I just changed this code:

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']
    ]);

}

into this code:

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

Thank you.

answered Oct 12, 2018 at 1:36

Emjey23

3671 gold badge4 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Inserting JSON object in MySQL in Laravel

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