getConnection();
// CREATE
if (isset($_POST['create'])) {
$username = trim($_POST['username']);
$password = password_hash(trim($_POST['password']), PASSWORD_BCRYPT);
$role = $_POST['role'];
$stmt = $conn->prepare("INSERT INTO users (username, password, role) VALUES (?, ?, ?)");
$stmt->execute([$username, $password, $role]);
header("Location: manajemen_users.php");
exit;
}
// UPDATE
if (isset($_POST['update'])) {
$id = $_POST['id'];
$username = trim($_POST['username']);
$role = $_POST['role'];
if (!empty($_POST['password'])) {
$password = password_hash(trim($_POST['password']), PASSWORD_BCRYPT);
$stmt = $conn->prepare("UPDATE users SET username=?, password=?, role=? WHERE id=?");
$stmt->execute([$username, $password, $role, $id]);
} else {
$stmt = $conn->prepare("UPDATE users SET username=?, role=? WHERE id=?");
$stmt->execute([$username, $role, $id]);
}
header("Location: manajemen_users.php");
exit;
}
// DELETE
if (isset($_GET['delete'])) {
$id = $_GET['delete'];
$stmt = $conn->prepare("DELETE FROM users WHERE id=?");
$stmt->execute([$id]);
header("Location: manajemen_users.php");
exit;
}
// READ
$stmt = $conn->query("SELECT * FROM users");
$users = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
Manajemen Users - FTTH Megadata
👥 Manajemen Users
| ID |
Username |
Role |
Aksi |
|
|
|
Hapus
|