Laravel Filter with multiple values

Question

When trying to filter with only username or email code works fine.But when i am trying to filter with both email and username it returns empty.what i am missing

User model

public function scopeEmail($query, $email)
{
   $query->where('email','=', $email);

}
public function scopeUsername($query, $username)
{
    $query->where('username','=', $username);
}

Controller:

    public function filter(Request $request)
    {

      $q = User::query();
      $email = $request->input('email');
      $username= $request->input('username');
      if (isset($email))
      {
         // simple where here or another scope, whatever you like
         $q->Email($request->input('email'));
      }

      if (isset($username))
      {
          $q->Username($request->input('username'));
      }
         //execute
       $results = $q->get();
       return response()->json(['issError'=>0, 'errorCode'=>0,'message'=>$results],200);
    }

Dhruv Raval · Accepted Answer · 2018-09-14 14:09:27Z

1

Use When to make filter easy:

public function filter(Request $request)
{
   $q = User::query();
   $email = $request->input('email');
   $username= $request->input('username');

    $q->when($email,function ($query){
       $query->where('email',$email);
    });

    $q->when($username,function ($query){
       $query->where('username',$username);
    });

   $results = $q->get();
   return response()->json(['issError'=>0, 'errorCode'=>0,'message'=>$results],200);
}

answered Sep 14, 2018 at 14:09

Dhruv Raval

1,5831 gold badge10 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Leena Patel · Accepted Answer · 2018-09-14 07:07:08Z

0

Use simple where in if statements

public function filter(Request $request)
{

  $q = User::query();
  $email = $request->input('email');
  $username= $request->input('username');
  if (isset($email))
  {
     // simple where here or another scope, whatever you like
     $q = $q->where('email', $request->input('email'));
  }

  if (isset($username))
  {
      $q = $q->where('username', $request->input('username'));
  }
     //execute
   $results = $q->get();
   return response()->json(['issError'=>0, 'errorCode'=>0,'message'=>$results],200);
}

edited Sep 14, 2018 at 7:07

answered Sep 14, 2018 at 6:57

Leena Patel

2,4531 gold badge17 silver badges30 bronze badges

1 Comment

weaver Over a year ago

Same result.. Returnig empty array

sinemunll · Accepted Answer · 2020-06-16 08:23:35Z

0

Try this

 public function filter(Request $request)
 {
   $q = User::query();
   $email = $request->input('email');
   $username= $request->input('username');
   if (!is_null($email))
   {
     $q = $q->where('email', $email);
   }

   if (!is_null($username))
   {
      $q = $q->where('username', $username));
   }

   $results = $q->get();
   return response()->json(['issError'=>0, 'errorCode'=>0,'message'=>$results],200);
}

answered Jun 16, 2020 at 8:23

sinemunll

1

Collectives™ on Stack Overflow

Laravel Filter with multiple values

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related