How to use OR and AND with where clause in laravel 5.3?

Question

-- Query I want to use :

select * from users where (email like '%[email protected]%' OR username like 'myusername') AND (password like '%1234@abcde%')

-- My laravel code for above query is :

$getInfo = Users::where('password','like','%'.$request->password.'%')
            ->where(function($query){
                $query->where('email','like','%'.$request->username.'%')
                ->orWhere('username','like','%'.$req->username.'%');
            })->get();

Here I am getting an error Undefined variable: request

You can use WhereRaw( ((email like '%'.$email.'%' OR username like '.$username.') AND (password like '%'.$password.'%')) ). Also its not my place to ask but why aren't you encrypting password while saving? — Rohit Dalal
– Rohit Dalal, Commented Jun 14, 2018 at 9:55
I am using laravel so I guess it would be good if I should use laravel functions rather than using raw query. — Moksh
– Moksh, Commented Jun 14, 2018 at 9:59
Its inbuild laravel function. At the end all the eloquent queries are changed by laravel to SQL commands for sql database. — Rohit Dalal
– Rohit Dalal, Commented Jun 14, 2018 at 10:01

M Khalid Junaid · Accepted Answer · 2018-06-14 07:58:25Z

2

You need to pass $request to your closure function like use ($request)

$getInfo = Users::where('password','like','%'.$request->password.'%')
            ->where(function($query) use ($request){
                $query->where('email','like','%'.$request->username.'%')
                ->orWhere('username','like','%'.$req->username.'%');
            })->get();

Also its not a good idea to search user details using like with wildcard (%) on both sides, it should be just like without wildcards or just use equality comparison =

answered Jun 14, 2018 at 7:58

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

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

6 Comments

Moksh Over a year ago

Thank you for the help. It works but it does not return any data.

Moksh Over a year ago

It returns only [] with message "no properties" in my ajax response

M Khalid Junaid Over a year ago

Can you check you have exact data in DB against the data you receive from $request also do check the final sql generated by query builder using toSql() instead of get()

Moksh Over a year ago

it returns select * from users where password = ? and (email = ? or username = ?)

M Khalid Junaid Over a year ago

@Moksh check binding values for these (?) placeholders and then evaluate your query

|

FULL STACK DEV · Accepted Answer · 2018-06-14 08:24:10Z

1

$getInfo = Users::where('password','like','%'.$request->password.'%')
            ->where(function($query) use ($request){
                $query->where('email','like','%'.$request->username.'%')
                ->orWhere('username','like','%'.$request->username.'%');
            })->get();

You have can variables to closure using use ($request).

You have also a typo

change

->orWhere('username','like','%'.$req->username.'%');

to

->orWhere('username','like','%'.$request->username.'%');

answered Jun 14, 2018 at 8:24

FULL STACK DEV

16k6 gold badges49 silver badges67 bronze badges

1 Comment

Moksh Over a year ago

Thank you for your support and yes it was my typo.

Collectives™ on Stack Overflow

How to use OR and AND with where clause in laravel 5.3?

2 Answers 2

6 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related