Show sourcecode
The following files exists in this folder. Click to view.
createquiz.php
createtable.php
dbconnection.php
index.php
login.php
myquiz.php
registrera.php
results.php
results2.php
takequiz.php
createtable.php
64 lines ASCII Windows (CRLF)
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Create</title>
</head>
<body>
<?php
include ('dbconnection.php');
try {
$sql = "CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
namn VARCHAR(100),
username VARCHAR(50) UNIQUE,
password VARCHAR(255),
last_login DATETIME
);
CREATE TABLE quiz (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(100),
user_id INT,
FOREIGN KEY (user_id) REFERENCES users(id)
);
CREATE TABLE questions (
id INT AUTO_INCREMENT PRIMARY KEY,
quiz_id INT,
question TEXT,
FOREIGN KEY (quiz_id) REFERENCES quiz(id)
);
CREATE TABLE answers (
id INT AUTO_INCREMENT PRIMARY KEY,
question_id INT,
answer TEXT,
is_correct TINYINT(1),
FOREIGN KEY (question_id) REFERENCES questions(id)
);
CREATE TABLE results (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT,
quiz_id INT,
score INT,
created_at DATETIME
);";
$dbconn->exec($sql);
echo "Table created successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
$dbconn = null;
?>
</body>
</html>