<?php
session_start();
require_once("../LoginManager.php");
require_once("../DBManager.php");
include("dbconnection.php");
include("dashboarddocument.php");
include("header.php");
if(isset($_POST[submit]))
?>
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
<h3 align='center'>Assessment</h3>

  <?php
  	$sql ="SELECT * FROM potential WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
		    echo"
		    <h3 align='right'><a href='edit_showpage_Assessment.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]'>Edit&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a></h3>";
		}
		?>
<table id='example2' class='table table-bordered table-hover'>
    
    
<?php
  	$sql ="SELECT * FROM potential WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
if($rs[treatment_Facility] == 'Available'){
    echo "<tr><td width='50%'>Treatment Facility Option: </td>
    <td width='50%'>Available </td></tr>
";
if($rs[Mode_Treatment] == 'Explained-Accepted-to-Continue'){
    echo "<tr><td width='50%'>Mode of Treatment: </td>
    <td width='50%'>Explained Accepted to Continue </td></tr>
    <tr><td width='50%'>Plan Of Care: </td>
    <td width='50%'>$rs[Plan_Of_Care] </td></tr>
     <tr><td width='50%'>Operative procedure date : </td>
    <td width='50%'>$rs[operative_date] </td></tr>
";
}
else{
    echo"<tr><td width='50%'>Mode of Treatment: </td>
    <td width='50%'>$rs[Mode_Treatment] </td></tr>";
}
} else{
    echo " <tr><td width='50%'>Treatment Facility Option: </td>
    <td width='50%'> Unable</td></tr>";
}
}
?>

</table>