Laravel Eloquent - Get one Row

Question

This might be a simple question  but I cannot figure this out  I am trying to get a user by email using    user   User  whereEmail  email - gt get      But this is returning an array  of dimension 1  of  users  So If I want to get the name  I have to do  user 0   first name      I tried using limit 1  or take 1   or even using - gt toArray   but there was no difference   What am I doing wrong

User · Answer

You can do this too

Before you use this you must declare the DB facade in the controller Simply 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 = ?' , ['[email protected]']);

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.

User · Answer

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 - gt first      Example    user   User  where  email   email - gt first       OR    user   User  whereEmail  email - gt first

User · Answer

Try with it  color    App Color  take 1 - gt first

User · Answer

Laravel 5 2   sql    SELECT   FROM users WHERE email    email     user   collect  User  select  sql  - gt first      or   user   User  table  users  - gt where  email    email - gt pluck

User · Answer

laravel 5 8  If you don t even need an entire row  you may extract a single value from a record using the value   method  This method will return the value of the column directly    first name   DB  table  users  - gt where  email    me mail com  - gt value  first name      check docs

User · Answer

You can also use this   user   User  whereEmail  email - gt first

User · Answer

Simply use this    user   User  whereEmail  email - gt first

[laravel] Laravel Eloquent - Get one Row

Examples related to laravel

Examples related to eloquent