Fetch Single Row Data from Database in Laravel

To get or fetch single or specific row data from the database in laravel; Through this tutorial, you will learn how to get or fetch single row data from database in laravel.

And as well as learn how to get single record or data from the mysql database in laravel by id, email, etc.

How to Fetch Specific Or Single Row Data from Database in Laravel

Using the following laravel eloquent methods, you can get or fetch single or specific row data from database in laravel:

• Using Laravel find()
• Using Laravel firstWhere()
• Using laravel where() and first()

Using Laravel find()

You can use the laravel find() method to get one row or single row data from database; as shown below with example:

public function index()
{
    $userID = 1;
    $user = User::find($userID);
    
    dd($user);
}

Using Laravel firstWhere()

You can use the laravel firstWhere() method to get one row or single row data from database; as shown below with example:

public function index()
{
    $email = '[email protected]';
    $user = User::firstWhere('email', $email);
  
    dd($user);
}

Using laravel where() and first()

You can use the laravel where() and first() method to get one row or single row data from database; as shown below with example:

public function index()
{
    $email = '[email protected]';
    $user = User::where('email', $email)->first();
  
    dd($user);
}

Recommended Laravel Tutorials