Tinker for database interaction in Laravel - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ component_behavior

intermediate

What is the output of this Tinker command?

You run this command in Laravel Tinker:
App\Models\User::where('email', '[e-mail]')->exists();
What does this command return if a user with that email exists?

A true

B false

C The user model instance

D An array of users

💡 Hint

Think about what the 'exists()' method returns in Laravel queries.

The 'exists()' method returns a boolean true if any record matches the query, otherwise false.

📝 Syntax

intermediate

Which Tinker command correctly updates a user's name?

You want to update the name of the user with id 5 to 'Alice' using Laravel Tinker. Which command is correct?

A App\Models\User::find(5)->name = 'Alice'; App\Models\User::update();

B App\Models\User::find(5)->update(['name' => 'Alice']);

C App\Models\User::find(5)->name = 'Alice'; App\Models\User::save();

D App\Models\User::where('id', 5)->update('name', 'Alice');

💡 Hint

Remember how to update attributes and save changes in Eloquent models.

Option B uses the correct update method on the model instance. Option B has wrong syntax for update. Options C and D misuse save/update methods.

🔧 Debug

advanced

Why does this Tinker command cause an error?

You run:
$user = App\Models\User::find(10); $user->email = '[e-mail]';
But the email does not update in the database. Why?

A Because Tinker does not allow updating model attributes.

B Because the find method does not return a model instance.

C Because the email attribute is protected and cannot be changed.

D Because you forgot to call $user->save() after changing the email.

💡 Hint

Think about how Eloquent saves changes to the database.

Changing attributes on a model instance in Tinker does not save to the database until you call save().

❓ state_output

advanced

What is the output of this Tinker code?

Run this in Laravel Tinker:
$count = App\Models\Post::where('published', true)->count(); echo $count;
What does it output?

A A syntax error

B An array of posts

C The number of posts where 'published' is true

D true

💡 Hint

The count() method returns a number, not a boolean or array.

The count() method returns the total number of records matching the query.

🧠 Conceptual

expert

Which Tinker command will delete all users created before 2020 safely?

You want to delete all users created before 2020 using Laravel Tinker. Which command is the best to avoid accidental mass deletion?

A App\Models\User::where('created_at', '<', '2020-01-01')->delete();

B App\Models\User::all()->where('created_at', '<', '2020-01-01')->delete();

C App\Models\User::truncate();

D DB::table('users')->delete();

💡 Hint

Consider which method deletes only the targeted records safely.

Option A deletes only users created before 2020. Option A deletes all users. Option A tries to delete on a collection, which fails. Option A deletes all records in the table.