<!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>