Laravel how to retrieve specific value in array

Question

I have a polymorphic relation between organizations and ratings. My ratings table is set up like so:

id - integer
user_id - integer
score - integer
ratable_type - text
ratable_id - integer

Calling $org->ratings will retrieve an array with all ratings associated with that specific org. However, I only want to see if there is a rating with a specific user_id value.

Basically, I want to retrieve the rating with user_id = Auth::user()->id. Is this possibly without looping through all the ratings to see when $org->rating->user_id == Auth::user()->id?

You need to fetch the related ratings and then check or rather do simple check with db query? — Jarek Tkaczyk
– Jarek Tkaczyk, Commented May 30, 2014 at 8:43
I ended up using Rating::where('user_id', '=', Auth::user()->id)->where('ratable_type', '=', 'Org')->where('ratable_id', '=', $org->id)->first(), but is there a more succinct way to do this? — chipit24
– chipit24, Commented May 30, 2014 at 18:13

Jarek Tkaczyk · Accepted Answer · 2014-05-30 18:20:47Z

1

If you don't need to load the relation, then simply query the DB:

$org->ratings()->where('user_id', Auth::id())->first();
// returns Rating model or NULL

// in previous versions of the framework (if Auth has no id method)
$org->ratings()->where('user_id', Auth::user()->id)->first();

Otherwise filter the collection:

$org->ratings->first(function ($key, $rating) {
     return $rating->user_id == Auth::id();
});
// like before: Rating model or NULL

answered May 30, 2014 at 18:20

Jarek Tkaczyk

81.4k27 gold badges167 silver badges162 bronze badges

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

1 Comment

chipit24 Over a year ago

Using $org->ratings()->where('user_id', Auth::id())->first(); worked.

Collectives™ on Stack Overflow

Laravel how to retrieve specific value in array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related