OrWhere and advanced conditions in Laravel - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ component_behavior

intermediate

What is the resulting SQL query from this Laravel Eloquent snippet?

Consider the following Laravel Eloquent query builder code. What SQL query does it produce?

Laravel

User::where('status', 'active')
    ->orWhere('role', 'admin')
    ->toSql();

A select * from `users` where `status` = ? or `role` = ?

B select * from `users` where `status` = ? and `role` = ?

C select * from `users` where `status` = ? or `role` != ?

D select * from `users` where `status` != ? or `role` = ?

💡 Hint

Remember that orWhere adds an OR condition to the previous WHERE clause.

The orWhere method adds an OR condition to the query. So the SQL will have WHERE status = ? OR role = ?.

📝 Syntax

intermediate

Which option correctly uses orWhere with a closure for grouped conditions?

You want to find users who are either active or have the role admin and are verified. Which Laravel query is correct?

A

User::where('status', 'active')
    ->orWhere('role', 'admin')
    ->where('verified', true)
    ->get();

B

User::where('status', 'active')
    ->orWhere(function($query) {
        $query->where('role', 'admin')
        ->orWhere('verified', true);
    })
    ->get();

C

User::where('status', 'active')
    ->where(function($query) {
        $query->orWhere('role', 'admin')
              ->where('verified', true);
    })
    ->get();

D

User::where('status', 'active')
    ->orWhere(function($query) {
        $query->where('role', 'admin')
              ->where('verified', true);
    })
    ->get();

💡 Hint

Use a closure inside orWhere to group multiple conditions combined with AND.

Option D groups role = admin AND verified = true inside orWhere, so the query is: status = active OR (role = admin AND verified = true).

🔧 Debug

advanced

Why does this Laravel query not return expected results?

Given this code, why might the query not return users who are active or admins who are verified? User::where('status', 'active') ->orWhere('role', 'admin') ->where('verified', true) ->get();

A Because the where('verified', true) applies only to the last orWhere condition, not grouped properly.

B Because orWhere cannot be used after where; it must be first.

C Because the query is missing a join to the roles table.

D Because the where('status', 'active') is ignored when orWhere is used.

💡 Hint

Think about how Laravel groups where and orWhere conditions without closures.

The where('verified', true) applies only to the last condition, so the query is: (status = active) OR (role = admin AND verified = true) is NOT guaranteed. Instead, it becomes: (status = active) OR (role = admin) AND verified = true, which changes logic due to operator precedence.

🧠 Conceptual

advanced

What is the effect of this Laravel query on the generated SQL?

Examine this Laravel query: User::where(function($query) { $query->where('status', 'active') ->orWhere('role', 'admin'); })->where('verified', true)->toSql(); What does the SQL WHERE clause look like?

A WHERE `status` = ? OR (`role` = ? AND `verified` = ?)

B WHERE (`status` = ? OR `role` = ?) AND `verified` = ?

C WHERE `status` = ? OR `role` = ? OR `verified` = ?

D WHERE `status` = ? AND `role` = ? AND `verified` = ?

💡 Hint

Closures group conditions inside parentheses in SQL.

The closure groups status and role with OR inside parentheses, then the outer where adds AND verified = true.

❓ state_output

expert

What is the count of users returned by this Laravel query?

Assume the users table has these rows: | id | status | role | verified | |----|---------|-------|----------| | 1 | active | user | true | | 2 | inactive| admin | true | | 3 | active | admin | false | | 4 | inactive| user | true | | 5 | active | admin | true | What is the count of users returned by this query? User::where('status', 'active') ->orWhere(function($query) { $query->where('role', 'admin') ->where('verified', true); }) ->get() ->count();

A 5

B 2

C 4

D 3

💡 Hint

Check which rows satisfy status = active OR (role = admin AND verified = true).

Rows matching status = active: ids 1,3,5. Rows matching role = admin AND verified = true: ids 2,5. Combined with OR: ids 1,2,3,5. But careful: the query is status = active OR (role = admin AND verified = true). So ids 1,3,5 (active) plus id 2 (admin & verified). So total 4 rows.