Laravel Array & JSON casting

Question

I am using this to insert data in JSON format into table. What I would like to know is if it is possible to change one property of JSON object after it is inserted into table with more then one properties. For example:

Table:
+----+----------------------------------+
| id |               car                |
+----+----------------------------------+
|  1 | {"brand": "audi", "model": "TT"} |
+----+----------------------------------+

$entity = Table::where('id', 1);
$entity->car['model'] = 'Aicon';

Code, similar to this, gives me an exception 'ErrorException' with message 'Indirect modification of overloaded property ... has no effect' in ....

Zoe Edwards · Accepted Answer · 2018-11-09 15:53:50Z

4

Such as in the Doc’s example you cannot, you have to take the JSON object (as an array), change it, and then put it back.

$entity = Table::where('id', 1);
$car = $entity->car;
$car['model'] = 'Aicon';
$entity->car = $car;
$entity->save();

answered Nov 9, 2018 at 15:53

Zoe Edwards

13.8k3 gold badges28 silver badges45 bronze badges

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

2 Comments

Stephen Lake Over a year ago

You beat me to it, arg!

niksrb Over a year ago

Wow, that's great! Thank you mate, this is just what I need.

Stephen Lake · Accepted Answer · 2018-11-09 16:04:09Z

1

You cannot directly modify a child node of an attribute as it technically doesn't exist on the model. Scroll up just a few notches in the documentation link you shared and read up on Accessors and Mutators, alternatively just define the property properly.

If you don't want to automatically cast the JSON to array as @Thomas Edwards pointed out, you can define a mutator which essentially does the exact same thing, but you can modify as you wish:

public function getCarAttribute($value) 
{
   return json_decode($value, true);
}

Then append your new attributes to the mutated field:

$entity = Entity::find(1);

$car = $entity->car;
$car['model'] = 'Aicon';
$car['color'] = 'Blue';

$entity->car = $car;
$entity->save();

edited Nov 9, 2018 at 16:04

answered Nov 9, 2018 at 15:55

Stephen Lake

1,6252 gold badges19 silver badges27 bronze badges

2 Comments

niksrb Over a year ago

Thanks for suggestion, but I'm gonna use @Thomas Edwards solution on this one.

Stephen Lake Over a year ago

He was first in the race in any event ^_^

nullthoughts · Accepted Answer · 2019-09-21 02:22:45Z

0

If the column is cast as a JSON column, then updating is very straightforward using an arrow accessor:

Cast:

protected $casts = [
    'car' => 'json',
];

Updating:

Table::find(1)->update(['car->model' => 'Aicon']);

More information on JSON columns in Laravel in a recent blog article I wrote: https://nullthoughts.com/development/2019/01/29/laravel-json-column-types/

Edit: If you are declaring the column as $fillable, I believe you'll have to add each property for mass-assignment using the arrow accessor:

protected $fillable = [
    'car->model',
];

edited Sep 21, 2019 at 2:22

answered Sep 19, 2019 at 20:48

nullthoughts

113 bronze badges

1 Comment

nullthoughts Over a year ago

Thank you @Makyen, I had quickly searched to see if this was even permitted while rushing to post my answer. As with anything, you learn more as you go, so I do appreciate the information early on. I've edited the post to reflect that the link is to my own blog.

Collectives™ on Stack Overflow

Laravel Array & JSON casting

3 Answers 3

2 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related