How to use if statement in where condition in Laravel?

Question

I want to query the database as follows:

User::where('type', 'student')->where('registered_at', '>=', $year)->get();

if the user type is 'student' I want to get the registered from this year, however if the type is 'faculty' I don't want to have this 'registered_at' condition and want to execute this.

User::where('type', 'faculty')->get();

How to execute this so I have 1 query with kind of an if statement, if type is 'student' than give me only result above this $year and if type is 'faculty' give the results?

Do you want to get all users which are students with registered_at and all users with type faculty in one list? — UfguFugullu
– UfguFugullu, Commented Apr 8, 2020 at 11:09
@UfguFugullu Yes, I found the 'orWhere' clause can have a callback where I can have my conditions. — Emmanuel-Ab
– Emmanuel-Ab, Commented Apr 8, 2020 at 11:17

UfguFugullu · Accepted Answer · 2020-04-08 11:20:59Z

1

I've found the solution in the documentation.

    User::where(function ($query) {
        $query->where('type', 'student')->where('registered_at', '>=', $year);
    })->orWhere(function($query) {
        $query->where('type', 'faculty');
    })->get();

edited Apr 8, 2020 at 11:20

UfguFugullu

2,16715 silver badges19 bronze badges

answered Apr 8, 2020 at 11:14

Emmanuel-Ab

3312 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

How to use if statement in where condition in Laravel?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related