<?php
session_start();
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../patientmanager.php');
include("header.php");
include("dashboarddocument.php");
?>
 <div class="content-wrapper">
<table id="example2"  id ="demo" class="table table-bordered table-hover">
                  <thead>
                  <tr>
                  <div id="listingTable">
    <div class='card-header d-flex p-0'>
                    <ul class='nav nav-pills ml-auto p-2'>
         <th><strong>Date Time</strong></th>
         <th><strong>Investigation</strong></th>
          <th><strong>Result</strong></th> 
          <th><strong>Evidence</strong></th>
               <th><strong>Action</strong></th>
                       </tr>
                  </thead>
                  
               
                 
<?php
   include("dbconnection.php");
			$sql ="SELECT * FROM investigation WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
            echo " <tbody>
                                                                                                                                                                
     <tr>   <td>&nbsp;$rs[created_at]</td>     
            <td>&nbsp;";
	   if (is_numeric($rs[Category]))
{
$sql1 ="SELECT * FROM labdepartment WHERE labdepartmentid='$rs[Category]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
echo "$rh1[lab_department_name]";
}

   if (is_numeric($rs[Sub_Category]))
{
$sql1 ="SELECT * FROM radiobodypart WHERE radiobodypartid='$rs[Sub_Category]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
echo "-  &nbsp; $rh1[bodypart]";
}
   if (is_numeric($rs[Sub_Category]))
{
$sql1 ="SELECT * FROM list_Investigation WHERE ivid='$rs[Investigation]'";
		$qsql1 = mysqli_query($con,$sql1);
	while($rh1 = mysqli_fetch_array($qsql1))
echo "-  &nbsp; $rh1[Investigation]";
}

            $sqlpatient1 = "SELECT * FROM list_Investigation WHERE ivid='$rs[ivid]' OR ivid='$rs[Investigation]' AND labdepartmentid='Unspecified'";
	$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
	while($rsn = mysqli_fetch_array($qsqlpatient1))
	{
	    echo"
	    $rsn[Investigation]"; }
	    echo"</b></td>
           <td>&nbsp;$rs[Result]</td>
		   <td>&nbsp;$rs[Evidence]</td>
		 <td><a href='opdset.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[id]'>Delete</a></td>

	
          </tr>                   
          
     ";
}
?>  
   </tbody>
</table>  
</div>