Show sourcecode
The following files exists in this folder. Click to view.
access-deneid.png
diagramresultat.php
insert-admin.php
login.php
logout.php
personliga-resultat.php
quiz-sida.php
ransa-quiz-session.php
ransa-skapa-quiz-session.php
resultat.php
session-variabler-unset.php
signin.php
skapa-inloggning-tabell.php
skapa-quiz-tabeller.php
skapa-quiz.php
start.php
tabort-kunder-quiz.php
åtkomst-nekad.php
skapa-quiz-tabeller.php
53 lines UTF-8 Windows (CRLF)
<?php
include('../../dbconnection.php');
try {
// Skapa tabellen "quizer"
$sql = "CREATE TABLE quizer (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
namn VARCHAR(50) NOT NULL,
antalfrågor INT UNSIGNED NOT NULL
)";
$dbconn->exec($sql);
echo "Quizer Table created successfully<br>";
// Skapa tabellen "quizfrågor"
$sql = "CREATE TABLE quizfrågor (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
quizid INT UNSIGNED NOT NULL,
frågatext VARCHAR(255) NOT NULL,
FOREIGN KEY (quizid) REFERENCES quizer(id) ON DELETE CASCADE ON UPDATE CASCADE
)";
$dbconn->exec($sql);
echo "Quizfrågor Table created successfully<br>";
// Skapa tabellen "quizsvar"
$sql = "CREATE TABLE quizsvar (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
frågeid INT UNSIGNED NOT NULL,
svartext VARCHAR(255) NOT NULL,
rättfel BOOLEAN NOT NULL,
FOREIGN KEY (frågeid) REFERENCES quizfrågor(id) ON DELETE CASCADE ON UPDATE CASCADE
)";
$dbconn->exec($sql);
echo "Quizsvar Table created successfully<br>";
// Skapa tabellen "resultat"
$sql = "CREATE TABLE resultat (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
kundid INT UNSIGNED NOT NULL,
quizid INT UNSIGNED NOT NULL,
antalrätt INT UNSIGNED NOT NULL,
FOREIGN KEY (kundid) REFERENCES kunder(id) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (quizid) REFERENCES quizer(id) ON DELETE CASCADE ON UPDATE CASCADE
)";
$dbconn->exec($sql);
echo "Resultat Table created successfully<br>";
} catch (PDOException $e) {
echo "Error: " . $e->getMessage();
}
$dbconn = null;
?>