Level 75
Use whereHas for that
https://laravel.com/docs/8.x/eloquent-relationships#querying-relationship-existence
Oct 5, 2021
5
Level 4
Query builder (one-to-many and many-to-many)
Hi,
I have a one to one relationship (course->university) and a many to many relationships (course -> cities) I am trying to query all courses that belong to a specific university and are held in a specific city.
I can get all courses that are linked to a specific (Course::where('university_id', university_id)->get()) but I cannot figure out how to also pull/filter down the courses to the specific city.
Thank you, Mihail
Level 4
Thank you for the replay, but I still cannot figure out how to put it all in a single query :(.
I have received in the backend an university_id and city_id but I am not able to build a single query using the two of them.
Level 4
I've tried something like that but doesn't seem to work
Course::where('university_id', 1)->whereHas('cities', function (Builder $query){$query->where('city_id',1);})->get()
Level 75
@tudosm Learn how to write code here on Laracasts...
$courses = Course::where('university_id', 1)->whereHas('cities', function ($query) {
$query->where('id', 1);
})->get();
Level 4
Thank you @MichalOravec, I am still at the beginning but definitely will look into it :)
Please or to participate in this conversation.