Convert mysql json field to object in Laravel 5.5

Question

I have this table in Mysql, details column is a json type.

This is the OrderDetails model

class OrderDetail extends Model
{   
    protected $casts = [
        'details' => 'array',
    ];
}

This is the controller

class HomeController extends Controller
{
    public function index()
    {
        $result = OrderDetail::where('details->options->size', 'L')
            ->limit(10)
            ->get();

        return view('home', compact(['result']));
     }
}

And the home view

@if($result->count())
    @foreach($result as $item)
        <li>{{ $item->details }}</li>
    @endforeach
@endif

Im getting this error

htmlspecialchars() expects parameter 1 to be string, array given (View: /***/resources/views/home.blade.php)

But if i remove the protected $casts[] from the model it shows me the JSON, how can i convert the details field in to an object having the the id and order_id fields in the same query?

Edit

Now i have get a JSON to object conversion inserting a foreach with a json_decode and removing the protected $casts[] from the model, is there a better way to this?

class HomeController extends Controller
{
    public function index()
    {
        $result = OrderDetail::where('details->options->size', 'L')
            ->limit(10)
            ->get();

        foreach($result as $key => $item){
               $result[$key]->details = json_decode($item->details);
        }

        return view('home', compact('result'));
    }
}

Laravel 5.3 - htmlspecialchars() expects parameter 1 to be string — LF-DevJourney
– LF-DevJourney, Commented Nov 7, 2017 at 10:38
@KrisRoofe I check this before, but is there any way to get the json field as an object to avoid this in blade {{ $item->details['options']['size'] }} ? — Ricardo Albear
– Ricardo Albear, Commented Nov 7, 2017 at 10:58

Death-is-the-real-truth · Accepted Answer · 2017-11-07 10:38:59Z

2

Remove square brackets from compact function

return view('home', compact('result'));

edited Nov 7, 2017 at 10:38

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

answered Nov 7, 2017 at 10:37

Ivaylo

4767 silver badges21 bronze badges

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

1 Comment

Ricardo Albear Over a year ago

I try this before and the **htmlspecialchars() ** error persist.

Collectives™ on Stack Overflow

Convert mysql json field to object in Laravel 5.5

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related