40 lines
1.5 KiB
PHP
40 lines
1.5 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include ('includes/functions.php');
|
|
include ('log_entry.php');
|
|
error_reporting(E_ERROR | E_PARSE);
|
|
$file_path=$_FILES['file_medical_exam']['tmp_name']; //pdf is the name of the input type where we are uploading files
|
|
$file_type=$_FILES['file_medical_exam']['type'];
|
|
$file_size=$_FILES['file_medical_exam']['size'];
|
|
$file_name=$_FILES['file_medical_exam']['name'];
|
|
//$medical_exam_id=$_REQUEST['medical_exam_id_doc'];
|
|
//$appointment_id =$_POST['appoint'];
|
|
$emp_id=($_REQUEST['emp_id'])?($_REQUEST['emp_id']):($_REQUEST['FLEX_PATIENT_ID']);
|
|
$sickness_id =($_REQUEST['sickness_id'])?($_REQUEST['sickness_id']):($_REQUEST['flex_sickness_id']);
|
|
|
|
if(!$emp_id){
|
|
$emp_id = getFieldFromTable('emp_id','sickness','sickness_id',$sickness_id);
|
|
}
|
|
if(!isset($sickness_id)){
|
|
$sickness_id = getFieldFromTable('max(sickness_id)','sickness','emp_id',$emp_id);
|
|
}
|
|
|
|
if ($file_name != ""){
|
|
$data=mysqli_real_escape_string($conn,file_get_contents($file_path));
|
|
$query="INSERT INTO medical_document SET medical_doc_desc='".$_POST['medical_exam_document']."',medical_doc = '".$data."',medical_doc_name='".$file_name."',medical_doc_type='".$file_type."',sickness_id='".$sickness_id."',emp_id='".$emp_id."'";
|
|
|
|
if (!$result = @mysqli_query($conn,$query)) {
|
|
error_log ("Exception:".mysqli_error($conn));
|
|
error_log ("Failed to Execute the Upload Document Query::: ".$query);
|
|
exit(mysqli_error($conn));
|
|
}else{
|
|
error_log (" Upload Document Query::: ".$query);
|
|
}
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
?>
|