alert('Akses ditolak'); window.location='../index.php';";
exit;
}
// Handle penghapusan satuan
if (isset($_GET['hapus']) && is_numeric($_GET['hapus'])) {
$id = intval($_GET['hapus']);
mysqli_query($conn, "DELETE FROM buzzer_assignments WHERE id = $id");
echo "";
exit;
}
// Handle penghapusan massal
if (isset($_POST['hapus_semua'])) {
$ids = $_POST['id_data'] ?? [];
foreach ($ids as $id) {
mysqli_query($conn, "DELETE FROM buzzer_assignments WHERE id = " . intval($id));
}
echo "";
exit;
}
// Proses pencarian
$keyword = isset($_GET['q']) ? trim($_GET['q']) : '';
$hasil = [];
if ($keyword !== '') {
$stmt = $conn->prepare("SELECT id, judul_postingan FROM buzzer_assignments WHERE judul_postingan LIKE ?");
$searchTerm = "%" . $keyword . "%";
$stmt->bind_param("s", $searchTerm);
$stmt->execute();
$hasil = $stmt->get_result();
}
?>
Hapus Berdasarkan Judul
🔍 Hapus Data Tugas Berdasarkan Judul