<?= $type ?> user

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