Show sourcecode
The following files exists in this folder. Click to view.
webbsrvprg/exercises/databaser/ovn_2/
admin.php
forminclude.php
index.php
welcome.php
forminclude.php
35 lines UTF-8 Windows (CRLF)
<!--Behöver $userId och $dbconn definerat redan-->
<form method="get">
<fieldset>
<?php
if ($userId != "new") {
/** @var PDO $dbconn */
try {
$sql = "SELECT * FROM users WHERE id = ?";
$stmt = $dbconn->prepare($sql);
$stmt->execute(array($userId));
$info = $stmt->fetch(PDO::FETCH_ASSOC);
echo ("<legend>$userId</legend>");
echo('<input type="text" name="f_name" id="f_name" value=' . $info["f_name"] . '><label for="f_name">Förnamn</label><br>
<input type="text" name="s_name" id="s_name" value=' . $info["s_name"] . '><label for="s_name">Efternamn</label><br>
<input type="text" name="username" id="username" value=' . $info["username"] . '><label for="username">Användarnamn</label><br>
<input type="text" name="pass" id="pass" value=' . $info["pass"] . '><label for="pass">Lösenord</label><br>
<input type="text" name="role" id="role" value=' . $info["role"] . '><label for="role">Roll (vanlig eller admin)</label><br>');
echo('<label for="deleteUser">Ta bort användaren</label><input type="checkbox" name="deleteUser" id="deleteUser"> <br>');
echo('<input type="hidden" name="action" value="change"><input type="hidden" name="execId" value="' . $userId . '">
<button type=submit>Utför åtgärd</button>');
} catch (PDOException $e) {
echo ($e->getMessage());
}
} else{
echo ('<input type="text" name="f_name" id="f_name" required><label for="f_name">Förnamn</label><br>
<input type="text" name="s_name" id="s_name" required><label for="s_name">Efternamn</label><br>
<input type="text" name="username" id="username" required><label for="username">Användarnamn</label><br>
<input type="text" name="pass" id="pass" required><label for="pass">Lösenord</label><br>
<input type="text" name="role" id="role" required><label for="role">Roll (vanlig eller admin)</label><br>
<input type="hidden" name="action" value="add">
<button type="submit">Lägg till användare</button');
}
?>
</fieldset>
</form>