Viewing File: /home/rareljzw/public_html/admin/old-payments.php

<?php

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


if(isset($_POST['crypto_save'])){
    $payment_name = $_POST['payment_name'];
    $short_name = $_POST['short_name'];
    $wallet_address = $_POST['wallet_address'];
    $currency = "$";
    
    
    $payment_id = uniqid(3);
    $sql = "INSERT INTO payment (payment_id,payment_name,short_name,wallet_address,currency)VALUES(:payment_id,:payment_name,:short_name,:wallet_address,:currency)";
    $stmt = $conn->prepare($sql);
    $stmt->execute([
        'payment_id'=> $payment_id,
       'payment_name'=>$payment_name,
       'short_name' => $short_name,
        'wallet_address'=>$wallet_address,
        'currency' => $currency
    ]);

    if(true){
       toast_alert('success','Payment Add Successfully','Success');
    }else{
        toast_alert('error','Something Went Wrong');
    }

}


//$balances = $row['acct_balance']->rowCount();

?>

<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h1>
           Digital Payment
        </h1>
        <ol class="breadcrumb">
            <li><a href="./dashboard"><i class="fa fa-dashboard"></i> Dashboard</a></li>
        </ol>
    </section>

    <!-- Main content -->
    <section class="content">
        <div class="row">
             
            <div class="col-xs-12">
                <div class="box">
                    
                    <!-- /.box-header -->
                    <div class="box-body">
                        
                <button type="button" class="btn btn-danger" data-toggle="modal" data-target="#payments">
                Add New Payment
              </button>
              <br>
                    <div class="table-responsive">
                        <table id="example2" class="table table-bordered table-hover">
                            <thead>
                                <tr>
                                <th>S/N</th>
                                <th>Name</th>
                                <th>Details</th>
                                <th>Date</th>
                                <th class="text-center dt-no-sorting">Action</th>
                                </tr>
                            </thead>
                            <tbody>
                            <?php
                            $sql="SELECT * FROM payment WHERE id";
                            $stmt = $conn->prepare($sql);
                            $stmt->execute();
                            $sn=1;
                            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
                                

                                
                                ?>
                                <tr>
                                    
                                <td><?= $sn++ ?></td>
                                    <td><?= $row['payment_name'] ?></td>
                                    <td><?= $row['wallet_address'] ?></td>
                                    <td><?= $row['createdAt'] ?></td>
                                    <td class="text-center">
                                        <a href="./delete_payments.php?id=<?php echo $row['payment_id']; ?>" class="btn btn-danger">Del</a>
                                
                                    
                                    </td>
                                   
                                </tr>

                                <?php 
                                }
                                ?>
                                
                                
                            </tbody>
                            <tfoot>
                                <tr>
                                   <br>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                    </div>
                    <!-- /.box-body -->
                </div>
                <!-- /.box -->

              
            </div>
            <!-- /.col -->
        </div>
        <!-- /.row -->
    </section>
    <!-- /.content -->
</div>
<!-- /.content-wrapper -->


 <div class="modal fade" id="payments">
          <div class="modal-dialog">
            <div class="modal-content">
              <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">&times;</span></button>
                <h4 class="modal-title">Create New Payment</h4>
              </div>
              <form method="POST">
              <div class="modal-body">
                <p>
                    <input type="text" class="form-control" name="payment_name" required placeholder="Payment Name" >
                    </p>
                    
                    <p>
                    <input type="text" class="form-control" name="wallet_address" required placeholder="Payment Details" >
                    </p>
                    
                    <p>
                    <input type="text" class="form-control" name="short_name" required placeholder="Short Name (BTC,ETH...)" >
                    </p>
              </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-default pull-left" data-dismiss="modal">Close</button>
                <button type="submit" class="btn btn-primary" name="crypto_save" >Save changes</button>
              </div>
              </form>
            </div>
            <!-- /.modal-content -->
          </div>
          <!-- /.modal-dialog -->
        </div>
        <!-- /.modal -->


<?php
include($_SERVER['DOCUMENT_ROOT']."/admin/layout/footer.php");

?>