Alan
Alan

Reputation: 2639

Storing data into json field

I have a table with a JSON column. I added this to my model in order to cast it automatically when I want to read it:

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

If I manually insert this in the database to the json field everything works fine:

{"age": "15", "name": "John Doe"}

I read the model field and it's returned as an array.

I cant figure out how to store data through my app. I tried using this

$model->data = json_encode(['John Doe']);

But when I check the database this is what is stored:

"{\"name\":\"John Doe\"}"

And it's not casted when I want to use it. How can I solve this?

PLUS: Is there some documentation about the json field usage? I coulnd find anything

Upvotes: 0

Views: 102

Answers (1)

Alan
Alan

Reputation: 2639

I solved it. I just make $model->data = ['nombre' => 'John'] and it's stored properly

Upvotes: 1

Related Questions