Why Query Builder offers flexibility in Laravel - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to start a query using Laravel's Query Builder.

Laravel

$users = DB::[1]('users')->get();

Drag options to blanks, or click blank then click option'

Aselect

Btable

Cfrom

Dquery

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'select' instead of 'table' to start the query.

The table method starts a query on the specified table, giving flexibility to build queries.

2fill in blank

medium

Complete the code to add a condition to the query.

Laravel

$users = DB::table('users')->where('[1]', 'active')->get();

Drag options to blanks, or click blank then click option'

Aid

Bname

Cemail

Dstatus

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'name' or 'email' which are not status indicators.

The where method filters results. Here, filtering users with status equal to 'active' shows flexibility in conditions.

3fill in blank

hard

Fix the error in the code to chain multiple conditions.

Laravel

$users = DB::table('users')->where('status', 'active')->[1]('age', '>', 18)->get();

Drag options to blanks, or click blank then click option'

AorWhere

BwhereBetween

Cwhere

Dhaving

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'orWhere' changes the logic to OR instead of AND.

To add multiple conditions that all must be true, chain where methods. This shows flexibility in building complex queries.

4fill in blank

hard

Fill both blanks to select specific columns and order results.

Laravel

$users = DB::table('users')->[1](['name', 'email'])->orderBy('[2]', 'desc')->get();

Drag options to blanks, or click blank then click option'

Aselect

Bwhere

Ccreated_at

Dname

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'where' instead of 'select' for columns.

The select method chooses columns to retrieve, and orderBy sorts results by a column like created_at. This flexibility lets you customize output.

5fill in blank

hard

Fill all three blanks to group results, count users, and filter groups.

Laravel

$results = DB::table('users')->select('[1]', DB::raw('[2] as user_count'))->groupBy('[3]')->having('user_count', '>', 5)->get();

Drag options to blanks, or click blank then click option'

Astatus

Bcount(*)

Dage

Attempts:

3 left

💡 Hint

Common Mistakes

Using different columns for select and groupBy.

This query groups users by status, counts users in each group, and filters groups with more than 5 users. Query Builder's flexibility allows such complex queries easily.