<?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 histopathology SET Diagnosis='$_POST[Diagnosis]',specimen='$_POST[specimen]',investigation='$_POST[investigation]',Ref_Dr='$_POST[Ref_Dr]',Containerno='$_POST[Containerno]'  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.";

  }
}
?>

   <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
    <?php
    $sql ="SELECT * FROM histopathology WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND surgeryid='$_GET[surgeryid]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
		    echo "
<h3 align='center'>Histopathology</h3>

<form name='signup' method='POST'>
 <table id='example2' class='table table-bordered table-hover'>
 
 
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Diagnosis: </td>
<td width='50%'><input type='text' name='Diagnosis' value='$rs[Diagnosis]'></td>
</tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Specimen: </td>
<td width='50%'><input type='text' name='specimen' value='$rs[specimen]'></td>
</tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp;  Investigation: </td>
<td width='50%'>";?>
<select class='selectva'  name="investigation">
        	<option value="">Investigation</option>
                        <?php
include("dbconnection.php");
	$sqlpatient1 = "SELECT * FROM `list_Investigation` where labdepartmentid='4'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{?>
	   <option value='<?php echo $rsn['ivid'] ?>' <?php echo ($rsn['ivid']==$rs['investigation'])? 'selected':'';?> ><?php echo $rsn['Investigation'] ?></option>";
			<?php	}
	
		  ?>

</select>
<?php echo "

</td>
</tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Ref.by Dr: </td>
<td width='50%'><input type='text' name='Ref_Dr' value='$rs[Ref_Dr]'></td>
</tr>
 <tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Container no: </td>
<td width='50%'>";?>
<select name="Containerno" required>
                	<option value="">Priority slip </option>
	<option value="Urgent" <?php echo ('Urgent'==$rs['Containerno'])? 'selected':'';?>>Urgent </option>
	<option value="Normal" <?php echo ('Normal'==$rs['Containerno'])? 'selected':'';?>>Normal </option>
</select>
<?php echo "
</td>
</tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Specimen Wt: </td>
<td width='50%'><input type='text' name='specimen_wt' value='$rs[specimen_wt]'></td>
</tr>
";
}
?>

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



</div>