prepare($sql); $stmt->bind_param('i', $id); $stmt->execute(); $stmt->store_result(); $stmt->bind_result($id, $username, $password, $email, $full_name, $role); $stmt->fetch(); } else { die('404 Oops!!!'); } $error = false; /** * Update Command */ if (isset($_POST['btnEdit'])) { $newusername = $_POST['username']; $newfullname = $_POST['full_name']; $newpassword = trim($_POST['password']); $newrepassword = trim($_POST['repassword']); $newemail = $_POST['email']; //$newrole = $_POST['role'] ? : '102'; $newrole = $_POST['role']; if (strlen($newusername) < 3) { $error[] = 'Username is too short!'; } if (empty($newfullname)) { $error[] = 'Full name can not be empty!'; } if (empty($newpassword)) { $error[] = 'Password can not be empty!'; } if ($newpassword != $newrepassword) { $error[] = 'Password does not match!'; } $newpassword = hash('sha256', $newusername.$newpassword); if (filter_var($newemail, FILTER_VALIDATE_EMAIL) === FALSE) { $error[] = 'Email is not valid!'; } if (! $error) { $sql = "UPDATE tbl_admin SET username = ?, password = ?, email = ?, full_name = ?, user_role = ? WHERE id = ?"; $update = $connect->prepare($sql); $update->bind_param( 'sssssi', $newusername, $newpassword, $newemail, $newfullname, $newrole, $id ); $update->execute(); $succes =<< alert('Update User Success'); window.location = 'edit-member.php?id=$id'; EOF; echo $succes; } } ?>

EDIT ADMINISTRATOR

'. implode('
', $error) . '
' : '';?>
Username
Full Name
Email