294 lines
9.5 KiB
PHP
294 lines
9.5 KiB
PHP
<!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>
|