Laravel get record from database in blade view

Question

I would like to known how to get data from database in blade like from User table:

{{ Auth::user()->name }}

I have table user_settings

I would like to get record from this table by logged user id like this:

{{ UserSettings::user()->my_field }}

How can I do that?

return view("your view", ["userSettings" =>UserSettings::user()]); now $userSettigs is available in your view — jgetner
– jgetner, Commented Aug 17, 2017 at 16:10
DO not make database calls from your view layer, pass the data from the controller — Steve
– Steve, Commented Aug 17, 2017 at 16:15
Yes, but I must get one field in my header panel? When this panel are inclued in layout. — lukassz
– lukassz, Commented Aug 17, 2017 at 21:34

Sagar Gautam · Accepted Answer · 2017-08-17 16:24:53Z

3

Try this on your blade view

{{ \App\UserSettings::where('user_id',Auth::user()->id)->first()->my_field }}

In default, model file is inside App folder.

Such direct access to database table is not preferred though, you can return this as a variable from controller function like,

$field = \App\UserSettings::where('user_id',Auth::user()->id)->first()->my_field;  
return view('view_name',comapact('field'));

and use in blade like

{{$field}}

Another good way is posted by Orkhan in another answer using eloquent relationship. Hope you understand.

edited Aug 17, 2017 at 16:24

answered Aug 17, 2017 at 16:05

Sagar Gautam

9,4099 gold badges62 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

lukassz Over a year ago

Yes, but in my UserSettings model I don't have user() function and I gets Call to undefined method Illuminate\Database\Query\Builder::user()

Sagar Gautam Over a year ago

Did you have user_id on user setting table ?

lukassz Over a year ago

Yes I have this field

Sagar Gautam Over a year ago

@lukassz So please close the question by accepting it

Orkhan Alikhanov · Accepted Answer · 2017-08-17 16:15:55Z

2

You need to retrieve the UserSettings associated to the authenticated user:

UserSettings::where('user_id', Auth::id())->first()->my_field

You can defined a method named current() to return that for you.

class UserSettings extends Model
{
    public static function current()
    {
        return UserSettings::where('user_id', Auth::id())->first()
    }
}

Then use:

UserSettings::current()

On the other had it would better to use one-to-one relationship on user model:

class User extends Model
{
    public function settings()
    {
        return $this->hasOne('App\UserSettings');
    }
}

Then use:

Auth::user()->settings->my_field

edited Aug 17, 2017 at 16:15

answered Aug 17, 2017 at 16:09

Orkhan Alikhanov

10.2k4 gold badges50 silver badges66 bronze badges

Collectives™ on Stack Overflow

Laravel get record from database in blade view

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related