Laravel : json encode returns empty in DB update

Question

When I use json_encode in the update query builder of laravel, it returns empty. The code I tried was this:

    DB::table('catalog_product')->update([
        'reference' => json_encode(['data' =>DB::raw('external_barcode')]),
    ]);

How do I do this?

Can you explain what you're trying to do here? Can you also give a little bit more information about the table e.g. what is reference, what is external_barcode? etc. — Rwd
– Rwd, Commented Jul 9, 2019 at 10:49
@RossWilson I thought it was self explainatory. I'm trying to move the data in one column to another in json format — Saeesh Tendulkar
– Saeesh Tendulkar, Commented Jul 9, 2019 at 10:51
You are mixing PHP and MYSQL update, this cannot work. You can use pure PHP and get all your records from your table, then loop and update with json_encode() function, or use JSON_OBJECT function in mysql. But you'll need key / value to encode a value. — Vincent Decaux
– Vincent Decaux, Commented Jul 9, 2019 at 10:54
@VincentDecaux I have updated the code in question for key value pair. How do I use the json object? — Saeesh Tendulkar
– Saeesh Tendulkar, Commented Jul 9, 2019 at 10:59

Vincent Decaux · Accepted Answer · 2019-07-09 11:06:27Z

2

As I said, you are mixing a PHP function with a MYSQL value.

Or you use the PHP way :

$products = CatalogProduct::get();

foreach ($products as $product) {
   $product->reference = json_encode(['data' => $product->external_barcode]);
   $product->save();
}

Or using MYSQL :

DB::table('catalog_product')->update([
    'reference' => DB::raw('JSON_OBJECT("data", external_barcode)'),
]);

answered Jul 9, 2019 at 11:06

Vincent Decaux

10.9k7 gold badges67 silver badges102 bronze badges

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

2 Comments

Saeesh Tendulkar Over a year ago

Thanks. The 2nd method was what I needed

Vincent Decaux Over a year ago

Accept the answer if your problem is solved. Thanks

Collectives™ on Stack Overflow

Laravel : json encode returns empty in DB update

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related