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
scoreboard.php
104 lines UTF-8 Windows (CRLF)
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104
<?php
/** @var PDO $dbconn */
include ("start.php");
?>
<!-- Formulär för att välja mellan alla quiz eller bara ett -->
<form method="post">
<select name="quiz">
<option>Alla</option>
<?php
/** @var PDO $dbconn */
include ('../dbconnection.php');
// Skriver ut ett alternativ för alla quiz
$sql = "SELECT * FROM quizes";
$stmt = $dbconn->prepare($sql);
$data = array();
$stmt->execute($data);
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo "<option>" . $res["quizname"] . "</option>";
}
?>
</select>
<input type="submit" value="Välj quiz">
</form>
<!-- Länk till startsidan -->
<a href="startsida.php">Startsida</a>
<table class="table">
<tr>
<td>Spelare</td>
<td>Quiz</td>
<td>Resultat</td>
</tr>
<?php
// Om ett quiz har valts(och "alla" inte valts), lägg till en begränsing i sql-koden
// att endast ta resultat från det quizet
$quiz = "";
if (isset($_POST["quiz"])) {
if ($_POST["quiz"] != "Alla") {
$quiz = "WHERE quizname='" . $_POST["quiz"] . "'";
}
}
// Hämta alla resultat, sorterad efter högst score
$sql = "SELECT * FROM results
LEFT JOIN quizUsers ON results.playerId = quizUsers.id
LEFT JOIN quizes ON results.quizId = quizes.id
" . $quiz . "
ORDER BY score DESC, username";
$stmt = $dbconn->prepare($sql);
$data = array();
$stmt->execute($data);
// Skriv ut resultaten i en tabell
echo "<table class='table'><caption>Resultat i rangordning</caption>
<tr>
<td>Spelare</td>
<td>Quiz</td>
<td>Resultat</td>
</tr>";
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo "</tr><td>".$res["username"]."</td>";
echo "<td>".$res["quizname"]."</td>";
echo "<td>".$res["score"]."</td></tr>";
}
echo "<table><br><br>";
// Gör samma sak, men sortera inte resultaten
$sql = "SELECT * FROM results
LEFT JOIN quizUsers ON results.playerId = quizUsers.id
LEFT JOIN quizes ON results.quizId = quizes.id
" . $quiz;
$stmt = $dbconn->prepare($sql);
$data = array();
$stmt->execute($data);
echo "<table class='table'><caption>Osorterade resultat</caption>
<tr>
<td>Spelare</td>
<td>Quiz</td>
<td>Resultat</td>
</tr>";
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo "</tr><td>".$res["username"]."</td>";
echo "<td>".$res["quizname"]."</td>";
echo "<td>".$res["score"]."</td></tr>";
}
echo "<table><br><br>";
?>
</table>
</body>
</html>