@csrf

Project Details

@if(request()->isMethod('post')) @php $id = request('id'); $projectcode = request('project'); $ProjDate = request('ProjDate'); $hours = request('hours'); $minutes = request('minutes'); $noOfHrs = sprintf('%02d', $hours) . ":" . sprintf('%02d', $minutes); $remarks = request('remarks'); $status = request('status'); $empl_cd = Auth::user()->userid; $locn_cd = Auth::user()->proloc; $query = "UPDATE proj_mgmt SET locn_cd = '" . $locn_cd . "',empl_cd = '" . $empl_cd . "' ,project = '" . $projectcode . "',date = '" . $ProjDate . "' ,noofhrs = '" . $noOfHrs . "',remarks = '" . $remarks . "',status = '$status' ,last_changed_by = '" . $empl_cd . "',last_changed_date = '" . date("Y-m-d h:i:s") ."' WHERE empl_cd = '" . $empl_cd . "' and id = '$id'"; //echo $query;die(); $result = DB::UPDATE($query); if($result) { header('Location: Proj_management'); exit(); } @endphp @endif