@php $data = DB::table('tb_case') ->join('patient','patient.id','tb_case.case_patientid') ->join('tb_procedure', 'tb_case.case_procedurecode', 'tb_procedure.procedure_code') ->where('case_id',$_GET['case_id']) ->first(); @endphp