Call to undefined method stdClass::save()

Question

I'm trying to save into the database but I constantly get this error

Call to undefined method stdClass::save()

my controller

 $c = DB::table('subject_user')->where('user_id', $value)->first();

 $c->auth_teacher = '1';

 $c->save();

Solution 1

Try this approach

I haven't try save method with where condition. Hopefully, this approach may solve your problem.

 DB::table('subject_user')->where('user_id', $value)->update(['auth_teacher' => 1]);

Solution 2

I just ran into the same problem and figured out the real Laravel answer.

The answer you've accepted here (https://stackoverflow.com/a/41051946/470749) doesn't follow the truest Laravel way.

When I re-read the docs at https://laravel.com/docs/5.4/eloquent#retrieving-models, I noticed that ->save() will work only if the way that I retrieved the object(s) was via the model like this:

$flights = App\Flight::where('active', 1)
           ->orderBy('name', 'desc')
           ->take(10)
           ->get();

There is no need to use DB::table() anywhere, and using it doesn't seem to be the recommended way.

So, you could change DB::table('subject_user')->where to App\Subject_user::where (or whatever is appropriate for you).

Solution 3

DB::table('subject_user')->where('user_id', $value)->update(['auth_teacher' => 1]);

I have been able to succeed with this.

Solution 4

In case you started using DB:: instead of Model:: because you needed dynamic table name call, it is possible to use dynamic interface call instead, but I wonder if it is a good practice, anybody willing to explain if the following is wrong (since it works fine):

$model = 'User'; //Use the name of the model, not the table name
$interface_model = '\App\Models\\' . $model; //Needed to avoid the manual import of each model
$entry = $interface_model::where('id', $id)->first();
//$entry now support save()

View more solutions

Comments

[Conan]

this is the more appropriate answer.

[patrickdamery]

You don't seem to be able to use pessimistic locks with Eloquent models. If you need to prevent race conditions DB::table() is a must.

[Ryan]

This was also helpful for me: stackoverflow.com/a/29166530/470749