<?php error_reporting(0); include "../includes/config/config.php"; include "functions.php"; include 'log_entry.php'; header('Content-Type: application/json; charset=utf-8'); $arr = array(); $SQL = "SELECT c.patient_name,c.id FROM tbl_users a inner join role_master b on a.role_id = b.role_id INNER join patient_master c on a.emp_id = c.id WHERE b.role_code in ('DOC')"; $query = mysqli_query($conn,$SQL); $dm = array(); while ($fetch=mysqli_fetch_assoc($query)) { $arr[] = $fetch; } // array_push($dm, $arr['ailment_sys_name']); echo json_encode($arr , JSON_PRETTY_PRINT); ?>