<?php
session_start();
require_once('../dbconnection.php');
$target_dir = "uploads/";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
$uploadOk = 1;
$imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));

if(isset($_POST["submit"])) {
    
    	$sql ="INSERT INTO patient_document(patientid,dateofissue,issueby,	typedocument,ifother,Specify,fileToUpload) values('$_POST[patientid]','$_POST[dateofissue]','$_POST[issueby]','$_POST[typedocument]','$_POST[ifother]','$_POST[Specify]','$_POST[fileToUpload]')";
    	if($qsql = mysqli_query($con,$sql))
	  	{
			echo "<script>alert('Immunization record inserted successfully...');</script>";
		}
		else
		{
			echo mysqli_error($con);
		}
  $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
  if($check !== false) {
    echo "<script>alert('Immunization record inserted successfully...');</script><script>window.location='patient_document.php?patientid=$_GET[patientid]'</script>;</script>File is an image - " . $check["mime"] . ".";
    $uploadOk = 1;
  } else {
    echo "File is not an image.";
    $uploadOk = 0;
  }
}

// Check if file already exists
if (file_exists($target_file)) {
  echo "Sorry, file already exists.";
  $uploadOk = 0;
}

// Check file size
if ($_FILES["fileToUpload"]["size"] > 500000) {
  echo "Sorry, your file is too large.";
  $uploadOk = 0;
}

// Allow certain file formats
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
&& $imageFileType != "gif" ) {
  echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
  $uploadOk = 0;
}

// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
  echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
  if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
    echo "The file ". basename( $_FILES["fileToUpload"]["name"]). " has been uploaded.";
  } else {
    echo "Sorry, there was an error uploading your file.";
  }
}
?>