<!DOCTYPE html>
<!--
TiTaMa - A TImeTAbleMAnager for the web
MIT LICENSE
2015 (c) Marcel Kapfer (mmk2410) <marcelmichaelkapfer@yahoo.co.nz>
-->
<?php
function getFullDay($day) {
if ($day == "Mon") {
return "Monday";
} else if ($day == "Tue") {
return "Tuesday";
} else if ($day == "Wed") {
return "Wednesday";
} else if ($day == "Thur") {
return "Thursday";
} else if ($day == "Fri") {
return "Friday";
}
}
?>
<html>
<head>
<meta charset="UTF-8">
<title>TiTaMa</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=no" />
<meta name="description" content="A web time table manager">
<meta name="theme-color" content="#3f51b5">
<link rel="manifest" href="manifest.json">
<meta name="msapplication-TileColor" content="#3f51b5">
<meta name="mobile-web-app-capable" content="yes">
<meta name="application-name" content="TiTaMa">
<meta rel="icon" sizes="192x192" href="images/touch/chrome-touch-icon-192x192.png">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta name="apple-mobile-web-app-title" content="TiTaMa">
<link rel="apple-touch-icon" href="images/touch/apple-touch-icon.png">
<meta name="msapplication-TileImage" content="images/touch/ms-touch-icon-144x144.png">
<link href='//fonts.googleapis.com/css?family=Roboto:400,600,300,700' rel='stylesheet' type='text/css'>
<link rel="stylesheet" type="text/css" href="./res/titama.css" />
</head>
<body>
<div class="header">
<span class="title">TiTaMa</span>
</div>
<?php
include './res/php/config.php';
if (isset($_GET['add'])) {
$conn = new mysqli($dbhost, $dbuser, $dbpassword, $dbname);
$name = $_POST['name'];
$kind = $_POST['kind'];
$room = $_POST['room'];
$day = $_POST['day'];
$time = $_POST['time'];
$prof = $_POST['prof'];
if ($conn->error) {
?>
<section class="card">
<div class="headline">Error</div>
<?php
die("Failed to connect to the database: " . $conn->error);
?>
</section>
<?php
}
$sql = "INSERT INTO Titama (name, kind, room, day, time, prof)
VALUES('$name', '$kind', '$room', '$day', '$time', '$prof')";
if ($conn->query($sql) === TRUE) {
?>
<section class="card">
<div class="headline">Success</div>
<?php
echo "The new course was created successfully.";
?>
<br>
<br>
<span id="remove" class="button">OK</span>
</section>
<?php
} else {
?>
<section class="card">
<div class="headline">Error</div>
<?php
echo "Error:" . $sql . "<br>" . $conn->error;
?>
<br>
<br>
<span id="remove" class="button">OK</span>
</section>
<?php
}
}
if (isset($_GET['change'])) {
$conn = new mysqli($dbhost, $dbuser, $dbpassword, $dbname);
$userid = $_POST['userid'];
$name = $_POST['name'];
$kind = $_POST['kind'];
$room = $_POST['room'];
$day = $_POST['day'];
$time = $_POST['time'];
$prof = $_POST['prof'];
if ($conn->error) {
?>
<section class="card">
<div class="headline">Error</div>
<?php
die("Failed to connect to the database: " . $conn->error);
?>
<br>
<br>
<span id="remove" class="button">OK</span>
</section>
<?php
}
$sql = "UPDATE Titama SET name='$name',kind='$kind',room='$room',day='$day',time='$time',prof='$prof' WHERE id=$userid";
if ($conn->query($sql)) {
?>
<section class="card">
<div class="headline">Success</div>
<?php
echo "Course successfully updated";
?>
<br>
<br>
<span id="remove" class="button">OK</span>
</section>
<?php
} else {
?>
<section class="card">
<div class="headline">Error</div>
<?php
echo "Some error occured. SQL: " . $sql . "<br> ERROR: " . $conn->error;
?>
<br>
<br>
<span id="remove" class="button">OK</span>
</section>
<?php
}
}
if (isset($_GET['del'])) {
$userid = $_POST['userid'];
$conn = new mysqli($conn, $dbuser, $dbpassword, $dbname);
if ($conn->error) {
?>
<section class="card">
<div class="headline">Error</div>
<?php
die("Failed to connect to the database: " . $conn->error);
?>
<br>
<br>
<span id="remove" class="button">OK</span>
</section>
<?php
}
$sql = "DELETE FROM Titama WHERE id=$userid";
$results = $conn->query($sql);
if ($conn->query($sql)) {
?>
<section class="card">
<div class="headline">Success</div>
<?php
echo "Course successfully deleted";
?>
<br>
<br>
<span id="remove" class="button">OK</span>
</section>
<?php
} else {
?>
<section class="card">
<div class="headline">Error</div>
<?php
echo "Some error occured. SQL: " . $sql . "<br> ERROR: " . $conn->error;
?>
<br>
<br>
<span id="remove" class="button">OK</span>
</section>
<?php
}
}
$conn = new mysqli($dbhost, $dbuser, $dbpassword, $dbname);
if ($conn->error) {
?>
<section class="card">
<div class="headline">Error</div>
<?php
die("Failed to connect to the database: " . $conn->error);
?>
<br>
<br>
<span id="remove" class="button">OK</span>
</section>
<?php
}
$days = array("Mon", "Tue", "Wed", "Thur", "Fri");
foreach ($days as $day) {
$sql = "SELECT * FROM Titama WHERE day='$day'";
$res = $conn->query($sql);
if ($res->num_rows > 0) {
?>
<section class="card">
<div class="headline"><?php echo getFullDay($day) ?></div>
<?php
$courses = array();
$result = $conn->query($sql);
while ($row = $result->fetch_assoc()) {
$courses[] = $row;
}
usort($courses, function($a, $b) {
return $a["time"] - $b["time"];
});
foreach ($courses as $course) {
?>
<div class="course">
<div class="c_name" id="c_name_<?php echo $course["id"] ?>"><?php echo $course["name"]; ?></div>
<div class="c_time"><?php echo $course["time"]; ?>:00</div>
<div class="c_id">Id: <?php echo $course["id"]; ?></div>
<div class="c_kind">Kind: <?php echo $course["kind"]; ?></div>
<div class="c_place">Place: <?php echo $course["room"]; ?></div>
<div class="c_prof">Prof: <?php echo $course["prof"]; ?></div>
</div>
<?php
}
}
?>
</section>
<?php
}
include './res/php/closedb.php';
?>
<section class="card">
<div class="headline">Add new course</div>
<form action="?add=1" method="post">
<p>Name:</p><input name="name" class="itextfield"/>
<p>Kind:</p><input name="kind" class="itextfield"/>
<p>Room:</p><input name="room" class="itextfield"/>
<p>Day:</p><input name="day" class="itextfield"/>
<p>Starts at:</p><input name="time" class="itextfield"/>
<p>Prof:</p><input name="prof" class="itextfield"/>
<br>
<br>
<input type="submit" class="button" value="ADD"/>
</form>
</section>
<section class="card">
<div class="headline">Change course</div>
<form action="?change=1" method="post">
<p>Course ID:</p><input name="userid" id="change_id" class="itextfield"/>
<div id="noid"></div>
<p>Name:</p><input name="name" id="change_name" class="itextfield"/>
<p>Kind:</p><input name="kind" id="change_kind" class="itextfield"/>
<p>Room:</p><input name="room" id="change_room" class="itextfield"/>
<p>Day:</p><input name="day" id="change_day" class="itextfield"/>
<p>Starts at:</p><input name="time" id="change_time" class="itextfield"/>
<p>Prof:</p><input name="prof" id="change_prof" class="itextfield"/>
<br>
<br>
<input type="submit" class="button" value="CHANGE" />
</form>
</section>
<section class="card">
<div class="headline">Delete course</div>
<form action="?del=1" method="post">
<p>Course ID:</p><input name="userid" class="itextfield"/>
<br>
<br>
<input type="submit" class="button" value="DELETE" />
</form>
</section>
</section>
<div class="footer">Marcel Kapfer (mmk2410) - 2015-2016</div>
<script src="./res/jquery-2.1.4.min.js"></script>
<script src="./res/js/titama.js"></script>
</body>
</html>