33 lines
920 B
PHP
33 lines
920 B
PHP
|
<?php
|
||
|
|
include('includes/config/config.php');
|
||
|
|
include('includes/functions.php');
|
||
|
|
error_reporting(E_ERROR | E_PARSE);
|
||
|
|
|
||
|
|
|
||
|
|
$emp_id = $_REQUEST['empId'];
|
||
|
|
$section_id = $_REQUEST['sectionId'];
|
||
|
|
$checkup_id = $_REQUEST['checkupId'];
|
||
|
|
|
||
|
|
$sql = "SELECT * FROM checkup_section_medical_document WHERE emp_id = '$emp_id' AND section_id = '$section_id' AND checkup_id = '$checkup_id'";
|
||
|
|
|
||
|
|
error_log("query to fetch upload data " . $sql);
|
||
|
|
$result = mysqli_query($conn, $sql);
|
||
|
|
|
||
|
|
|
||
|
|
$documents = array();
|
||
|
|
|
||
|
|
while ($row = mysqli_fetch_assoc($result)) {
|
||
|
|
$document = array(
|
||
|
|
'id' => $row['id'],
|
||
|
|
'medical_doc_desc' => $row['medical_doc_desc'],
|
||
|
|
'medical_doc_name' => $row['medical_doc_name'],
|
||
|
|
'medical_doc_type' => $row['medical_doc_type'],
|
||
|
|
'medical_doc' => base64_encode($row['medical_doc']),
|
||
|
|
);
|
||
|
|
|
||
|
|
$documents[] = $document;
|
||
|
|
}
|
||
|
|
|
||
|
|
header('Content-Type: application/json');
|
||
|
|
echo json_encode($documents);
|