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.
Laravel 5.5 group by doesn't work - fixed
In this post we will give you information about Laravel 5.5 group by doesn't work - fixed. Hear we will give you detail about Laravel 5.5 group by doesn't work - fixedAnd how to use it also give you demo for it if it is necessary.
Someday ago i just installed laravel 5.5 application and i was checking new feature and making some examples. But i was working on database query builder example one by one, i got following error when i used group by on single column.
My query was like as bellow example, so you can see on database query i simple get all users and group by with name. So, let's simply see how it is:
DB Query:
$users = DB::table("users")
->groupBy("name")
->get();
dd($users);
But when i run above query using database query builder i got following error, as you can see:
SQLSTATE[42000]: Syntax error or access violation: 1055 'laravel_test.users.id' isn't in GROUP BY (SQL: select * from 'users' group by 'name')
I was thinking what is the issue because without group by it was working, but at last i found it how to solve it So we have to simply "strict" mode make it true into false in database.php file. So let's do it as bellow:
config/database.php
...
'strict' => true,
To
'strict' => false,
....
After that i hope you found your solution.
Thank you...
Hope this code and post will helped you for implement Laravel 5.5 group by doesn't work - fixed. 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
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