Fix error in Eloquent query

user

id name address_id

id photo_id

id description

I need to get all user which has photo description ="nice" whats the correct Eloquent to get the result

$user= Users::with('address.photo', function (Builder $query) { $query->where('photo.description', 'like', 'nice'); } )->paginate(5);

Level 88

What is the error you get?

Anyway, your query should look like this

$user= Users::with('address.photo', function (Builder $query) { 
    $query->where('description', 'like', '%nice%'); 
})->paginate(5);

Level 2

i get error

ErrorException mb_strpos() expects parameter 1 to be string, object given

Best Answer

Level 122

I need to get all user which has photo description ="nice"

then you need to use whereHas to query by a relation.

Level 2

thanks, now its work

Please or to participate in this conversation.