.-.-.-.-.-

<?php
$title = "Transfer Fund";
include 'header.php';
//include_once('lib/ps_pagination.php');
?>
<h3>Transfer Fund</h3>
<div class="container-fluid">

<div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Transfer Fund</h4>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                    <li class="breadcrumb-item"><a href="#">Management</a></li>
                    <li class="breadcrumb-item active">Transfer Fund</li>
                </ol>
            </div>
        </div>
    </div>
    
    <div class="row">
        <div class="col-12">
            <div class="card m-b-20">
                <div class="card-body">
                    <form name="form" id="form" action="transfer_fund_model.php" method="post">
                        <div class="form-group row">
                            
                            <label class="col-sm-2 col-form-label" for="amount">Enter Amount  <span>*</span></label>

                            <div class="col-sm-10">

<input class="form-control" type="text" name="amount" id="amount" required="required" pattern="[0-9]{2,10}">
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="uid">Enter User Id  </label>
                            <div class="col-sm-10">
                                <input class="form-control" type="text" name="uid" id="uid" required="required" maxlength="200">
                            </div>
                        </div>

<div class="form-group">
                            <div>
                                <button name="submit" type="submit" id="submit" value="Transfer" class="btn btn-primary waves-effect waves-light">
                                    Submit
                                </button>
                            </div>
                        </div>

</form>
                </div>

</div>
        </div> 
    </div>

</div>

</div>
        </div>
    </div>
    <div class="row">
        <div class="col-lg-12">
            <div class="card m-b-20">
                <div class="card-body">

<table class="table mb-0 datatable">
                        <thead>
                            <tr>
                                <th>S.No</th>
                                <th>To</th>
                                <th>From</th>
                                <th>Amount</th>
                                <th>Date</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                             $query= "SELECT uid, from_uid, amount, datetime FROM  fund_transfer ORDER BY datetime DESC";
                             $rs = mysqli_query($connection, $query);
                            while ($row = mysqli_fetch_object($rs)) {
                                $to = mysqli_fetch_object(mysqli_query($connection,"SELECT login_id, name FROM user WHERE uid='$row->uid'"));
                                $from = mysqli_fetch_object(mysqli_query($connection,"SELECT login_id, name FROM user WHERE uid='$row->from_uid'"));
//                                $rs = mysqli_query($connection, $query);
                                $i = 1;
//                                if ($rs) {
//                                    while ($bank = mysqli_fetch_object($rs)) {
                                        ?>
                                        <tr>
                                            <td><?php echo $i; ?></td>
                                            <td><?php echo $to->name . " (" . $to->login_id . ")"; ?></td>
                                            <td><?php echo $from ? $from->name . " (" . $from->login_id . ")" : "Admin"; ?></td>
                                            <td><?php echo $row->amount; ?></td>
                                            <td><?php echo date("d M, Y H:i A", strtotime($row->datetime)); ?></td>
                                        </tr>
                                        <?php
                                        $i++;
//                                    }
                                }
                                ?>
                            </tbody>
                        </table>
                        <?php //echo $pager->renderFullNav(); ?>  
                    </div>
                </div>
            </div> 
        </div>
        
    </div>
    
    <?php include('footer.php'); ?>

/home2/wtmwscom/mail/../www/admin/transfer_fund.php