<?php session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
include 'header.php';
include 'dashboarddocument.php';
//Code for Registration 
if(isset($_POST['signup'])) 
{ 
    	$updated_at=date("F d, Y / h:i:s A");
$sql ="UPDATE Instruction_Sheet SET foodtake='$_POST[foodtake]',Anesthesia_Note='$_POST[Anesthesia_Note]',updated_at='$updated_at'  WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
if($qsql = mysqli_query($con,$sql))
		{
		       echo "<script>alert('Update successfully');</script><script>window.history.go(-2)</script>;</script>";
  } 
 else {
    echo "Sorry, there was an error uploading your file.";
  } 
   
  
}

?>


<style>


.center {
   border: 1px solid grey;
   text-align:;
}

  
    .box2{
              display: none;
    
    }
            
       .center {
   border: 1px solid grey;
   text-align:;
}
    .center2 {
   border: 5px solid grey;
   text-align:;
}
  </style>
  
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
  <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>

<form name="signup" enctype="multipart/form-data" method="post" >
<h3 align='center'>Instruction Sheet</h3>
<table id='example2' class='table table-bordered table-hover'>
<?php
  	$sql ="SELECT * FROM Instruction_Sheet WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND surgeryid='$_GET[surgeryid]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
	
    echo " <tr><td width='50%'>Food Intake: </td>
<td width='50%'><select name='foodtake'>
 <option value='$rs[foodtake]'>$rs[foodtake]</option>
    <option value='None'>None</option>
        <option value='Normal'>Normal </option>
            <option value='Liquid'>Liquid</option>
                <option value='Nil by mouth'>Nil by mouth</option>
</select></td></tr>
<tr><td width='50%'>Anesthesia Note and instruction: </td>
<td width='50%'><textarea name='Anesthesia_Note' rows='2' cols='80'>$rs[Anesthesia_Note]</textarea></td></tr>";


?>

</table>
	<button type="submit" name="signup"> <span style="color:WHITE">Update</SPAN></button>
				 
				 
				 </form>