<?php session_start();
include 'dbconnection.php';
require_once("../patientmanager.php");
require_once("../DBManager.php");
include 'header.php';
include 'dashboarddocument.php';
if(isset($_POST['Physical_Assessment'])) 
{
  	$updated_at=date("F d, Y / h:i:s A");
$sql1 ="UPDATE Physical_Assessment SET XYLOCAINE_SENSITIVITY='$_POST[XYLOCAINE_SENSITIVITY]',Food_Intake='$_POST[Food_Intake]',PHYSICAL_STATUS='$_POST[PHYSICAL_STATUS]',Thyromental_Distance='$_POST[Thyromental_Distance]',Mallampati_Score='$_POST[Mallampati_Score]',Metabolic_Score='$_POST[Metabolic_Score]' WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$sql2 ="UPDATE save_activity SET created_at='$_POST[created_at]',updated_at='$updated_at'  WHERE prescriptionid='$_GET[prescriptionid]' AND userno='$_GET[patientid]' AND discription='Intial Assessment<br>Request for Consultation<br>Doc.no-'";if($qsql = mysqli_query($con,$sql))
		{
		    if($qsql = mysqli_query($con,$sql1))
		    	    if($qsql = mysqli_query($con,$sql2))
		    	    	 
		    {
    echo "<script>alert('Update successfully');</script><script>window.history.go(-2)</script>;</script>";
  } 
  }else {
    echo "Sorry, there was an error uploading your file.";
  } 
   
  
}

?>
 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
   <form name="Physical_Assessment" method="post">
               <h2 align="center">Pre-Anesthesia evaluation</h2>
    
               <br>
      
		<div class="center">


<table id="example2" class="table table-bordered table-hover" border="1" width='100%'>
    
    <?php 
		$sql ="SELECT * FROM Physical_Assessment WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
		    echo "
<tr>
   <td width='50%'>XYLOCAINE SENSITIVITY 
</td>
<td width='50%'><select name='XYLOCAINE_SENSITIVITY'>
        <option value='$rs[XYLOCAINE_SENSITIVITY]' >$rs[XYLOCAINE_SENSITIVITY]</option>
        <option value='Unknown'>Unknown</option>
       <option value='Present'>PRESENT</option>
    <option value='ABSENT'>ABSENT </option>
           </select></td>
</tr> 
<tr>
   <td width='50%'>Food Intake 
</td>
<td width='50%'><select name='Food_Intake'>
  <option value='$rs[Food_Intake]' >$rs[Food_Intake]</option>
        <option value='Unknown'>Unknown</option>
       <option value='Nil by Mouth'>Nil by Mouth</option>
    <option value='By Mouth'>By Mouth  </option>
           </select></td>
</tr>  
<tr>
   <td width='50%'>PHYSICAL STATUS 
</td>
<td width='50%'><select name='PHYSICAL_STATUS'>
  <option value='$rs[PHYSICAL_STATUS]' >$rs[PHYSICAL_STATUS]</option>
        <option value='Unknown'>Unknown</option>
       <option value='I'> I</option>
    <option value='II'> II </option>
    <option value='III'> III</option>
      <option value='IV'> IV</option>
       <option value='V'> V</option>
       <option value='E'>E</option>
           </select></td>
</tr>  
<tr>
   <td width='50%'>MALLAMPATI SCORE
</td>
<td width='50%'><select name='Mallampati_Score'>
        <option value='$rs[Mallampati_Score]' >$rs[Mallampati_Score]</option>
        <option value='Unknown'>Unknown</option>
       <option value='CLASS I'>CLASS I</option>
    <option value='Class II'>Class II </option>
    <option value='Class III'>Class III</option>
     <option value='Class IV'>Class IV</option>
               </select></td>
</tr> 
  <tr>
            <td width='50%'>Thyromental Distance:

</td>
             <td width='50%'>
          <input type='text' value='$rs[Thyromental_Distance]' name='Thyromental_Distance'></td>
            
        </tr> 
         <tr>
            <td width='50%'>Metabolic Score:

</td>
             <td width='50%'>
          <input type='text' value='$rs[Metabolic_Score]' name='Metabolic_Score'></td>
            
        </tr> 
         ";
		}
		?>
 </table>    
 
 <input type='submit' name='Physical_Assessment' value='Submit'>
 </div>
 </form>