alert("Terjadi kesalahan, harap masuk kembali!"); window.location.replace("' . $alamat_admin . 'keluar.php"); '; exit(); } if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['hapus_banyak'])) { $ids = $_POST['cuid_checkbox'] ?? []; if (!empty($ids)) { $clean_ids = array_map(function($id) use ($koneksi) { return mysqli_real_escape_string($koneksi, $id); }, $ids); $id_list = implode("','", $clean_ids); // Pastikan nama kolom 'id' atau 'cuid' sesuai database Anda $hapus_banyak = mysqli_query($koneksi, "DELETE FROM tb_gamelist_sgx WHERE id IN ('$id_list')"); if ($hapus_banyak) { $_SESSION['success'] = "Data berhasil dihapus."; } else { $_SESSION['error'] = "Gagal menghapus: " . mysqli_error($koneksi); } echo ''; exit(); } } if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'update') { $id = mysqli_real_escape_string($koneksi, $_POST['id']); $game_name = mysqli_real_escape_string($koneksi, $_POST['game_name']); $game_code = mysqli_real_escape_string($koneksi, $_POST['game_code']); $banner = mysqli_real_escape_string($koneksi, $_POST['banner']); $provider = mysqli_real_escape_string($koneksi, $_POST['provider']); $datatype = mysqli_real_escape_string($koneksi, $_POST['datatype']); $status = (int)$_POST['frbavailable']; $populer = (int)$_POST['rekomendasi']; $poster = mysqli_real_escape_string($koneksi, $_POST['poster']); $posisi = (int)$_POST['posisi']; $tab = mysqli_real_escape_string($koneksi, $_POST['tab']); $queryUpdate = "UPDATE tb_gamelist_sgx SET game_name='$game_name', game_code='$game_code', banner='$banner', provider='$provider', datatype='$datatype', frbavailable='$status', rekomendasi='$populer', poster='$poster', posisi='$posisi', tab='$tab' WHERE id='$id'"; if (mysqli_query($koneksi, $queryUpdate)) { $_SESSION['success'] = "Data game berhasil diperbarui."; echo ''; } else { $_SESSION['error'] = "Gagal memperbarui data game: " . mysqli_error($koneksi); } exit(); } $limit = 50; $page = isset($_POST['page']) ? (int)$_POST['page'] : 1; if ($page < 1) $page = 1; $offset = ($page - 1) * $limit; $search = isset($_POST['search']) ? mysqli_real_escape_string($koneksi, $_POST['search']) : ''; $where = ""; if (!empty($search)) { $search_safe = mysqli_real_escape_string($koneksi, $search); $search_safe = str_replace(['%', '_'], ['\%', '\_'], $search_safe); $where = "WHERE LOWER(game_name) LIKE LOWER('%$search_safe%') OR LOWER(game_code) LIKE LOWER('%$search_safe%') OR LOWER(provider) LIKE LOWER('%$search_safe%')"; } $totalQuery = mysqli_query($koneksi, "SELECT COUNT(*) as total FROM tb_gamelist_sgx $where"); $totalData = mysqli_fetch_assoc($totalQuery)['total']; $totalPages = ceil($totalData / $limit); $query = "SELECT * FROM tb_gamelist_sgx $where ORDER BY id ASC LIMIT $limit OFFSET $offset"; $gamelist = mysqli_query($koneksi, $query); ?>

Game List

Jam
0) { $no = $offset + 1; while ($data = mysqli_fetch_assoc($gamelist)) { $id = $data['id']; $status = $data['frbavailable']; $populer = $data['rekomendasi']; $status_class = ($status == 1) ? 'text-success' : 'text-danger'; ?> <'; } ?>
No. Nama Game Game Code Banner Provider Game Type Status Tab Populer Aksi
Banner
Tidak ada data
1): ?>