How to update data in laravel 5.8

Question

i have tried to update data of my database, but there is no error this my method

public function update_pj_si(request $request)
{
    $id = $request->id;
    DB::table('tbl_profil_penyedia')
        ->where('id_profil_penyedia', $id)
        ->update(array('status' => 1));
    return redirect('/verif/pj_si');
}

if i run this method, it run correctly and no error but the database is not updated. how can i fix this?

For one, (request $request) should be (Request $request).. But you say you did not get an error.. that's strange. Is that a typo? — user3532758
– user3532758, Commented Nov 21, 2019 at 8:49
that means the where condition of the query didn't yield any results to update ... the update call should return an integer of the number of records that were affected — lagbox
– lagbox, Commented Nov 21, 2019 at 8:49
May be you required this code in your model protected $fillable = ['status'] — TsaiKoga
– TsaiKoga, Commented Nov 21, 2019 at 9:04
yap, there is no error if i run the method, but the data is no update and i have tried to change (request $request) to (Request $request) but the result still same — Muqsith Arsyad
– Muqsith Arsyad, Commented Nov 21, 2019 at 9:08
@MuqsithArsyad try to dd(DB::table('tbl_profil_penyedia') ->where('id_profil_penyedia', $id) ->update(array('status' => 1));), if the return is 1, means updated success, if not, means updated failed. And if it is 0 — TsaiKoga
– TsaiKoga, Commented Nov 21, 2019 at 9:13

lagbox · Accepted Answer · 2019-11-21 09:33:05Z

4

The $id variable doesn't contain a value that exists in your table, tbl_profil_penyedia, for the field id_profil_penyedia. It is as simple as that.

You are trying to update a profil_penyedia that doesn't exist.

The update call returning 0, means it didn't update any rows, which means your where condition didn't yield any results to be updated.

answered Nov 21, 2019 at 9:33

lagbox

50.7k8 gold badges76 silver badges85 bronze badges

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

1 Comment

Muqsith Arsyad Over a year ago

thankyou sir.. before, i have tried input tag table in tag form. so $id cant call and returning 0. after i delete tag table it works. and i want ask again sir.. can the table tag be in the form tag?

Collectives™ on Stack Overflow

How to update data in laravel 5.8

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related