<?php


if(isset($_GET['Del'])){
    $GCDel=$con->query("DELETE FROM GeneralConsent WHERE id='$_GET[Del]'");
    if($GCDel==1){
        echo "<script>alert('Delete successfully..');</script><script>window.location='RequestforAdmissionset.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]'</script>;</script>";
    }
}
?>
 

  
    <?php
    $sql ="SELECT * FROM GeneralConsent WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
		$qsql = mysqli_query($con,$sql);
		if($rs = mysqli_fetch_array($qsql))
		{
		    echo "
<h3 align='center'>General Consent Signed</h3>
 <table id='example2' class='table table-bordered table-hover'>
 <tr><td></td><td><a href=''>Edit</a></td></tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; Towords : </td><td>$rs[towords]</td></tr>
<tr>
<td width='50%'>&nbsp;  &nbsp; &nbsp; &nbsp; General Consent Signed Copy : </td>
<td width='50%'>";
echo "<div class='row'><div class='col-sm-12'>
 <a href='Add_Gen_Con_Sign_Img.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]' style='float:right;' class='btn btn-info'>Add Image</a>
</div></div>";
    echo"<div class='row'>";
    $GeneralConsent=$con->query("SELECT * FROM GeneralConsent WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'");
    while($GC=$GeneralConsent->fetch_assoc()){
   echo "<div class='col-sm-3'>
   <a target='_blank' href='uploads/$GC[Upload_Consent]'><image src='../../uploads/$GC[Upload_Consent]' alt='img' class='img-thumbnail' style='width:150px; height:150px;'></a>
   
 
   
   <center><a href='RequestforAdmissionset.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Del=$GC[id]'>Delete</a></center>
   
   
   </div>";

}
echo"</td><td></td>
</tr>
</table>
";
}
?>