prepare("SELECT id FROM users WHERE username = ?"); $cek->bind_param("s", $username); $cek->execute(); $cek->store_result(); if ($cek->num_rows > 0) { $error = "Username $username sudah digunakan."; } else { $hash = password_hash($password, PASSWORD_DEFAULT); $stmt = $conn->prepare("INSERT INTO users (nama, username, password, role) VALUES (?, ?, ?, ?)"); $stmt->bind_param("ssss", $nama, $username, $hash, $role); if ($stmt->execute()) { $success = "User $username berhasil ditambahkan."; } else { $error = "Gagal menyimpan user: " . $stmt->error; } $stmt->close(); } $cek->close(); } } // --- HAPUS USER --- if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'hapus') { $id = (int) $_POST['id']; if ($id === (int) $_SESSION['user']) { $error = "Tidak bisa menghapus akun yang sedang aktif."; } else { $stmt = $conn->prepare("DELETE FROM users WHERE id = ?"); $stmt->bind_param("i", $id); if ($stmt->execute()) { $success = "User berhasil dihapus."; } else { $error = "Gagal menghapus user."; } $stmt->close(); } } $users = $conn->query("SELECT id, nama, username, role, created_at FROM users ORDER BY created_at DESC"); $conn->close(); ?> Kelola User - Sistem Pemetaan
Daftar User
fetch_assoc()): ?>
# Nama Username Role Dibuat Aksi
Anda
Tambah User Baru