Question 17006 in Laravel Question posted in
The official Laravel Documentation can be found here.

Laravel Query in if else converting to common query

this is my code I want to convert this query in to a common query

 if ($limit == 0) {
   $response = WebhookErrorNotification::where('is_error', true)->orderByDesc('id')->get();
   } else {
  $response = WebhookErrorNotification::where('is_error', true)->orderByDesc('id')->limit($limit)->get();
            }
Tags:

2

Answers


  1. 0

    You can save the query in a variable above the if/else statement. So something like this would work. Now if this is not the answer you are looking for please specify what you mean by common query!

    $query = WebhookErrorNotification::where('is_error', true)->orderByDesc('id');
if ($limit == 0) {
  $response = $query->get();
} else {
  $response = $query->limit($limit)->get();
}
    Login or Signup to reply.
  2. 0

    you can do something like this

    $response = WebhookErrorNotification::where('is_error', true)
    ->when($limit !== 0, function ($query) use ($limit) {
        $query->limit($limit);
    })->orderByDesc('id')->get();
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search