Show sourcecode
The following files exists in this folder. Click to view.
webbserverprogrammering/exercises/quiz/
admin.php
dbconnection.php
glömtLösen.php
index.php
quiz.php
quiz_css.css
rättning.php
skapaTabell.php
verify.php
skapaTabell.php
171 lines UTF-8 Windows (CRLF)
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171
<!-- createtable.php -->
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Create</title>
</head>
<body>
<?php
include ('dbconnection.php');
try {
// sql to delete table
$sql = "DROP TABLE IF EXISTS QUIZResultat";
//use exec() because no results are returned
$dbconn->exec($sql);
echo "Table deleted successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
try {
// sql to delete table
$sql = "DROP TABLE IF EXISTS QUIZAnvändare";
//use exec() because no results are returned
$dbconn->exec($sql);
echo "Table deleted successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
try {
// sql to delete table
$sql = "DROP TABLE IF EXISTS QUIZ";
//use exec() because no results are returned
$dbconn->exec($sql);
echo "Table deleted successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
try {
// sql to delete table
$sql = "DROP TABLE IF EXISTS QUIZFrågor";
//use exec() because no results are returned
$dbconn->exec($sql);
echo "Table deleted successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
try {
// sql to delete table
$sql = "DROP TABLE IF EXISTS QUIZSvar";
//use exec() because no results are returned
$dbconn->exec($sql);
echo "Table deleted successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
try {
// sql to create table
$sql = "CREATE TABLE QUIZAnvändare (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
användarnamn VARCHAR(30) NOT NULL,
epost VARCHAR(40) NOT NULL,
password VARCHAR(255) NOT NULL,
reg_date DATETIME
)";
// use exec() because no results are returned
$dbconn->exec($sql);
echo "AnvTable created successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
try {
// sql to create table
$sql = "CREATE TABLE QUIZResultat (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
användarID INT(6) NOT NULL,
quizID INT(6) NOT NULL,
antalRätt VARCHAR(30),
antalFrågor VARCHAR(30),
tid DATETIME
)";
// use exec() because no results are returned
$dbconn->exec($sql);
echo "ResTable created successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
try {
// sql to create table
$sql = "CREATE TABLE QUIZ (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
namn VARCHAR(50) NOT NULL,
antalFrågor INT(6) NOT NULL
)";
// use exec() because no results are returned
$dbconn->exec($sql);
echo "QuizTable created successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
try {
// sql to create table
$sql = "CREATE TABLE QUIZFrågor (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
fråga VARCHAR(100) NOT NULL,
quizID INT(6) NOT NULL
)";
// use exec() because no results are returned
$dbconn->exec($sql);
echo "QuizTable created successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
try {
// sql to create table
$sql = "CREATE TABLE QUIZSvar (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
frågeID INT(6) NOT NULL,
svar VARCHAR(100) NOT NULL,
rätt TINYINT(1) NOT NULL
)";
// use exec() because no results are returned
$dbconn->exec($sql);
echo "QuizTable created successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
//Rensa kopplingen till databasen
$dbconn = null;
?>
</body>
</html>