MASTER

SAVING...

BERHASIL DIUBAH!

EDITING: daftar_withdraw.php

<div class="page-breadcrumb">
    <div class="row">
        <div class="col-5 align-self-center">
            <h4 class="page-title">Daftar Withdraw</h4>
        </div>
        <div class="col-7 align-self-center">
            <div class="d-flex align-items-center justify-content-end">
                <nav>
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item">
                            <a href="#">Daftar Withdraw</a>
                        </li>
                        <li class="breadcrumb-item active">Menu Daftar Withdraw</li>
                    </ol>
                </nav>
            </div>
        </div>
    </div>
</div>

<div class="card-body">
                    <h4 class="card-title">Daftar Withdraw</h4>
                </div>

<div class="table-responsive">
                    <table id="zero_config" class="table table-striped table-bordered">
                        <thead>
                            <tr>
                                <th>#</th>
                                <th>Tanggal</th>
                                <th>Username</th>
                                <th>Transfer Ke</th>
                                <th>Nomor Rekening</th>
                                <th>Atas Nama</th>
                                <th>Jumlah</th>
                                <th>Status</th>
                            </tr>
                        </thead>

<tbody>
                        <?php
                        $query = mysqli_query($koneksi, "
                            SELECT * FROM tb_transaksi 
                            WHERE transaksi = 'Withdraw' 
                            ORDER BY id DESC
                        ");

$no = 1;

while ($data = mysqli_fetch_array($query)) {

$id_user = $data['id_user'];

// 🔹 Ambil username (AMAN)
                            $queryUser = mysqli_query($koneksi, "
                                SELECT * FROM tb_user 
                                WHERE extplayer = '$id_user' 
                                OR id = '$id_user'
                            ");
                            $user = mysqli_fetch_array($queryUser);
                            $username = $user['username'] ?? '-';

// 🔥 Ambil data rekening dari transaksi
                            $pecah = explode(' - ', $data['dari_bank']);

$bank  = isset($pecah[0]) ? $pecah[0] : '-';
                            $norek = isset($pecah[1]) ? $pecah[1] : '-';

// fallback nama jika kosong
                            if (isset($pecah[2]) && !empty($pecah[2])) {
                                $nama = $pecah[2];
                            } else {
                                $nama = '-';
                            }
                        ?>

<?php } ?>
                        </tbody>

</table>
                </div>

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