<?php
session_start();
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../patientmanager.php');
if(isset($_POST[handover]))
{
 PatientManager::handover("$_GET[prescriptionid]","$_GET[patientid]","$_POST[Nursinggivern_Instruction]","$_POST[entered_by]");	
}
		
?>


 
    	<table id="example2" class="table table-bordered table-hover">  
            
              <tr>
             <th>Created</th>    
          <th>Instruction</th>
            </tr>
            
            <?php
            
		
		$sql ="SELECT * FROM drnote WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs4 = mysqli_fetch_array($qsql))
		{
		    
            echo "                                        
     <tr>   <td><b>Towords :</b> Doctor Instruction <br><b>By :</b>";
         	$sqldoctor= "SELECT * FROM site_users WHERE userno='$rs4[entered_by]'";
			$qsqldoctor = mysqli_query($con,$sqldoctor);
			while($rsdoctor = mysqli_fetch_array($qsqldoctor))
			{
			    echo"
$rsdoctor[name]
<br>";
}echo" <b>AT :</b>$rs4[created_at]</td>
           <td>&nbsp;$rs4[Nursing_Instruction]</td>
          </tr>                   
          
          ";
}

?>



            
            <?php
		$sql ="SELECT * FROM handover WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs4 = mysqli_fetch_array($qsql))
		{
           echo"
         <tr>     <td><b>Towords :</b> Nursing Handover<br><b>By :</b>";
         
         	$sqldoctor= "SELECT * FROM site_users WHERE userno='$rs4[entered_by]'";
			$qsqldoctor = mysqli_query($con,$sqldoctor);
			while($rsdoctor = mysqli_fetch_array($qsqldoctor))
			{
			    echo"
$rsdoctor[name]
<br>";
}echo" <b>AT :</b>$rs4[created_at]</td>
           <td>&nbsp;$rs4[Nursinggivern_Instruction]</td>
          </tr>                   
          
          ";
}
?>




            </table>
  <p>&nbsp;</p>
  <form name='handover' method='POST'>
      <label>Instruction</label>
<textarea  name="Nursinggivern_Instruction" rows="3" cols="100">
</textarea><input type='submit' name='handover' value='Submit'>
  </form>