<?php session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
include 'header.php';
include 'dashboarddocument.php';
include("dbconnection.php");
if(isset($_POST['signup'])) 
{
    
$sql ="UPDATE nurse_note SET output_datetime='$_POST[output_datetime]',	Intake='$_POST[Intake]',Amount='$_POST[Amount]',Output='$_POST[Output]',	output_Amount='$_POST[output_Amount]'  WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id='$_GET[id]'";
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.";

  }
}
?>

 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <form name='signup' method='POST'>
   	<table id="example2" class="table table-bordered table-hover"> 
   
   	<?php
$sql ="SELECT * FROM nurse_note WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND id='$_GET[id]'";
$qsql = mysqli_query($con,$sql);
while($rs1 = mysqli_fetch_array($qsql))
{
     echo " 
     <tr>
    <td>Date & Time</td>
<td><input type='datetime-local' value='$rs1[output_datetime]' name='output_datetime'></td>
    </tr>
    <tr>
    <td>Intake</td><td><select name='Intake'>
	<option value='$rs1[Intake]'>$rs1[Intake]</option>
	<option value='Blood'>Blood</option>
	<option value='IV-Fluid'>Iv Fluid</option>
		<option value='RT'>RT</option>
	<option value='Oral-Food'>Oral Food</option>
	<option value='Oral-Liquid'>Oral Liquid</option>
	</select></td></tr>
	<tr><td>Intake (Amount) </td><td><input type='text' value='$rs1[Amount]' placeholder='Amount'  name='Amount'></td></tr>
	<tr><td>Output</td><td><select name='Output'>
	<option value='$rs1[Output]'>$rs1[Output]</option>
		<option value='Drain'>Drain</option>
			<option value='Urine'>Urine</option>
			<option value='Stool'>Stool</option>
			<option value='Vomiting'>Vomiting</option>
	

	</select></td></tr>
		<tr><td>Output (Amount) </td><td><input type='text' value='$rs1[output_Amount]' placeholder='Amount' name='output_Amount'></td></tr>
     
     
     
          ";
}

?> 
   	</table>
   	
   	<input type='submit' name='signup' value='Update'>
   	</form>