Show sourcecode
The following files exists in this folder. Click to view.
admin.php
confirmSignIn.php
createadmin.php
logIn.php
signIn.php
start.php
startsida.php
style.css
tables.php
update.php
createadmin.php
44 lines UTF-8 Windows (CRLF)
<!-- Temprär sida, endast för att skapa ett första adminkonto -->
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Jass</title>
</head>
<body>
<?php
/** @var PDO $dbconn */
include ('../dbconnection.php');
try {
// Kollar om det finns ett konto som heter Teo
$sql = "SELECT * FROM JassPlayers 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 JassPlayers (username, password, mail, type)
VALUES (?, ?, ?, ?)";
$stmt = $dbconn->prepare($sql);
$name = "Teo";
$pwd = htmlspecialchars("Do No Harm");
$mail = "teorut23@varmdogymnasium.se";
$type = htmlspecialchars("admin");
$data = array($name, $pwd, $mail, $type);
$stmt->execute($data);
}
}
catch (PDOException $e) {
echo $sql . "<br>" . $e->getMessage();
}
?>
</body>
</html>