0) { while ($row = mysqli_fetch_assoc($result)) { // $data[$x] = $row; //$data[]=$row; //$x++; //$data[$x]=$row; $parameter_name=getTableFieldValue('hygiene','hygiene_parameter','hygiene_id',$row['hyg_parameter_id']); $data[$x]['parameter_name']=$parameter_name; $data[$x]['hyg_parameter_val']=$row['hyg_param_val']; $data[$x]['checkup_date']=date_format(date_create($row['checkup_date']),"d-M-Y"); $x++; } } else { $data['status'] = 200; $data['message'] = "Data not found!"; } echo json_encode($data); ?>