Dfyjkt

I am trying to code an app which has several "Locations" which users can add as their favorites. I have a model for Locations, a model for Favorites and a database table where I log pairs of user_id and location_id to indicate a user's favorite locations.

In my Location model I have defined the following hasMany relationship:

public function favorites()
 return $this->hasMany(Favorite::class);

I have also defined the inverse relationship on the Favorite model as follows:

public function location()
 return $this->belongsTo(Location::class);

Then in a view I'm trying to get a list of all locations and mark those which the user has marked as favorite. To do this I am looping through all locations, and trying to get a count on how many favorites the location has. It should be either 1 or 0, since the user_id/location_id combination row only exists if the user has the specific location as hi favorite.

Here is the relevant part of the code (I am passing a list of locations to the view):

@foreach ($Locations_List as $Location)
 $Location->favorites()->get()->count 
@endforeach

Here is how I'm passing the $Locations_List:

 public function Create_SearchResults()

$Locations_List = Location::select('id', 'Name', 'Category', 'Logo', 'Status', 'Address_Number', 'Address_Street', 'Address_City', 'Updated_At')
 ->where('Status', '>=', 500)
 ->get();

return view('Location_Search/Index', compact('Locations_List'));

However, when I try the above, I get "Property [count] does not exist on this collection instance.".

I have tried doing something similar to the above in tinker, and it does work. However, I had to resolve the "array" piece of it as follows:

$loc = AppLocation::find(2);
$loc->favorites()->get()->count();

How do I get over the "array" issue on the view? Thanks in advance

Try $Location->favorites->count() inside the foreach loop.

Alternatively, you can eager load the counts in the controller by adding

->withCount('favorites') when initializing $Locations_List:

$Locations_List = Location::select('id', 'Name', 'Category', 'Logo', 'Status', 'Address_Number', 'Address_Street', 'Address_City', 'Updated_At')
 ->withCount('favorites')
 ->where('Status', '>=', 500)
 ->get();

In this case, you can simply put $Location->favorites_count in the foreach loop.