Laravel Eloquent - Get one Row

laravel eloquent

Simply use this:

$user = User::whereEmail($email)->first();

laravel eloquent

You can do this too

Before you use this you must declare the DB facade in the controllerSimply put this line for that

use Illuminate\Support\Facades\DB;

Now you can get a row using this

$getUserByEmail = DB::table('users')->where('email', $email)->first();

or by this too

$getUserByEmail = DB::select('SELECT * FROM users WHERE email = ?' , ['useremailaddress@email.com']);

This one returns an array with only one item in it and while the first one returns an object. Keep that in mind.

Hope this helps.

laravel eloquent

Using Laravel Eloquent you can get one row using first() method,

it returns first row of table if where() condition is not found otherwise it gives the first matched row of given criteria.

Syntax:

Model::where('fieldname',$value)->first();

Example:

$user = User::where('email',$email)->first(); //OR//$user = User::whereEmail($email)->first();

CodeHunter