store and update an array as json in mysql database laravel 9

Question

I have values that I want to store in the database, I have declared the type as json and cast it as an array:

    protected $casts = [
    'favourites' => 'array'
];

however, I'm not sure how to add and update and read the values inside, any ideas? controller function:

public function addtofav()
{
    $id = request()->get('id');
    $user = auth()->user();
    json_decode($user->favourites,true);
    array_push($user->favourites,$id);
    dump('hello');
    json_encode($user->favourites);
    $user->save();
    return response(['id'=> $id],200);
}

what does the output of the json_decode statement look like? can you dump that or dd() it. — Yasser Sebai
– Yasser Sebai, Commented Mar 24, 2022 at 8:56
at the moment the column is completely empty, plus I'm calling the function using ajax and dumping doesn't work apparently(I've tried) @YasserSebai — Omar Malas
– Omar Malas, Commented Mar 24, 2022 at 9:19

Bilal AL Massry · Accepted Answer · 2022-03-24 09:57:47Z

3

Quoting from the Laravel documenations:

adding the array cast to that attribute will automatically deserialize the attribute to a PHP array when you access it on your Eloquent model.

therefore, no need to make any encoding or decoding to your values before any update or create, just keep it as an array and Eloquent will take care of that, since you have the $cast array as below:

protected $casts = [
    'options' => 'array',
];

answered Mar 24, 2022 at 9:57

Bilal AL Massry

1094 bronze badges

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

Comments

Omer YILMAZ · Accepted Answer · 2022-03-23 21:19:52Z

1

Actually you should use many to many but if you want to use array, you don't encode or decode.

public function addtofav()
{
    $id = request()->get('id');
    $user = auth()->user();
    $favourites = $user->favourites;
    array_push($favourites,$id);
    $user->favourites = $favourites
    $user->save();
    return response(['id'=> $id],200);
}

answered Mar 23, 2022 at 21:19

Omer YILMAZ

1,2631 gold badge7 silver badges15 bronze badges

3 Comments

Omar Malas Over a year ago

thanks, but it didn't work, still giving me a 500 internal server error, since I'm calling this in an ajax function

Omer YILMAZ Over a year ago

please dubug it, what is the error first line of 500

Omer YILMAZ Over a year ago

I already write to you, but my answer is not accepted. Thank you

Collectives™ on Stack Overflow

store and update an array as json in mysql database laravel 9

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related