File Manager

Editing File: /home/rareljzw/public_html/admin/delete_payments.php

<?php

$pageName  = "Deleting";
include($_SERVER['DOCUMENT_ROOT']."/admin/layout/header.php");

$id = $_GET['id'];

$sql = "SELECT * FROM payment LEFT JOIN users ON payment.id = users.id WHERE payment.payment_id=:id";
$data = $conn->prepare($sql);
$data->execute(['id'=>$id]);

$row = $data->fetch(PDO::FETCH_ASSOC);

$sql = "DELETE FROM payment WHERE payment.payment_id=:id";
    $stmt = $conn->prepare($sql);
    $stmt->execute([
        'id'=>$id
    ]);

if(true){
       //  toast_alert('success','Deleted Successfully','Deleted');
       $msg1 = "
        <div class='alert alert-warning'>
        
        <script type='text/javascript'>
             
                function Redirect() {
                window.location='./payments';
                }
                document.write ('');
                setTimeout('Redirect()', 3000);
             
                </script>
                
        <center><img src='../assets/images/loading.gif' width='180px'  /></center>
        
        
        <center>	<strong style='color:black;'>Deleted, Please Wait while we redirect you...
               </strong></center>
          </div>
        ";
    }else{
        toast_alert('danger','Sorry Something Went Wrong','Error');
    }
    
    // header('Location:./wire-trans');

?>

<div class="row">
    <?php if (isset($msg1)) echo $msg1; ?> 
    </div>

Back to Directory File Manager

<