How to update database with multiple condition?
My Table name is work
+----+-----+
| id | num |
+----+-----+
| 1 | 56 |
+----+-----+
| 2 | 44 |
+----+-----+
| 3 | 85 |
+----+-----+
if input values are id=1,num=17
the table should be updated like this
+----+-----+
| id | num |
+----+-----+
| 1 | 17 |
+----+-----+
| 2 | 44 |
+----+-----+
| 3 | 85 |
+----+-----+
or if values are id=4,num=56
updated table should be like below
+----+-----+
| id | num |
+----+-----+
| 1 | 17 |
+----+-----+
| 2 | 44 |
+----+-----+
| 3 | 85 |
+----+-----+
| 4 | 56 |
+----+-----+
is there any Eloquent in laravel to update the table if not please give me a solution
$update=DB::table('work')
->updateOrInsert(['id'=>$request->MasterId,'Agent_num' => '$request->num',],['id' =>$request->MasterId, 'Agent_num'=>$request->$request->num]);
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire