Level 102
What is the query? And can you show the model?
Oct 12, 2022
12
Level 2
Json decode and encode
i'm storing data as json object in database like this
'custom_field'=>json_encode(['teacher_description'=>$request->custom_field])
i want to show this data but when i do this in blade it gives this error blade
{{json_decode($teacher->custom_field)}}
error
htmlspecialchars(): Argument #1 ($string) must be of type string, stdClass given
for example i want if i stored hello in the teacher_description i write this in blade to get hello message any hint ?
{{json_decode($teacher->custom_field->teacher_description)}}
Level 2
public function show(User $teacher)
{
return view('manager.teachers.show',compact('teacher'));
}
what in the model you wanna see.
Level 102
@karimali1337 Try this. First decode, then get teacher_description
{{json_decode($teacher->custom_field)->teacher_description}}
1 like
Level 2
@Sinnbeck yea and it gives this
Attempt to read property "teacher_description" on string
Level 102
@karimali1337 Sorry there was a typo. Fixed
Level 2
@Sinnbeck It works now,You always surprise me mate xD
Level 102
But be aware that it will fail if teacher_description is anything but a string. If its an array, you will need a foreach
1 like
Level 2
@Sinnbeck you mean if the description has array or something else i will need to foreach
Level 102
@karimali1337 Yeah as it is json_decoded back into an array
1 like
Level 104
When you json_decode JSON from the database, you’re getting a stdClass instance (or an array if you pass true as second argument); you can’t actually echo either using Blade braces because it’s got no __toString method
Level 2
@tykus so any hint how should i show it, i want to show the teacher_description
Level 104
@karimali1337 use the array cast in the model so you’re dealing with reliable data type.
// User model:
protected $casts = [
'custom_field' => 'array'
];
Then index into the array:
{{ $teacher->custom_field['teacher_description'] ?? 'n/a' }}
1 like
Please or to participate in this conversation.