Källkod
Följande filer och mappar finns under mappen webbserverprogrammering.
Mappar visas till vänster och filer till höger. Klicka på en fil eller mapp för att öppna nedan eller visa dess innehåll.
webbserverprogrammering/exercises/mysql/exercise_2/
11 filer
admin.php
back_button.php
create_table.php
dbconnection.php
delete_row.php
index.php
insert_default_values.php
insert_values.php
print_table.php
start.php
update_values.php
back_button.php
create_table.php
dbconnection.php
delete_row.php
index.php
insert_default_values.php
insert_values.php
print_table.php
start.php
update_values.php
insert_values.php
93 lines UTF-8 Windows (CRLF)
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293
<!DOCTYPE html>
<html lang="sv">
<head>
<title>Lägg till användare</title>
<meta charset="utf-8">
<style type="text/css">
select:required:invalid {
color: #666;
}
option {
color: #000;
}
option[value=""][disabled] {
display: none;
}
</style>
</head>
<body>
<?php
include('back_button.php');
$message = "";
if (isset($_POST['firstname']) && isset($_POST['lastname']) && isset($_POST['username']) && isset($_POST['password']) && isset($_POST["role"])) {
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$username = $_POST['username'];
$password = $_POST['password'];
$role = $_POST["role"];
include ('dbconnection.php');
try {
# prepare
$sql = "INSERT INTO users (firstname, lastname, username, password, role, last_edit) VALUES (?, ?, ?, ?, ?, now())";
$stmt = $dbconn->prepare($sql);
# the data we want to insert
$data = [$firstname, $lastname, $username, $password, $role];
# execute width array-parameter
$stmt->execute($data);
echo "<h3>Användaren lades till.</h3>";
}
catch(PDOException $e)
{
echo "<hr>" . $sql . "<hr>" . $e->getMessage() . "<hr>";
}
$dbconn = null;
} else {
$message = "<h3>Skriv in uppgifter nedan för att lägga till en ny användare:</h3>";
}
echo $message;
?>
<form method="post" action="">
<table>
<tr>
<td>Förnamn:</td>
<td><input type="text" name="firstname" size=20 maxlength=100 required></td>
</tr>
<tr>
<td>Efternamn:</td>
<td><input type="text" name="lastname" size=20 maxlength=100 required></td>
</tr>
<tr>
<td>Användarnamn:</td>
<td><input type="text" name="username" size=20 maxlength=100 required></td>
</tr>
<tr>
<td>Lösenord:</td>
<td><input type="text" name="password" size=20 maxlength="100" required></td>
</tr>
<tr>
<td>Roll:</td>
<td>
<select name="role" required>
<option value="" disabled selected>Välj roll</option>
<option value="admin">admin</option>
<option value="regular">regular</option>
</select>
</td>
</tr>
<tr>
<br>
<td><button type="submit">Lägg till</button></td>
</tr>
</table>
</form>
</body>
</html>