Viewing File: /home/rareljzw/public_html/admin/delete_transactions.php

<?php

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

$id = $_GET['id'];

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

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


    $sql = "DELETE FROM wallet WHERE wallet.refrence_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='./transactions';
                }
                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:./credit_debit_trans");

    
    ?>


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