Where condition in Laravel Relationship Example

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:

Also see:Laravel 5.7 – Comment System Tutorial from Scratch

$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

For More Info See :: laravel And github

Leave a Comment

Your email address will not be published. Required fields are marked *

  +  74  =  77

We're accepting well-written guest posts and this is a great opportunity to collaborate : Contact US