From 87ffa36c1bfa49259e48d94f09e64f83632f0071 Mon Sep 17 00:00:00 2001 From: Maksymilian Jopek Date: Thu, 13 Apr 2023 15:47:15 +0200 Subject: v1.0.0 --- userEdit.php | 149 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 149 insertions(+) create mode 100644 userEdit.php (limited to 'userEdit.php') diff --git a/userEdit.php b/userEdit.php new file mode 100644 index 0000000..2eca5ff --- /dev/null +++ b/userEdit.php @@ -0,0 +1,149 @@ +setAttribute(PDO::ATTR_EMULATE_PREPARES, false); + + $stmt = $pdo->prepare("SELECT `login` FROM `cms_user` WHERE `login`=:login"); + $stmt->execute(["login" => $login]); + if ($type === "Add" && count($stmt->fetchAll(PDO::FETCH_ASSOC)) !== 0) { + $error = "User with this login already exists!"; + } else { + + if ($type === "Add") + $sql = "INSERT INTO `cms_user`(`login`, `password`, `firstname`, `lastname`, `email`) VALUES (:login, :password, :firstname, :lastname, :email)"; + elseif ($type === "Edit") + $sql = "UPDATE `cms_user` SET `login`= :login, `password`=:password, `firstname`=:firstname, `lastname`=:lastname, `email`=:email WHERE `id`=:id"; + + $stmt = $pdo->prepare($sql); + + if ($type === "Add") { + $stmt->execute([ + "firstname" => $firstname, + "lastname" => $lastname, + "login" => $login, + "email" => $email, + "password" => $password, + ]); + } elseif ($type === "Edit") { + $stmt->execute([ + "firstname" => $firstname, + "lastname" => $lastname, + "login" => $login, + "email" => $email, + "password" => $password, + "id" => $_SESSION["u_Id"], + ]); + } + $_SESSION = array_filter($_SESSION, function ($key) { + return strpos($key, 'u_') !== 0; + }, ARRAY_FILTER_USE_KEY); + header("Location: users.php"); + exit(); + } + } +} + +if ($type === "Remove") { + $id = $_SESSION["u_Id"]; + require_once "dbCredentials.php"; + $pdo = new PDO("mysql:dbname=$dbName;host=localhost;charset=utf8mb4", $dbUser, $dbPassword); + $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); + $stmt = $pdo->prepare("DELETE FROM `cms_user` WHERE `id` = :id"); + $stmt->execute(["id" => $id]); + $_SESSION = array_filter($_SESSION, function ($key) { + return strpos($key, 'u_') !== 0; + }, ARRAY_FILTER_USE_KEY); + header("Location: users.php"); + exit(); +} +$name = $login = $email = $password = $repeatPassword = ""; +if ($type === "Edit") { + $name = $_SESSION["u_Firstname"] . ' ' . $_SESSION["u_Lastname"]; + $login = $_SESSION["u_Login"]; + $email = $_SESSION["u_Email"]; + $password = $_SESSION["u_Password"]; + $repeatedPassword = $_SESSION["u_Password"]; + // unset($_SESSION["uFirstname"], $_SESSION["uLastname"], $_SESSION["uLogin"], $_SESSION["uEmail"], $_SESSION["uPassword"]); +} +?> + + + + + + + + + + + + <?= $type ?> user + + + + + +
+ +
+

user

+
+
+
+
+
+
+
+
+
+
+
+

+ Dodaj"; + else + echo ""; + ?> +


+

+
+
+ + + + \ No newline at end of file -- cgit v1.3.1