Why Eloquent simplifies database operations in Laravel - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to retrieve all users using Eloquent.

Laravel

$users = User::[1]();

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

Aall

Bget

Cfetch

Dselect

Attempts:

3 left

💡 Hint

Common Mistakes

User::get() also returns a collection of all Eloquent models, but all() is the dedicated shortcut.

'fetch' does not exist, and 'select()' specifies columns but requires ->get() to retrieve records.

The all() method retrieves all records from the users table as Eloquent models.

2fill in blank

medium

Complete the code to find a user by their primary key using Eloquent.

Laravel

$user = User::[1](1);

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

Afind

Bfirst

Cget

Dwhere

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'where' requires additional method calls to get the result.

Using 'get' returns a collection, not a single model.

User::first() gets the first record, not by specific ID; use where('id', 1)->first() instead.

The find() method retrieves a model by its primary key, simplifying the query.

3fill in blank

hard

Fix the error in the code to create and save a new user with Eloquent.

Laravel

$user = new User;
$user->name = 'Alice';
$user->email = '[e-mail]';
$user->[1]();

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

Acreate

Binsert

Cupdate

Dsave

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'insert' is a query builder method, not for model instances.

Using 'create' requires mass assignment and static call.

Using 'update' is for modifying existing records, not new ones.

The save() method saves the model instance to the database. 'insert' and 'create' are different methods, and 'update' is for existing records.

4fill in blank

hard

Fill both blanks to get users whose age is greater than 18 using Eloquent.

Laravel

$adults = User::where('[1]', '[2]', 18)->get();

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

Aage

B>

C<

Dname

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' will get users younger than 18.

Using 'name' instead of 'age' filters by the wrong column.

The where method filters users where the 'age' column is greater than 18.

5fill in blank

hard

Fill all three blanks to create a dictionary of user emails and names for users older than 25.

Laravel

$result = User::where('[1]', '[2]', 25)->pluck('[3]', 'email');

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

Aage

B>

Cname

Demail

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'email' instead of 'name' for the values will swap keys and values.

Using '<' instead of '>' will filter the wrong users.

This code gets a list of user names keyed by their email for users older than 25.

Practice

1. What is the main reason Eloquent simplifies database operations in Laravel?

easy

A. It lets you use PHP code instead of writing raw SQL queries.

B. It requires you to write complex SQL queries manually.

C. It only works with NoSQL databases.

D. It replaces PHP with a new programming language.

Solution

1. Step 1: Understand Eloquent's purpose

   Eloquent is designed to let developers interact with databases using PHP code instead of SQL.

2. Step 2: Compare options

   Options A, C, and D are incorrect because Eloquent does not require manual SQL, does not only work with NoSQL, and does not replace PHP.

3. Final Answer:

   It lets you use PHP code instead of writing raw SQL queries. -> Option A

4. Quick Check:

   Eloquent uses PHP code, not raw SQL [OK]

Hint: Eloquent means PHP code replaces SQL queries [OK]

Common Mistakes:

• Thinking Eloquent requires writing SQL manually
• Confusing Eloquent with NoSQL tools
• Believing Eloquent changes the programming language

2. Which of the following is the correct way to retrieve all records from a User model using Eloquent?

easy

A. $users = User::selectAll();

B. $users = User->getAll();

C. $users = User::fetch();

D. $users = User::all();

Solution

1. Step 1: Recall Eloquent syntax for retrieving all records

   The correct method to get all records is all() called statically on the model.

2. Step 2: Check each option

   Only User::all() is valid. The others are not Eloquent methods.

3. Final Answer:

   $users = User::all(); -> Option D

4. Quick Check:

   Use all() to get all records [OK]

Hint: Use Model::all() to get all records [OK]

Common Mistakes:

• Using instance method instead of static method
• Using non-existent methods like fetch() or selectAll()
• Confusing method names with SQL keywords

3. Given the code:

 $user = User::find(5); 
 echo $user->name; 

What will happen if there is no user with ID 5 in the database?

medium

A. It will throw an error because $user is null.

B. It will print an empty string.

C. It will create a new user with ID 5 automatically.

D. It will return a default user object with empty properties.

Solution

1. Step 1: Understand what find() returns

   If no record matches the ID, find() returns null.

2. Step 2: Analyze the code behavior

   Trying to access $user->name when $user is null causes an error.

3. Final Answer:

   It will throw an error because $user is null. -> Option A

4. Quick Check:

   find() returns null if not found [OK]

Hint: Remember: find() returns null if no record [OK]

Common Mistakes:

• Assuming find() returns empty object
• Expecting automatic creation of missing records
• Ignoring null check before accessing properties

4. Identify the error in this Eloquent code snippet:

 $user = new User; 
 $user->name = 'Alice'; 
 $user->save; 

medium

A. User model cannot be instantiated directly.

B. Incorrect property name 'name'.

C. Missing parentheses when calling save method.

D. save method should be static.

Solution

1. Step 1: Check method call syntax

   The save method must be called with parentheses: save().

2. Step 2: Verify other parts

   Property name 'name' is valid, User can be instantiated, and save is not static.

3. Final Answer:

   Missing parentheses when calling save method. -> Option C

4. Quick Check:

   Always call methods with parentheses [OK]

Hint: Methods need parentheses even if no arguments [OK]

Common Mistakes:

• Forgetting parentheses on method calls
• Thinking save is a static method
• Assuming property names must be different

5. You want to update the email of a user with ID 10 using Eloquent. Which code snippet correctly does this and saves the change?

hard

A. $user = User::find(10);$user->updateEmail('[e-mail]');

B. $user = User::find(10);if ($user) { $user->email = '[e-mail]'; $user->save();}

C. User::update(['email' => '[e-mail]'])->where('id', 10);

D. $user = User::where('id', 10);$user->email = '[e-mail]';$user->save();

Solution

1. Step 1: Retrieve the user by ID

   Use find(10) to get the user object or null if not found.

2. Step 2: Update property and save

   Check if user exists, set email, then call save() to update the database.

3. Final Answer:

   Code snippet that finds user, updates email, and calls save() -> Option B

4. Quick Check:

   Find, modify property, then save [OK]

Hint: Find user, change property, then call save() [OK]

Common Mistakes:

• Trying to update without retrieving the model instance
• Calling update on query builder without correct syntax
• Using non-existent methods like updateEmail