Build query for multiple row update with a single query

multiupdate.php

    public function buildUpdateQuery($table, $update)
    {
        $qr = "update ".$table." set ";
        $cases = []; 
        $ids = [];
        foreach ($update as $key => $val) {
            $ids[] = $val['id'];
            foreach ($val['data'] as $k => $v) {
                $cases[$k][] =  "when ".$val['id']." then '".$v."'";
            }
        }

        foreach ($cases as $k => $vl) {
            if(collect($cases)->keys()->last() == $k){
                $qr .= $k.' = case id '.implode(" ",$vl).' end ';
            }else{
                $qr .= $k.' = case id '.implode(" ",$vl).' end ,';
            }
        }
        $qr .= " where id in (".implode(', ',$ids).")";

        DB::statement($qr);

        return 'success';

    }