Show sourcecode
The following files exists in this folder. Click to view.
webbserverprogrammering/projekt/quiz/
createtable.php
dbconnection.php
deletepost.php
deletetable.php
insertdefaultposts.php
insertposts.php
leaderboard.php
log_in.php
log_out.php
main.php
question_maker.php
quiz_form.php
quiz_list.php
quiz_maker.php
result.php
selectposts.php
sign_in.php
style.js
updateposts.php
sign_in.php
94 lines UTF-8 Windows (CRLF)
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394
<!-- insertpost.php -->
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Namnlöst dokument</title>
</head>
<body>
<h2>Välkommen till Kits Quiz Sida!</h2>
<hr>
<?php
include ('dbconnection.php');
$message = null;
if (isset($_POST['username']) && isset($_POST['password']) && !empty($_POST['username']) && !empty($_POST['password'])) {
// Hämtar användarnamn och lösenord från formuläret
$username = $_POST['username'];
$password = $_POST['password'];
// Förbereder frågan till databasen
$stmt = $dbconn->prepare("SELECT username FROM quiz_users WHERE username = ?");
$stmt->execute([$username]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);
// Kollar om användaren finns i databasen
if ($user){
// Användaren finns
echo "En användare med samma namn finns redan";
} else {
// Användaren finns inte, skickas till quiz listan
try {
# prepare
$sql = "INSERT INTO quiz_users (username, password, reg_date)
VALUES (?, ?, now())";
$stmt = $dbconn->prepare($sql);
# the data we want to insert
$data = array($username, $password);
# execute width array-parameter
$stmt->execute($data);
echo "Nytt konto tillagt!";
$lastId = $dbconn->lastInsertId();
session_start();
$_SESSION["username"] = $username;
$_SESSION["password"] = $password;
$_SESSION["usertype"] = $usertype;
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
$dbconn = null;
header("Location: quiz_list.php");
}
} else {
$message .= "<br><strong>Skapa konto:</strong><br><br>";
}
echo $message;
?>
<!-- Skapa Konto Ruta -->
<form method="post" action="">
<table>
<tr>
<td>Användarnamn*:</td>
<td><input type="text" name="username" size=40 maxlength=100>
</td>
</tr>
<tr>
<td>Lösenord*:</td>
<td><input type="password" name="password" size=40 maxlength=100></td></tr>
<tr>
<td>* = obligatoriskt</td>
<td><button type="submit">Lägg till konto</button></td></tr>
</table>
</form>
<br>
<!--Tillbaka-->
<hr>
<h4>Tillbaka</h4>
<a href="main.php">Startsida</a>
<br><br>
<a href="log_in.php">Logga in</a>
<br><br>
<a href="leaderboard.php">Leaderboard</a>
<br><br>
<hr>
</body>
</html>