What is the best way to write an update query if there is multiple choice selection for the data to be updated?

basically you already are there, this is issue of your front end - form setup so lets say if you have check boxes as options for a, b, c, and d

$cat = DB::table('tesing')
                ->where('id', $id)               
                ->update($data);

And you will get data from your forms post data so lets say if checkbox a is selected you will have value of a in data array.

Same thing will be with text fields, changed fields will have new value and unchanged fields old value and app will perform update based on that data.

i hope this short explanation is clear ?

@hajrovica Sorry, i don't get it. The value from front end not to be stored, just to determine which column will be updated. After that i will only update accordingly.

For example, there is a remarks and quantity column. When user select only remarks will be updated, then i will perform a select query to get data from another table and update the quantity it.

Maybe something like

$data = [];
$fields = ['a', 'b', 'c', 'd'];
foreach ($fields as $field) {
    if ($request->has($field)) {
        $data[$field] = $request->$field;
    }
}

$cat = DB::table('tesing')
                    ->where('id', $id)               
                    ->update($data);

@Cronix Anyhow i still need to use if-else statement to control the value to be updated right? Because the value i want to update not from the $request->$field. It is something like

foreach ($testing as $test) {
$cat = DB::table('testing')
->where('id', $id)
->update(['remarks' => $test->remarks,'quantity'=>$test->quantity]);
            }
        }

For example.

foreach ($testing as $test) {
 $data = [];
 $fields = ['remarks', 'quantity'];
 foreach ($fields as $field) {
 if ($request->has($field) =='remarks') {
      $data[$field] = $test->remarks;
                    }
 if ($request->has($field) =='quantity') {
      $data[$field] = $test->quantity;
                    }
                }
$cat = DB::table('testing')
->where('id', $id)
->update($data);
            }
        }
 

Thanks.

as you have noted, just pass through an array of items to be updated and don't mention the columns that are to stay the same.

@Snapey mean that the only way to achieve is doing if-else statement to check for which column will be updated right? Correct me if i am wrong.

If you pass through $request->all() then only fields that are sent in will be updated.

$cat = DB::table('testing')
->where('id', $id)
->update($request->all());

but, bear in mind that fields that are present, but null will be cleared in the database