Update Table Using Laravel Model

Question

I've got a table for a sports team. The record shows the team selection and some other information. I want to update the record with the team selection. My model is thus:

class Selection extends Model {

protected $table = "selection";

protected $fillable = [
    'loose',
    'hooker',
    'tight',
    'secrow1',
    'secrow2',
    'blindflank',
    'openflank',
    'eight',
    'scrum',
    'fly',
    'leftwing',
    'rightwing',
    'fullback',
    'sub1',
    'sub2',
    'sub3',
    'sub4',
    'sub5'
];

}

So I have a form which gives all the data for the positions and gives the id for the record in the DB. In my controller, I've got:

public function storeFirstTeam()
{
    $input = Request::all();

    Selection::update($input->id,$input);

    return redirect('first-team');
}

But I get the following error:

Non-static method Illuminate\Database\Eloquent\Model::update() should not be called statically, assuming $this from incompatible context

Can anyone point out my silly error?

You have to first select the row you want to update. How would you get the id of the selection when you post the update request? — Jilson Thomas
– Jilson Thomas, Commented Feb 8, 2016 at 21:47
Try Something like this: Selection::whereId($id)->update($request->except(['_method','_token'])); — Jilson Thomas
– Jilson Thomas, Commented Feb 8, 2016 at 21:50

Prashant Barve · Accepted Answer · 2018-07-12 11:38:46Z

71

Please check the code below and this would solve your problem:

Selection::whereId($id)->update($request->all());

edited Jul 12, 2018 at 11:38

Prashant Barve

4,3352 gold badges38 silver badges44 bronze badges

answered Feb 8, 2016 at 21:52

Jilson Thomas

7,31329 silver badges31 bronze badges

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

2 Comments

Jonatan Lavado Over a year ago

Does this method update() get rollBackif something goes wrong? If it's between a DB::beginTransaction()

CodeToLife Over a year ago

The request can contain some custom fields, from form e.g. I put array like this:

Foydabaranda::whereId($request->id_eslox)->update([                    'login' => $request->login_eslox,                    'parol' => $request->parol_eslox,                    'tuKiTu' => $request->xeli_tochka,                ]);

Also works as I wanted.

Martin Bean · Accepted Answer · 2016-02-08 21:51:02Z

15

The error message tells you everything you know: you’re trying to call a method statically (using the double colons) that isn’t meant to be.

The update() method is meant to be called on a model instance, so first you need to retrieve one:

$selection = Selection::find($id);

You can then can the update() method on that:

$selection->update($request->all());

answered Feb 8, 2016 at 21:51

Martin Bean

39.6k28 gold badges134 silver badges207 bronze badges

Comments

The Alpha · Accepted Answer · 2016-02-08 21:50:49Z

8

You should write it like given example below:

Selection::where('id', $input['id'])->update($input);
// Or use this using dynamic where
Selection::whereId($input['id'])->update($input);

Alternatively, you may write it like this as well:

Selection::find($input['id'])->fill($input)->save();

answered Feb 8, 2016 at 21:50

The Alpha

147k30 gold badges294 silver badges313 bronze badges

Comments

Kaviyarasan Shanmugam · Accepted Answer · 2022-07-06 09:02:32Z

3

You can also simply update the fields manually:

Selection::whereId($id)->update($request->all());

edited Jul 6, 2022 at 9:02

answered Aug 25, 2021 at 4:20

Kaviyarasan Shanmugam

252 bronze badges

1 Comment

happymacarts Over a year ago

Please avoid code only responses. view stackoverflow.com/help/how-to-answer for more information

Alp Altunel · Accepted Answer · 2023-02-08 11:33:59Z

1

it is possible to update with primary key but in my case I dont have id field in the detail table. To do it just run a query like this:

DB::table("shop_menu_detail")
    ->where(['name' => 'old name', 'language' => 'english'])
    ->update(['name' => 'new name']);

where is used as it is.

answered Feb 8, 2023 at 11:33

Alp Altunel

3,4521 gold badge28 silver badges30 bronze badges

Collectives™ on Stack Overflow

Update Table Using Laravel Model

5 Answers 5

2 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related