Laravel Eloquent - Get one Row

laravel eloquent
Kousha picture Kousha · May 29, 2014 · Viewed 174.1k times · Source

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)->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 ->toArray() but there was no difference.

What am I doing wrong?

Answer

Ganesh Jogam picture Ganesh Jogam · May 29, 2014

Simply use this:

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

Related questions

How to Create Multiple Where Clause Query Using Laravel Eloquent?

I'm using the Laravel Eloquent query builder and I have a query where I want a WHERE clause on multiple conditions. It works, but it's not elegant. Example: $results = User::where('this', '=', 1) ->where('that', '=', 1) …

Read More
Get the Last Inserted Id Using Laravel Eloquent

I'm currently using the below code to insert data in a table: <?php public function saveDetailsCompany() { $post = Input::All(); $data = new Company; $data->nombre = $post['name']; $data->direccion = $post['address']; $data->telefono = $post['phone']; $data->…

Read More
Laravel Checking If a Record Exists

I am new to Laravel. Please excuse the newbie question but how do I find if a record exists? $user = User::where('email', '=', Input::get('email')); What can I do here to see if $user has a record?

Read More