Laravel eloquent mutators not work on update data

Question

I have in my model accessors and mutators for hash/rehash data in database table fields. For example:

public function setFullNameAttribute($value)
{
    $this->attributes['full_name'] = Helper::geted('encrypt', $value);
}

public function getFullNameAttribute($value)
{
    return Helper::geted('decrypt', $value);
}

When I'll save data to database all sending datas saving in hashed form but on update data not hashed. My save/update code:

$profile = [
    'full_name' => "John",
    'address' => "United Kingdom"
];

$profile_save = new Profile($profile);
$exist = Personal::where('user_id', Auth::id())->count();
if($exist == 0) $user->profile()->save($profile_save);
if($exist == 1) $user->profile()->update($profile);

When I first time save this info to db:

When I second time enter to current URL data will be updated:

Why does not the information be stored in an encrypted form when updating information?

dd($profile); (prior to update) - is the posted data encrypted at that point? — Squiggs., Jun 29 '18 at 07:30
I updated my question. You can see detailed info on pictures. — Andreas Hunter, Jun 29 '18 at 07:36
`updateOrCreate()` looks like a better choice for your situation. — Jonas Staudenmeir, Jun 29 '18 at 08:01
`updateOrCreate()` save duplicate rows on refresh page or on enter to current testing url. @JonasStaudenmeir — Andreas Hunter, Jun 29 '18 at 08:30

train_fox · Accepted Answer · 2018-06-29T07:51:54.997

14

Your problem is in this line:

$user->profile()->update($profile);

Mutators and accessors work on eloquent and not on Query Builders. You are using update function which is a query builder function, so you are updating your database directly. Use this:

$profile = [
    'full_name' => "John",
    'address' => "United Kingdom"
];
$profile = auth()->user()->profile;
if ($profile) {
    $profile->full_name = $profile['full_name'];
    $profile->address = $profile['address'];
    $profile->save();
} else {
    auth()->user()->profile()->create($profile);
}

edited Jun 29 '18 at 07:51

answered Jun 29 '18 at 07:45

train_fox

1,517
1
12
31

How I can update then user profile without query builders? – Andreas Hunter Jun 29 '18 at 07:46

score 9 · Answer 2 · answered Jan 24 '20 at 15:18

9

For anybody who has the same problem:

Just omitting the parantheses also does the trick, as this uses Eloquent instead of the Query Builder:

$user->profile->update($profile);

answered Jan 24 '20 at 15:18

m7o

901
5
7

score 1 · Answer 3 · edited Jun 21 '21 at 19:48

1

Solution:

$instance->fill($request->all());
$instance->save();

dont work $instance->update($request->all());

edited Jun 21 '21 at 19:48

Prospero

2,190
2
4
18

answered Jun 21 '21 at 12:24

S U

11
1

Laravel eloquent mutators not work on update data

3 Answers3

Linked