Update records of database table : Laravel

Question

I need to update the database table according to the edited data.

controller

public function update(Request $request)
{
    $subscriptionplan = SubscriptionPlan::find($request->id);
    $subscriptionplan->update($request->all());        
    return back();        
}

But nothing happens when I submit the form. When I use dd($request->all()); at the beginning of the function, it correctly shows the edited data as follows.

array:10 [▼
  "_method" => "patch"
  "_token" => "gOCL4dK6TfIgs75wV87RdHpFZkD7rBpaJBxJbLHF"
  "editname" => "SUP_EVA_001"
  "editdesc" => "des"
  "editprice" => "1000.050"
  "editlimit" => "1"
  "editperunit" => "20.000"
  "editexceedunit" => "30.000"
  "productid" => "1"
  "id" => "1"
]

But database has not been updated.

My table name is Table: subscription_plans and model is SubscriptionPlan

These are the table columns:

protected $fillable = [
        'name',
        'description',
        'price',
        'usage_limit',
        'charge_per_unit',
        'charge_per_unit_exceed',
        'is_limit_exceed_considered',
        'product_id'
    ];

Any idea on how to solve it or what I have done wrong?

Are any errors being pushed to you storage/log/laravel.log file? — thisiskelvin
– thisiskelvin, Commented Oct 18, 2018 at 8:13

MONSTEEEER · Accepted Answer · 2018-10-18 08:11:32Z

1

If your solution did not work, try the 1by1 like this.

public function update(Request $request)
{
    $subscriptionplan = SubscriptionPlan::find($request->id);
    $subscriptionplan->_method = $request->_method;
    $subscriptionplan->_token = $request->_token;
    $subscriptionplan->editname = $request->editname;
    $subscriptionplan->editdesc = $request->editdesc;
    $subscriptionplan->editprice = $request->editprice;
    $subscriptionplan->editlimit = $request->editlimit;
    $subscriptionplan->editperunit = $request->editperunit;
    $subscriptionplan->editexceedunit = $request->editexceedunit;
    $subscriptionplan->productid = $request->productid;
    $subscriptionplan->save();        
    return back();        
}

answered Oct 18, 2018 at 8:11

MONSTEEEER

5707 silver badges23 bronze badges

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

Comments

thchp · Accepted Answer · 2018-10-18 08:52:36Z

0

In order for Laravel to automatically fill the model attributes, the indexes of the array passed to the fill method must correspond to your model attributes names.

Also, instead of

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

Use

$subscriptionplan->fill($request->all());

Then save the subscription plan with $subscriptionplan->save();

edited Oct 18, 2018 at 8:52

answered Oct 18, 2018 at 8:10

thchp

2,4741 gold badge22 silver badges36 bronze badges

7 Comments

shavindip Over a year ago

Still database is not updating.

thchp Over a year ago

The attributes may be guarded, add attributes that need to change into a fillable array attributes. (doc about this: laravel.com/docs/5.7/eloquent#mass-assignment)

shavindip Over a year ago

the model use "protected $fillable" method

thchp Over a year ago

The array indexes in $request->all() array should be the same as the model attributes. editname should be name, and so on

shavindip Over a year ago

I think I have got it wrong there. I updated my question with the table columns.

|

Collectives™ on Stack Overflow

Update records of database table : Laravel

2 Answers 2

Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related