Laravel SQL select and update model

Question

I try select from database and update values with model, but get error:

Call to undefined method stdClass::save()

My code:

$user = db::table('users')->where('name', 'John')->where('age', 30)->first();
if($user) {
    $user->name = 'Tom';
    $user->age = 31;
    $user->save();
}

i get this error:

i think db should be DB

Rakesh Sharma
– Rakesh Sharma

2015-02-09 13:25:05 +00:00
Commented Feb 9, 2015 at 13:25 — Rakesh Sharma
– Rakesh Sharma, Commented Feb 9, 2015 at 13:25

lukasgeiter · Accepted Answer · 2015-02-09 13:25:17Z

5

If you want to use save() you have to build the query using an actual model. Currently you're just selecting something from the db without hydrating a model.

$user = User::where('name', 'John')->where('age', 30)->first();
if($user) {
    $user->name = 'Tom';
    $user->age = 31;
    $user->save();
}

answered Feb 9, 2015 at 13:25

lukasgeiter

154k29 gold badges349 silver badges280 bronze badges

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

Collectives™ on Stack Overflow

Laravel SQL select and update 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