Many cases we need to write conditional queries with laravel eloquent. For that we generally use \u201cif\u201d and \u201celse\u201d conditions and based on the condition we are used to make our query. Now laravel supports these types of conditional queries using the when() method.<\/p>\n
Laravel provides a when() method to apply those kinds of conditional queries. Here we can understand by using the example.<\/p>\n
For example we are used to make conditional queries like below:<\/p>\n
$role = $request->role;\r\n$query = Users::query();\r\n\r\nif($role==\u2019user\u2019)\r\n{\r\n $query->where(\u2018role\u2019, \u2018user\u2019);\r\n}\r\nelse\r\n{\r\n $query->where(\u2018role\u2019, \u2018admin\u2019);\r\n}\r\n\r\n$users =$query->get();\r\n<\/pre>\nNow we can simplify this by using when() method provided by laravel<\/p>\n
\r\n$users = Users::when($role, function (Builder $query, string $role) {\r\n $query->where('role', $role);\r\n})->get();<\/pre>\nIn addition to this we can also pass value to the when method that needs to be checked.<\/p>\n
\r\n$query = User::query();\r\n\r\n$query->when(request('role', false), function ($q, $role) {\r\n return $q->where('role', $role);\r\n});\r\n$users = $query->get();\r\n<\/pre>\nWe can also pass the callback\/clousar function as default value which needs to be executed only if the condition matched. We can pass greater than or less then conditions as well.<\/p>\n
\r\n$users = User::when(request('filter') == 'counts\u2019, function ($q) {\r\n return $q->where('counts\u2019, '>', request('likes_count', 0));\r\n}, function ($q) {\r\n return $q->orderBy('created_at', \u2018DESC\u2019);\r\n})->get();\r\n<\/pre>\n