1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / earnlouq / machineswift.net / admin /
Filename : history.php
back
<?php
session_start();
error_reporting(0);
include('../../config/config.php');
include('includes/checklogin.php');
check_login();
$title="Transaction History";
include 'includes/header.php'; 
include 'includes/sidebar.php';
$currentTime = date( 'd-m-Y h:i:s A', time () );
?>    
 <div class="container-fluid py-4">
                <div class="card" style="padding:30px;">
                <h5 class="card-header">Transactions</h5>
                <div class="table-responsive table-wrapper-top text-nowrap" >


                    <div class="table-responsive">
                    <?php 
                         $query="SELECT `users`.`id`,`users`.`first_name`,`users`.`last_name`,`transactions`.`type`,`transactions`.`amount`,
                         `transactions`.`status`,`transactions`.`method`,`transactions`.`date` 
                         FROM `transactions` 
                         LEFT JOIN users on users.id=transactions.user_id ";
                         $result=mysqli_query($con,$query);
                         $cnt=1;
                         if(mysqli_num_rows($result)>0){
                       
                          ?>
                      <table class="table" id="dataTables-example">
                        <thead>
                          <tr>
                            <th>SN</th>
                            <th>Name</th>
                            <th>Type</th>
                            <th>Amount</th>
                            <th>Status</th>
                            <th>Date</th>
                            <th></th>
                          </tr>
                        </thead>
                        <tbody>
                        <?php 
                    while($trx=mysqli_fetch_array($result)){
                      $date_string=$trx['date'];// date retrieved from database
                      $timestamp = strtotime($date_string); // convert date string to Unix timestamp
                      $date = date(" jS \of F Y", $timestamp);// format timestamp into words
                      ?>
                          <tr>
                           <td><?php echo $cnt++; ?></td>
                            <td><?php echo $trx['first_name']; ?> <?php echo $trx['last_name']; ?></td>
                            <td><?php echo $trx['type']; ?></td>
                            <td class="uppercase-text"><?php echo $trx['amount']; ?> <?php echo $trx['coin']; ?></td>
                            <td>
                            <?php if($trx['status'] == 'Pending'){   
                            ?>
                             <label class="badge badge-danger"><?php echo $trx['status']; ?></label>
                             <?php }else{
                                ?>
                            <label class="badge badge-success"><?php echo $trx['status']; ?></label>
                              
                             <?php }?>
                                </td>
                                <td><?php echo $date ?></td>
                                <td>
                                <a href="account-summary.php?uid=<?php echo $trx['id'];?>" 
                    class="badge badge-primary">
                     User</a>
                             </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>
              </div>
             
            
              
        </div>
        </div>          


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