} else {
$sql = "SELECT id FROM qz_kategori ORDER BY RAND();";
}
$result = connectDB()->query($sql);
/*if (@!$_GET['svar'] == 1) {
echo '<a href="?svar=1">Fasit</a>';
}
else {
echo '<a href="">Tilbake</a>';
}*/
if ($result->num_rows > 0) {
echo '<form action="" method="POST">';
// output data of each row
while ($row = $result->fetch_assoc()) {
$kategoriID = $row["id"];
echo "<h3>" . HentKategorinavnFraKategoriID($kategoriID) . "</h3>";
$sql2 = "SELECT * FROM qz_sporsmaal WHERE kategoriID = '{$kategoriID}' ORDER BY RAND() LIMIT " . $totalt_antall_sporsmaal_per_kategori . ";";
$result2 = connectDB()->query($sql2);
if ($result2->num_rows > 0) {
// output data of each row
while ($row2 = $result2->fetch_assoc()) {
$sporsmaalID = $row2["id"];
echo "<br><h4><strong>" . HentSporsmaalFraSporsmaalID($sporsmaalID) . "</strong></h4>";
echo '<input type="hidden" name="sporsmaalID[]" value="' . $sporsmaalID . '">';
// Spørsmål ID
$sql3 = "SELECT * FROM qz_svar WHERE sporsmaalID = '{$sporsmaalID}' ORDER BY RAND();";
$result3 = connectDB()->query($sql3);
if ($result3->num_rows > 0) {
// output data of each row
while ($row3 = $result3->fetch_assoc()) {
$svarID = $row3["id"];
<h2>Legg til svaralternativ:</h2>
<form action="" method="POST">
Spørsmål:
<select name="spørsmålID" required>
<?php
connectDB();
$sql = "SELECT * FROM qz_sporsmaal GROUP BY kategoriID;";
$result = connectDB()->query($sql);
if ($result->num_rows > 0) {
echo '<option selected disabled>Velg spørsmål</option>';
// output data of each row
while ($row = $result->fetch_assoc()) {
$kategoriID = $row["kategoriID"];
$sql2 = "SELECT * FROM qz_sporsmaal WHERE kategoriID = '{$kategoriID}';";
$result2 = connectDB()->query($sql2);
echo '<optgroup label="' . HentKategorinavnFraKategoriID($kategoriID) . '">';
if ($result2->num_rows > 0) {
while ($row2 = $result2->fetch_assoc()) {
$id2 = utf8_encode($row2["id"]);
$sporsmaal2 = utf8_encode($row2["sporsmaal"]);
echo "<option value=" . $id2 . ">" . $sporsmaal2 . "</option>";
}
}
echo '</optgroup>';
}
} else {
echo "<option selected disabled>Ingen spørsmål</option>";
}
connectDB()->close();
?>
</select>
