我有一个模型用户,我想按城市进行搜索用户
我的代码
User::where('city', $city)->orderBy('created_at')->paginate(10);
但是,如果城市变量为无效,查询返回
我你这个
User::doesntHave('city')->get();
和这个
User::whereHas('city')->get();
我知道我可以像这样阅读我的代码
if($city){
User::where('city', $city)->orderBy('created_at')->paginate(10);
} else {
User::orderBy('created_at')->paginate(10);
}
,但要在我的查询中添加其他可变性,并且不是完美的
1。您可以使用where()
闭合:
User::where(function ($q) use($city) {
if ($city) {
$q->where('city', $city);
}
})->orderBy('created_at')->paginate(10);
2。您可以使用when()
:
User::when($city, function ($q) use ($city) {
return $q->where('city', $city);
})->orderBy('created_at')->paginate(10);
3。执行此操作:
$users = User::orderBy('created_at');
if ($city) {
$users = $users->where('city', $city);
}
$users = $users->paginate(10);