LARAVEL INTERVIEW · Episode 04

Laravel: get() vs first()

Pick the one that matches what you expect back — many rows or one

Employee queries — get() vs first()

<?php
 public function getVsFirst()
    {
        // TODO (LEP 04): write the two queries
        $emailToFind = "madhyam@yopmail.com";
        $employee =  Employee::where('email' ,  $emailToFind)->first();

        $deptToSearch = "Engineering";
        $employees=Employee::where('department' , $deptToSearch)->get();

        return view('laravel.lep4_get_vs_first', [
            'VIDEO' => null , 'employee' => $employee, 'employees' => $employees
            ]);
    }
?>

Output

Find me the ageo off user whose email is madhyam@yopmail.com

Madhyam Sharma age 35

Give me list of users from Engineering dept

1 - Asha Rao

2 - Dillan Kuhic

3 - DAnny Lalwani

The Idea

Both run a query — the difference is what you expect back. Choose by the shape of the answer, not by habit.

Many rows expected → get(). One row expected → first().

get() — a Collection

Filtering by department can match lots of people, so get() returns a Collection of models — zero, one, or many. You loop over it. Even a single match still comes back inside a collection, so $engineers->name would not work.

first() — one model

Filtering by email (which is unique) should match one person, so first() returns a single model — or null if nothing matches. No loop: read $employee->name straight away.

Watch out

first() gives null when there’s no match — guard it before using, or use firstOrFail() to throw a 404. get() gives an empty collection (not null) — check with ->isEmpty(). Looking up by primary key? Employee::find($id) already returns one model.

Key takeaway: match the method to the expectation — many rows → get() (a Collection you loop), one row → first() (a single model, or null).

Interview notes: get() returns a Collection, first() a model or null, find($id) looks up by primary key, and firstOrFail() / findOrFail() throw a 404 when nothing is found. Add ->count() when you only need the number.

Watch the full episode

Watch on YouTube