18 lines
579 B
PHP
18 lines
579 B
PHP
<?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);
|
|
?>
|