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
startsida.php
97 lines ASCII Windows (CRLF)
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697
<?php
/** @var PDO $dbconn */
include ("start.php");
?>
<!-- Lista av alla quiz -->
<ol id="games"><strong>Games</strong>
<?php
$sql = "SELECT * FROM JassGames";
$stmt = $dbconn->prepare($sql);
$data = array();
$stmt->execute($data);
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$id = $res["gameid"];
$players = 0;
$maxplayers = $res["maxplayers"];
echo "<li><a target='_blank' href='playquiz.php?quizId=$id'>$players / $maxplayers</a></li>";
}
?>
</ol>
<form id="createGame" method="post">
<h1>Create Game</h1>
<label for="maxplayers">Max Players</label>
<select name="maxplayers" id="maxplayers">
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
</select>
<br>
<label for="isprivate">Private game</label>
<input type="checkbox" id="isprivate" name="isprivate">
<br>
<input type="submit" value="Create Game">
</form>
<?php
if (isset($_POST["maxplayers"])) {
$maxplayers = $_POST["maxplayers"];
$isprivate = 0;
if ($_POST["isprivate"] = "on") {
$isprivate = 1;
}
$ownerid = $_COOKIE["playerid"];
$code = rand(0, 999999);
$sql = "INSERT INTO JassGames (maxplayers, isprivate, ownerid, code)
VALUES (?, ?, ?, ?)";
$stmt = $dbconn->prepare($sql);
$data = array($maxplayers, $isprivate, $ownerid, $code);
$stmt->execute($data);
$gameid = $dbconn->lastInsertId();
$sql = "INSERT INTO GamePlayers (playerid, gameid)
VALUES (?, ?)";
$stmt = $dbconn->prepare($sql);
$data = array($playerid, $gameid);
$stmt->execute($data);
}
$sql = "SELECT gameid FROM JassPlayers WHERE playerid=?";
$stmt = $dbconn->prepare($sql);
$data = array($_POST["playerid"]);
$stmt->execute($data);
$res = $stmt->fetch(PDO::FETCH_ASSOC);
$sql = "SELECT code FROM JassGames WHERE gameid=?";
$stmt = $dbconn->prepare($sql);
$data = array($res["gameid"]);
$stmt->execute($data);
$res = $stmt->fetch(PDO::FETCH_ASSOC);
echo $res["code"];
?>
</body>
</html>