laravel - custom search not working, multiple fields

Question

i am trying to create search for my dashbord where have 4 field,

so i can search one by one or both at the same time name, age, location, phone, i wrote a code but its not working

    $q = Model::query();

  if (Input::has('name'))
  {
    $q->where('name',Input::get('name'));
  }

  if (Input::has('age'))
  {
    $q->where('age',Input::get('age'));
  }

  if (Input::has('location'))
  {
    $q->where('location', Input::get('location'));
  }

  if (Input::has('phone'))
  {
    $q->where('phone', Input::get('phone'));
  }

Getting empty output:

[]

Maybe you should include the whole code. This is output of what? What's your Laravel version? — Marcin Nabiałek
– Marcin Nabiałek, Commented Jun 16, 2018 at 18:24

user7747472 · Accepted Answer · 2018-06-16 18:56:21Z

2

Try this,

 $q = Model::select('id','name','age'); //What ever field you need, This will create model instance

  if (Input::has('name') && !empty(Input::get('name'))
  {
    $q->where('name',Input::get('name'));
  }

  if (Input::has('age') && !empty(Input::get('age'))
  {
    $q->where('age',Input::get('age'));
  }

  if (Input::has('location') && !empty(Input::get('location'))
  {
    $q->where('location', Input::get('location'));
  }

  if (Input::has('phone') && !empty(Input::get('phone'))
  {
    $q->where('phone', Input::get('phone'));
  }
$result = $q->get()->toArray(); 
print_r($result);

This should give you what you are looking for

edited Jun 16, 2018 at 18:56

answered Jun 16, 2018 at 18:50

user7747472

1,9726 gold badges41 silver badges84 bronze badges

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

4 Comments

The Alpha Over a year ago

why toArray()?

user7747472 Over a year ago

toArray() is to get response in array format. If you dont give that you will get response as an object.

Muhammad Hamza Younas Over a year ago

user774742 i tried your code its working but problem only first field is working when i leave first two fields empty or leave just first empty getting this error Illuminate\Database\Eloquent\Collection Object ( [items:protected] => Array ( ) ) []

user7747472 Over a year ago

Dont use array, And i made a mistake before . I forgot to add && in the condition please check on that one

Collectives™ on Stack Overflow

laravel - custom search not working, multiple fields

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related