Convert database integer to an associated string in Laravel?

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? And I don't use model here.

Rouhollah Mazarei · Accepted Answer · 2022-04-12 08:55:13Z

1

You can define an accessor in your User model:

public function getStatusStringAttribute()
{
    switch ($this->status) {
        case 1:
            return "Admin";
            break;
        case 2:
            return "Owner";
            break;
    }
}

and get this attribute like this:

{{ $user->statusString }}

answered Apr 12, 2022 at 8:55

Rouhollah Mazarei

4,1631 gold badge18 silver badges20 bronze badges

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

Comments

knubbe · Accepted Answer · 2022-04-12 08:54:24Z

0

You can use something like enum casting. Please take a look and see if this works for you ;)

answered Apr 12, 2022 at 8:54

knubbe

1,2022 gold badges13 silver badges24 bronze badges

Comments

score 0 · Accepted Answer · 2022-04-12 09:09:07Z

0

You should create a table with user's name role and then join 2 tables. For example: You have 1 table named users with column status. You need to create a table for example user_status_name. id 1 -- name admin, id 2 -- name user

<?php
$users = User::join('user_status_name', 'user_status_name.id', '=', 'users.status')->pluck('name');
?>

edited Apr 12, 2022 at 9:09

answered Apr 12, 2022 at 8:58

user18765142

Collectives™ on Stack Overflow

Convert database integer to an associated string in Laravel?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related