<?php
include("headers.php");
include("menu.php");
include("ptchart.php");
include("dbconnection.php");
if(isset($_GET[delid]))
{
	 $sql ="DELETE FROM prescription_records WHERE prescription_record_id='$_GET[delid]'";
	$qsql=mysqli_query($con,$sql);
	if(mysqli_affected_rows($con) == 1)
	{
			echo "<script>window.location='prescriptionrecord.php?prescriptionid=$_GET[prescriptionid]';</script>";
		echo "<script>alert('prescription deleted successfully..');</script>";
	}
}
if(isset($_POST[submit]))
{
	if(isset($_GET[editid]))
	{
  }
}

?>
<style>
    form{
        margin: 20px 0;
    }
    form input, button{
        padding: 5px;
    }
    table{
        width: 100%;
        margin-bottom: 20px;
		border-collapse: collapse;
    }
    table, th, td{
        border: 1px solid #cdcdcd;
    }
    table th, table td{
        padding: 10px;
        text-align: left;
    }
	<style>
           
			table{
    border: solid 1px gray;
    width: 100%;
  }
  input{ width: 100%;}
        </style>
</style>
 
  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
 <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
<div class="wrapper col2">
  <div id="breadcrumb">
    
  </div>
</div>
<div class="wrapper col4">
  <div id="container">
 <table border="1">
      <tbody>
 <?php
		$sql ="SELECT * FROM prescription_records WHERE prescription_id='$_GET[prescription_id]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
        echo "<tr>
          <td><b>Hospital Name</b></td>
          <td>$rs[HospitalName]</td>
          <td><b>Consultant’s Name : Dr</b></td>
          <td>$rs[Dr]</td>
          </tr>
          <tr>
          <td><b>Addiction</b></td>
          <td>$rs[Addiction]</td>
          <td><b>Past History :</b></td>
          <td>$rs[PastHistory]</td>
          </tr>
          <tr>
          <td><b>Food Allergies</b></td>
          <td>$rs[Food]</td>
          <td><b>Medicine Allergies</b></td>
          <td>$rs[Medicine]</td>
          </tr><tr>
          <td><b>Other Allergies</b></td>
          <td>$rs[Addiction]</td>
          <td><b>CBC Report </b></td>
          <td>$rs[CBC]</td></tr>
          <tr>
          <td><b>RFT Report</b></td>
          <td>$rs[RFT]</td>
          <td><b>ABG Report </b></td>
          <td>$rs[ABG]</td></tr>
          <tr>
          <td><b>LFT Report</b></td>
          <td>$rs[LFT]</td>
          <td><b>X-RAY Report </b></td>
          <td>$rs[XRAY]</td></tr>
          <tr>
          <td><b>SUGAR Report</b></td>
          <td>$rs[SUGAR]</td>
          <td><b>ECHO2 Report </b></td>
          <td>$rs[ECHO2]</td></tr>
          <tr>
          <td><b>CT/MRI Report</b></td>
          <td>$rs[CTMRI]</td>
          <td><b>PT/PTT Report </b></td>
          <td>$rs[PTPTT]</td></tr>
          <tr>
          <td><b>ECG Report</b></td>
          <td>$rs[ECG]</td>
          <td><b>USG Report </b></td>
          <td>$rs[USG]</td></tr>
          <tr>
          <td><b>Others Report</b></td>
          <td>$rs[RPOthers]</td>
          <td><b>Condition at Discharge </b></td>
          <td>$rs[ConDischarge]</td></tr>
		  ";
if(isset($_SESSION[adminid]))
{
		  echo "<a href='patient.php?editid=$rs[patientid]'>Edit</a> | <a href='viewpatient.php?delid=$rs[patientid]'>Delete</a> <hr>
<a href='patientreport.php?patientid=$rs[patientid]'>View Report</a>";
}
		  echo "</td></tr>";
		}
		?>