alert("Terjadi kesalahan, harap masuk kembali!"); window.location.replace("' . $alamat_admin . 'keluar.php"); '; exit(); } if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'update') { $id = mysqli_real_escape_string($koneksi, $_POST['id']); $provider_name = mysqli_real_escape_string($koneksi, $_POST['provider_name']); $provider_type = mysqli_real_escape_string($koneksi, $_POST['provider_type']); $slug = mysqli_real_escape_string($koneksi, $_POST['slug']); $status = mysqli_real_escape_string($koneksi, $_POST['status']); $provider_image = mysqli_real_escape_string($koneksi, $_POST['provider_image']); $code = mysqli_real_escape_string($koneksi, $_POST['code']); $queryUpdate = " UPDATE tb_provider SET provider_name = '$provider_name', provider_type = '$provider_type', slug = '$slug', status = $status, provider_image = '$provider_image', code = '$code' WHERE id = '$id' "; if (mysqli_query($koneksi, $queryUpdate)) { $_SESSION['success'] = "Data provider berhasil diperbarui."; echo ''; } else { $_SESSION['error'] = "Gagal memperbarui data provider: " . mysqli_error($koneksi); } exit(); } if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'create') { $provider_name = mysqli_real_escape_string($koneksi, $_POST['provider_name']); $provider_type = mysqli_real_escape_string($koneksi, $_POST['provider_type']); $slug = mysqli_real_escape_string($koneksi, $_POST['slug']); $status = (int)$_POST['status']; $provider_image = mysqli_real_escape_string($koneksi, $_POST['provider_image']); $code = mysqli_real_escape_string($koneksi, $_POST['code']); $cek = mysqli_query($koneksi, "SELECT id FROM tb_provider WHERE slug='$slug' LIMIT 1"); if (mysqli_num_rows($cek) > 0) { $_SESSION['error'] = "Slug atau Code sudah digunakan."; echo ''; exit(); } $queryInsert = " INSERT INTO tb_provider (provider_name, provider_type, slug, status, provider_image, code) VALUES ('$provider_name', '$provider_type', '$slug', $status, '$provider_image', '$code') "; if (mysqli_query($koneksi, $queryInsert)) { $_SESSION['success'] = "Provider berhasil ditambahkan."; echo ''; } else { $_SESSION['error'] = "Gagal menambahkan provider: " . mysqli_error($koneksi); echo ''; } exit(); } // === PAGINATION & SEARCH === $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 = str_replace(['%', '_'], ['\%', '\_'], $search); $where = "WHERE LOWER(provider_name) LIKE LOWER('%$search_safe%') OR LOWER(code) LIKE LOWER('%$search_safe%') OR LOWER(slug) LIKE LOWER('%$search_safe%')"; } $totalQuery = mysqli_query($koneksi, "SELECT COUNT(*) as total FROM tb_provider $where"); $totalData = mysqli_fetch_assoc($totalQuery)['total']; $totalPages = ceil($totalData / $limit); $query = "SELECT * FROM tb_provider $where ORDER BY id ASC LIMIT $limit OFFSET $offset"; $providerlist = mysqli_query($koneksi, $query); ?>

Provider List

Jam

0) { $no = $offset + 1; while ($data = mysqli_fetch_assoc($providerlist)) { $id = $data['id']; $status_class = ($data['status'] === 1 || $data['status'] === 0) ? 'text-success' : 'text-danger'; $local_image = "../uploads/provider/slots/" . htmlspecialchars($data['slug']) . ".avif"; $local_image2 = "../uploads/provider/slots/" . htmlspecialchars($data['slug']) . ".webp"; $provider_image = htmlspecialchars($data['provider_image']); if (file_exists($local_image)) { $img_src = $local_image; } else if (file_exists($local_image2)) { $img_src = $local_image2; } else { $img_src = $provider_image; } ?> '; } ?>

No.	Code	Provider Name	Slug	Type	Status	Image	Aksi

Tidak ada data provider ditemukan.

1): ?>