How to use variables as attribute name in Laravel Eloquent

Question

Is there anyway to use variables in eloquent Example:

public function showLessons($skill)
    {
        $user = (\App\User::where('id', Auth::user()->getId())->first());
        $type = $user->type;
        if ($type === "student") {
            $bs = ($user->student_bronze_ . $skill);
            $ss = ($user->student_silver_ . $skill);
            $gs = ($user->student_gold_ . $skill);
        } elseif ($type === "school") {
            $bs = ($user->school_bronze_ . $skill);
            $ss = ($user->school_silver_ . $skill);
            $gs = ($user->school_gold_ . $skill);
        };
        return view('pages.lessons', compact("bs", "ss", "gs"));
    }

I am trying to check if the user's level is the same or higher than the lesson's id

wschopohl · Accepted Answer · 2020-07-24 15:43:09Z

4

I think your main question here is: Can you use a variable as attribute name on a laravel Eloquent model.

The answer is yes, you wrap it in curly braces {}

$user->{$type.'_'.$medal.'_'.$skill};

If you move some of your code to the User Model your controller get's a bit tidier.

// User.php
public function skill($medal, $skill) {
    $type = $this->type;    
    return $this->{$type.'_'.$medal.'_'.$skill};
}

then your Controller becomes cleaner:

public function showLessons($skill)
{
    $user = Auth::user();
    
    $bs = $user->skill('bronze', $skill);
    $ss = $user->skill('silver', $skill);
    $gs = $user->skill('gold', $skill);
    
    return view('pages.lessons', compact("bs", "ss", "gs"));
}

edited Jul 24, 2020 at 15:43

answered Jul 24, 2020 at 14:52

wschopohl

1,7721 gold badge12 silver badges18 bronze badges

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

1 Comment

wschopohl Over a year ago

actually I just gave my answer a review. The code could still be optimized a bit, look at updated version :)

Collectives™ on Stack Overflow

How to use variables as attribute name in Laravel Eloquent

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related