Where condition in Laravel Relationship Example
In this post we will give you information about Where condition in Laravel Relationship Example. Hear we will give you detail about Where condition in Laravel Relationship ExampleAnd how to use it also give you demo for it if it is necessary.
Laravel 5 provide great feature as model relationship. but if you need to use where clause on your relation model then how you can do it?, You can make where condition using whereHas function. it doesn’t matter which relation you used like one to one, one to many, many to many, has many through etc.
Sometime might be you need to add where condition with your relation model then you can simply use whereHas() as i provide bellow example.
Several days ago i had same situation when i used laravel relationship. need to use where condition like i need to get those users that country is “India”. so i write condition like as bellow example:
Example:
$users = User::whereHas('countries', function($q){
$q->where('name', '=', 'India');
})->get();
dd($users);
You can also pass dynamic variable inside the whereHas() like this way:
Example 2:
$search = 'India';
$users = User::whereHas('countries', function($q) use($search){
$q->where('name', '=', $search);
})->get();
dd($users);
I hope it can help you….
Hope this code and post will helped you for implement Where condition in Laravel Relationship Example. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs