Laravel search multiple fields

Question

I currently have a search function on my website, I need it to search 3 fields - appid, mobilenumber, email .

Right now once the user enters the data in the search box it searches all 3 but its not working.

Data is collected using GET.

Here is my query

http://www.example.com?id=1&searchall=07853637362

$mobile = INPUT::get('searchall');
$email = INPUT::get('searchall');
$appid = INPUT::get('searchall');

$data = DB::table('leads')
->when($mobile, function($query) use ($mobile){
    return $query->where('MobilePhone', $mobile);
})
->when($email, function($query) use ($email){
    return $query->where('Email', $email);
})
->when($appid, function($query) use ($appid){
    return $query->where('AppID', $appid);
})
->get();

So I need it to search each field until it finds the correct field value.

Consider writing some manual SQL from time to time, that would make you know that there are OR clauses for something :) — Borjante
– Borjante, Commented Feb 28, 2017 at 12:07

MatHatrik · Accepted Answer · 2017-02-28 12:25:36Z

4

$mobile = INPUT::get('searchall');
$email = INPUT::get('searchall');
$appid = INPUT::get('searchall');

$data = DB::table('leads')
->when($mobile, function($query) use ($mobile){
                return $query->orWhere('MobilePhone', $mobile);
            })

            ->when($email, function($query) use ($email){
                return $query->orWhere('Email', $email);
            })

            ->when($appid, function($query) use ($appid){
                return $query->orWhere('AppID', $appid);
            })->get();

answered Feb 28, 2017 at 12:25

MatHatrik

7641 gold badge6 silver badges16 bronze badges

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

Comments

EddyTheDove · Accepted Answer · 2017-02-28 12:15:48Z

0

To search data try with like

->when($mobile, function($query) use ($mobile){
     return $query->where('MobilePhone', 'like', '%'. $mobile . '%');
})

to actually search each field, use orWhere

$keywords = Input::get('searchall');
$data = DB::table('leads')
->where('mobilephone', '=', $keywords)
->orWhere('email', '=', $keywords)
->orWhere('AppID', '=', $keywords)
->get();

edited Feb 28, 2017 at 12:15

answered Feb 28, 2017 at 12:08

EddyTheDove

13.2k2 gold badges40 silver badges46 bronze badges

Comments

jakub wrona · Accepted Answer · 2017-02-28 12:18:17Z

0

I don't understand why you need the same value from the user using 3 variables, so the following is the simplified version:

$searched = Input::get('searchall');

$matched = DB::table('leads')
->where('MobilePhone', $searched)
->orWhere('Email', $searched)
->orWhere('AppID', $searched)
->get();

answered Feb 28, 2017 at 12:18

jakub wrona

2,25219 silver badges19 bronze badges

Collectives™ on Stack Overflow

Laravel search multiple fields

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related