"; } if ($hasWriteAccess) { $edit_link = ""; } if ($hasExecuteAccess) { $delete_link = ""; } $space = "   "; $links = $view_link . $space . $edit_link . $space . $delete_link; $designation = getFieldFromTable('designation_name', 'designation', 'designation_id', $row1['designation']); $village = getFieldFromTable('village', 'village', 'id', $row1['village']); $tehsil_id = getFieldFromTable('tehsil', 'village', 'id', $row1['village']); $tehsil_name = getFieldFromTable('name','tehsils','id',$tehsil_id); $date = date_format(date_create($row1['date_of_screening']), "d-m-Y"); // $center = getCommaSeperatedValuesForInClause("select ohc_type_name from ohc_type", "ohc_type_id", $row1['ohc_type_id']); $data['rows'][] = array( 'id' => $row1['id'], 'cell' => array($links, $count++, $date,$row1['patient_name'], $row1['mobile_no'],$row1['history_book_no'],$row1['findings'], $village) ); } // Adding export options as a hidden row $data['rows'][] = array( 'id' => 'filterkey', 'cell' => array('', "", "", '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '') ); echo json_encode($data);