how to update data into table using in laravel

Question

I want to update data into table if the record exits if not then create a new record.

if(!empty($request->meta_title)){
    $meta = new \stdclass();
    $meta = VendorMeta::firstOrNew(['vendor_id' => $id]);
    $meta->meta_title = $data['meta_title'];
    $meta->meta_desc = $data['meta_desc'];
    $meta->meta_keyword = $data['meta_keyword'];
    $meta->save();    
}

But I am getting this error:

MassAssignmentException in Model.php line 445:vendor_id

First check meta_title available in your table and then decide.. — Komal
– Komal, Commented Nov 14, 2016 at 10:17

Amit Gupta · Accepted Answer · 2016-11-14 10:03:16Z

2

You should define which model attributes you want to make mass assignable, so in your VendorMeta class add following code:

protected $fillable = ['vendor_id'];

answered Nov 14, 2016 at 10:03

Amit Gupta

17.7k5 gold badges46 silver badges54 bronze badges

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

1 Comment

Amit Gupta Over a year ago

If you find this answer correct, then mark this as accepted answer as it motivates me to answer more questions like this :D , and help others to get appropriate answers quickly.

Thomas De Marez · Accepted Answer · 2016-11-14 10:04:47Z

1

You need to set the $fillable property on your model.

Take a look at the docs under Mass Assignment.

/**
 * The attributes that are mass assignable.
 *
 * @var array
 */
protected $fillable = ['meta_title', 'meta_desc', 'meta_keyword'];

answered Nov 14, 2016 at 10:04

Thomas De Marez

6668 silver badges24 bronze badges

Collectives™ on Stack Overflow

how to update data into table using in laravel

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related