<?php session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
include 'header.php';
include 'dashboarddocument.php';
//Code for Registration 
if(isset($_POST['signup'])) 
{ 
$sql ="UPDATE Medical_vitals SET Bmi='$_POST[Bmi]',Wt='$_POST[Wt]',BP='$_POST[BP]',BP2='$_POST[BP]',SPo2='$_POST[SPo2]',RBS='$_POST[RBS]',Temp='$_POST[Temp]',Pulse='$_POST[Pulse]'  WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$sql1 ="UPDATE vitals_final SET bmi='$_POST[Bmi]',Wt='$_POST[Wt]',BP='$_POST[BP]',BP2='$_POST[BP2]',Spo2='$_POST[SPo2]',RBS='$_POST[RBS]',Temp='$_POST[Temp]',Pulse='$_POST[Pulse]'  WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND poa='Medical Assessment'";
if($qsql = mysqli_query($con,$sql))
		{
  if($qsql = mysqli_query($con,$sql1))
		    {
    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:;
}

</style>
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">


    <form name='signup' method='POST'>
        <div class='center'>
<table id='example2' class='table table-bordered table-hover'>

<?php
  	$sql ="SELECT * FROM Medical_vitals WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
		    echo"  <table id='example2' class='table table-bordered table-hover'>
		    <tr><td width='50%'>BMI</td><td  width='50%'><input type='text' name='Bmi' value='$rs[Bmi]'></td></tr>
<tr><td width='50%'>SPo2</td><td  width='50%'>
	<input type='text' name='SPo2' value='$rs[SPo2]'></td></tr>
<tr><td  width='50%'>RBS</td><td  width='50%'>
	<input type='text' name='RBS' value='$rs[RBS]'></td></tr>
		    <tr><td width='50%'>Temp</td><td  width='50%'><input type='text' name='Temp' value='$rs[Temp]'></td></tr>
		    <tr><td width='50%'>Pulse</td><td  width='50%'><input type='text' name='Pulse' value='$rs[Pulse]'></td></tr>
		    <tr><td width='50%'>Blood Pressure</td><td  width='50%'><input type='text' name='BP2' value='$rs[BP2]'><input type='text' name='BP' value='$rs[BP]'></td></tr>
<br>
    
	";
		}
		?>

</table>

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