1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / promarketindex.site / dashboard /
Filename : transactions.php
back
<?php
session_start();
error_reporting(0);
include('../../config/pconfig.php');
include('includes/checklogin.php');
check_login();
$title="Earnings";
$uid=$_SESSION['id'];
$uip=$_SERVER['REMOTE_ADDR'];
include 'includes/header.php'; 
include 'includes/sidebar.php';

$currentTime = date( 'd-m-Y h:i:s A', time () );
$sql = "SELECT * FROM users WHERE id=$uid";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);

			?>

 
<div class="container-fluid pt-4 px-4">
<div class="bg-secondary  rounded p-4">
      <div class="d-flex align-items-center justify-content-between mb-4">
          <h4 class="card-title">Transactions</h4>
      </div>

            <div class="bg-secondary rounded h-100 p-4">           
                <div class="table-responsive">
                        <?php 
                         $query="SELECT * FROM `transactions` WHERE `user_id`='$uid' AND `type` IN ('Deposit', 'Withdrawal') ORDER BY id DESC  ";
                         $result=mysqli_query($con,$query);
                         $cnt=1;
                         if(mysqli_num_rows($result)>0){

                          
      
      
                            ?>
                <table class="table">
                <thead>
                    <tr>
                    <th>SN</th>
                    <th>Amount</th>
                    <th>Status</th>
                    <th>Date</th>
                    </tr>
                </thead>
                <tbody>
                <?php 
            while($trx=mysqli_fetch_array($result)){
                $status=$trx['status'];
                $date=$trx['date'];
                // date_from must be from 3rd day (from order date)
                         // date_to must be the next 5th days
                         $trx_date = date(' jS F, Y ');
                         $today_date = date('l jS \of F Y');
                ?>
                    <tr>
                    <td><?php echo $cnt++; ?></td>
                    <td>$<?php echo $trx['amount']; ?></td>
                    <td>
                    <?php 
                    if($status == "Pending"){  
                    ?>
                <button class="btn btn-warning">Pending</button>
                <?php
                   }else{
               ?>
                <button class="btn btn-success">Confirmed</button>
                <?php
                }
                ?>
                </td>
                <td><?php echo $trx_date; ?></td>
                </tr>
                    <?php } 
            }else{
                echo"
                <div class='card-body'>
                <p style='text-align:left'> No Transaction yet!</p>
                </div>
                ";
            }
            ?>
                </tbody>
                </table>
                    </div>


                    </div>

                    </div>

                  </div>
             
             
            
              
     
<?php include 'includes/footer.php' ?>