tasslihorec
sfaxoistadet
bintestcss
<?php
include '../includes/koneksi.php';

// Cek jika ada filter pencarian
$search = isset($_GET['search']) ? $_GET['search'] : '';
$filter_query = "WHERE username LIKE '%$search%' OR jenis_cheat LIKE '%$search%'";

// Ambil data member dari database
$query = "SELECT * FROM data_member $filter_query";
$result = mysqli_query($conn, $query);

// Header untuk download file Excel
header("Content-type: application/vnd-ms-excel");
header("Content-Disposition: attachment; filename=data_member_" . date('Ymd') . ".xls");
?>

<table border="1">
    <thead>
        <tr>
            <th>No</th>
            <th>Username</th>
            <th>Nomor Telepon</th>
            <th>Jenis Cheat</th>
            <th>Winrate</th>
            <th>Jackpot</th>
            <th>Jam Jackpot</th>
        </tr>
    </thead>
    <tbody>
        <?php
        $no = 1;
        while ($row = mysqli_fetch_assoc($result)) {
        ?>
        <tr>
            <td><?= $no++ ?></td>
            <td><?= htmlspecialchars($row['username']) ?></td>
            <td><?= htmlspecialchars($row['nomor_telepon']) ?></td>
            <td><?= htmlspecialchars($row['jenis_cheat']) ?></td>
            <td><?= $row['winrate'] == 1 ? 'Aktif' : 'Nonaktif' ?></td>
            <td><?= $row['jackpot'] == 1 ? 'Aktif' : 'Nonaktif' ?></td>
            <td><?= htmlspecialchars($row['jam_jp']) ?></td>
        </tr>
        <?php } ?>
    </tbody>
</table>