Laravel return null for existing value in model

Question

after getting query from database in Controller i have this output:

$newTickets = Ticket::with('user')->whereStatus(0)->orderBy('id', 'desc')->take(5)->get();

dd($newTickets[0]->user);

output:

#attributes: array:18 [▼
    "id" => 1
    "active" => 1
    "name" => "user1"
    "family" => "user1111"
    "username" => "xxxxx"
    "avatar" => "user_bg3.jpg"
    "email" => "[email protected]"
    "email_verified_at" => null
    "user_id" => null
    "properties_id" => null
    "password" => "$2y$10$b50fMYQMfMyJgtgCDEfQyueu.C.VfhfQCXT/f2Y8ObAe4nMrNiXEe"
    "mobile_number" => "333333"
    "device_id" => "0123456789"
    "api_token" => "aaaaaaa"
    "remember_token" => null
    "deleted_at" => null
    "created_at" => "2020-06-02 13:13:15"
    "updated_at" => "2020-06-02 13:13:15"
]

now when i try to show avatar field value, i'm getting null :|

dd($newTickets[0]->user->avatar);

output:

null

whats problem and why i can't get this value and that return null?

i can get another values and my problem is only getting avatar value

User model:

class User extends Authenticatable
{
    use Notifiable, SoftDeletes;

    protected $guarded = [
        'id',
    ];
    protected $hidden = [
        'password', 'remember_token',
    ];

    protected $casts = [
        'email_verified_at' => 'datetime',
        'avatar' => 'array',
    ];

    public function group()
    {
        return $this->belongsToMany(UserGroup::class, 'user_user_group');
    }

    public function child()
    {
        return $this->hasMany(User::class)->with('child');
    }

    public function parent()
    {
        return $this->belongsTo(User::class, 'user_id');
    }

    public function blogs()
    {
        return $this->hasMany(UserBlog::class);
    }

    public function setPasswordAttribute($password)
    {
        $this->attributes['password'] = Hash::make($password);
    }

    public function getFullNameAttribute()
    {
        return $this->name.' '.$this->family;
    }
}

you sure you don't have get attribute for avatar? or any cast? — OMR
– OMR, Commented Jun 3, 2020 at 19:22
Do you have any relation, accessor or mutator with the name of avatar in your user model? — Milad Teimouri
– Milad Teimouri, Commented Jun 3, 2020 at 19:22

OMR · Accepted Answer · 2020-06-03 19:39:12Z

1

you are casting avatar to an array ... when you do this ... laravel automatically decode 'avatar' from json for output and encode it for input ... more details

just remove avatar from :

  protected $casts = [
        'email_verified_at' => 'datetime',
        'avatar' => 'array',
    ];

answered Jun 3, 2020 at 19:39

OMR

12.3k5 gold badges26 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Laravel return null for existing value in model

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related