CODEWITHSUNDEEP
phpmysqllaravellaravel-4
Brandon
Brandon

Reputation: 1081

Find User in Laravel by Username

So typically if you have access to the id of a user in laravel you can run User::find($id), however say you don't have access to the user's id and only their username. Is there a better way than using DB::query to locate the user?

This is my current solution and was wondering if someone possibly knew a better way.

$user_id = DB::table('users')->where('username', $user_input)->first()->id;

Upvotes: 31

Views: 93417

Answers (3)

Hamidreza Bayat
Hamidreza Bayat

Reputation: 103

It depends. If a user is logged in you can have any information you want by:

$field = Auth::user()->field;

But if they are not logged in and you just want their user_id you can use:

$user_id = User::select('id')->where('username', $username)->first();

Upvotes: 6

mdamia
mdamia

Reputation: 4557

Yes, even better using the model. just like this 

User::where('username','John') -> first();
// or use like 
User::where('username','like','%John%') -> first();
User::where('username','like','%John') -> first();
User::where('username','like','Jo%') -> first();

Upvotes: 68

Angel M.
Angel M.

Reputation: 2742

$user_id = DB::table('users')->where('username', $user_input)->first();

without "->id"

check here: http://laravel.com/docs/5.0/queries

Upvotes: 2

Related Questions