infra-acedemic/timetable.php at master · deepme987/infra-acedemic · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>Time Table</title>
	<link rel="stylesheet" href="Addons/attendance.css">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">

</head>
<body>
	<p class="patten">Time Table for TE4</p>
    <hr class="hratten">
    <?php

		if (isset($_POST['confirm'])) {add();}

		function add() {

			$user = 'teacher';
			$pass = 'root';
			$db = 'students';

			$conn = new mysqli('localhost', $user, $pass, $db) or die("Unable to connect to server".$db);

			$sql = "INSERT INTO `events`(`id`, `date`, `time`, `venue`, `event_name`,`link`) VALUES (".$_POST['EventId'].",".$_POST['date'].",\"".$_POST['time'].":00\",\"".$_POST['venue']."\",\"".$_POST['EventName']."\",\"".$_POST['link  ']."\")";

			if (mysqli_query($conn, $sql)) {
				echo "Added details, refreshing data...";
                header("refresh:3;url=http://localhost:8080/college-system/home.php?page=events.php");
			}
			else {
				echo "Error: ".mysqli_error($conn);
			}
			mysqli_close($conn);
        }

	?>

	<?php

		$user = 'student';
		$pass = 'sakec';
		$db = 'students';

		$conn = new mysqli('localhost', $user, $pass, $db) or die("Unable to connect to server".$db);

		$get_all = "select * from timetable";

		$data = mysqli_query($conn, $get_all) or die("No records found.");

		echo "<div class=\"table\"><table><tr><th>Time</th><th>Monday</th><th>Tuesday</th><th>Wednesday</th><th>Thursday</th><th>Friday</th>";

		while($row = mysqli_fetch_assoc($data)) {
			echo "<tr><td>".$row["Time"]."</td><td>".$row["Monday"]."</td><td>".$row["Tuesday"]."</td><td>".$row["Wednesday"]."</td><td>".$row["Thursday"]."</td><td>".$row["Friday"]."</td></tr>";
		}
		echo "</table></div>";

		mysqli_close($conn);
	?>
</body>
</html>