<?php
include '../Includes/db.php';


// $sql = "select * from tbl_payment where patient_id='$i'  ";
//                                                 $sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
//                                                 $sql_row = mysqli_fetch_assoc($sql_res);
//                                                 $payid = $sql_row['id'];

$i=$_GET['id'];
$a="delete from tbl_paitant where id=$i";
$result = mysqli_query($con,$a);



// $j=$_GET['payid'];
$k="delete from tbl_payment where patient_id=$i";
$results = mysqli_query($con,$k);



if ($result) 
{?>
    <script type="text/javascript">alert("Data Deleted");</script> <?php echo"<script>location.href='../view_patient_data.php';</script>";

}
else
{?>
    <script type="text/javascript">alert("Data not Deleted");</script>
<?php
echo"<script>location.href='../view_patient_data.php';</script>";
 }



?>