CODEWITHSUNDEEP
phplaraveleloquentlaravel-5.6
Andreas Hunter
Andreas Hunter

Reputation: 5004

Laravel eloquent mutators not work on update data

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:

enter image description here

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

enter image description here Why does not the information be stored in an encrypted form when updating information?

Upvotes: 10

Views: 9834

Answers (3)

S U
S U

Reputation: 11

Solution:

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

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

Upvotes: 1

m7o
m7o

Reputation: 921

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);

Upvotes: 11

train_fox
train_fox

Reputation: 1537

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);
}

Upvotes: 14

Related Questions