Fetch Single Row Data from Database in Laravel

Fetch Single Row Data from Database in Laravel

To get or fetch single 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 mysql database in laravel by id, email, etc.

How to Fetch Single Row Data from Database in Laravel

Use the following laravel eloquent methods to get or fetch single 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

Recommended:-Laravel Try Catch

AuthorAdmin

My name is Devendra Dode. I am a full-stack developer, entrepreneur, and owner of Tutsmake.com. I like writing tutorials and tips that can help other developers. I share tutorials of PHP, Python, Javascript, JQuery, Laravel, Livewire, Codeigniter, Node JS, Express JS, Vue JS, Angular JS, React Js, MySQL, MongoDB, REST APIs, Windows, Xampp, Linux, Ubuntu, Amazon AWS, Composer, SEO, WordPress, SSL and Bootstrap from a starting stage. As well as demo example.

Leave a Reply

Your email address will not be published. Required fields are marked *