Laravel - Convert database integer to an associated string

Question

I have my users table with a column named status. In this column I just store a number, based off their status, 1 - admin, 2 - owner, etc. I know that I can display these values with {{ users->status }}, but only shows the stored number. How can I show the actual name instead of the stored number?

Brian Dillingham · Accepted Answer · 2014-10-05 04:25:11Z

4

Use Eloquent Accessors & Mutators.

Define an array of statuses and use the status number from your database as a key to change the value in the model so that in the view {{ $users->status }} equals admin

class User extends Eloquent {

    protected $statuses = array(
        '1' => 'admin',
        '2' => 'owner'
    );

    public function getStatusAttribute($value)
    {
        return $this->statuses[$value];
    }

}

getStatusAttribute converts 1 to admin when retrieving a record.

You could also have a set method for when records are stored in the model.

In View {{ $user->status }} // echos 'admin'

edited Oct 5, 2014 at 4:25

answered Sep 29, 2014 at 18:13

Brian Dillingham

9,3763 gold badges30 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

Laravel - Convert database integer to an associated string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related