How to update an entry in Laravel?

Question

Laravel

There is such a plate

Model:

class Result extends Eloquent
{
    protected $table = 'assets_to_users';
    protected $fillable = ['user_id', 'result'];

   public function asset()
   {
       return $this->hasOne('Application\Models\Asset', 'id', 'asset_id');
   }
}

And this code:

$asset_id = 2;

Result::updateOrCreate(
                ['asset_id' => $asset_id],
                ['result' => 100]
            );

After that, the plate takes the following form:

While

$model = Result::where('asset_id', '=', $asset_id)->first();
echo $model->id; //122

Why is the wrong row being updated?

Answer 1

You misunderstand the purpose of the updateOrCreate function.
In your case, you need to get an instance of the Result object, and then make changes to it.

$model = Result::where('asset_id', '=', $asset_id)->first();
$model->result = 100;
$model->save();

Answer 2

You have $fillable = ['user_id', 'result'] allowed to change or add user_id, and you are trying to access asset_id.