Show sourcecode
The following files exists in this folder. Click to view.
admin.php
createQuiz.php
createadmin.php
logIn.php
myStats.php
playquiz.php
result.php
scoreboard.php
signIn.php
start.php
startsida.php
stats.php
style.css
tables.php
update.php
createadmin.php
40 lines UTF-8 Windows (CRLF)
<!-- Temprär sida, endast för -->
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Create</title>
</head>
<body>
<?php
/** @var PDO $dbconn */
include ('../dbconnection.php');
try {
// Kollar om det finns ett konto som heter Teo
$sql = "SELECT * FROM quizUsers WHERE username='Teo'";
$stmt = $dbconn->prepare($sql);
$data = array();
$stmt->execute($data);
if (!$stmt->fetch(PDO::FETCH_ASSOC)) {
// Finns det inte ett konto, skapa ett som är en admin
$sql = "INSERT INTO quizUsers (username, password, type)
VALUES (?, ?, ?)";
$stmt = $dbconn->prepare($sql);
$data = array("Teo", htmlspecialchars("Do No Harm"), "admin");
$stmt->execute($data);
}
}
catch (PDOException $e) {
echo $sql . "<br>" . $e->getMessage();
}
?>
</body>
</html>