Attendance_System_3.0/statusview.php at master · PSCS-Coding/Attendance_System_3.0 · 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
<?php
require_once("connection.php");
?>
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css">
<title>
Status View
</title>
</head>
<body class="top">
	<div class = "sidebar">
		admin
		<a class= "sidetext" href="admin.php?page=0">Allotted Hours</a>
		<a class= "sidetext" href="admin.php?page=1">Current Events</a>
		<a class= "sidetext" href="admin.php?page=2">Facilitator Edit View</a>
		<a class= "sidetext" href="admin.php?page=3">Group Edit View</a>
		<a class= "sidetext" href="admin.php?page=4">History</a>
		<a class= "sidetext" href="admin.php?page=5">Holidays</a>
		<a class= "sidetext" href="admin.php?page=6">Offsit Locations</a>
		<a class= "sidetext" href="admin.php?page=7">Passwords</a>
		<a class= "sidetext" href="admin.php?page=8">School Hours</a>
		<a class= "sidetext" href="admin.php?page=9">Student Edit View</a>
		front end
		<a class= "sidetext" href="index.php">Front Page</a>
		<a class= "sidetext" href="statusview.php">Status View</a>
	</div>
	<?php
		$query = 'SELECT * FROM current INNER JOIN student_data ON current.student_id = student_data.student_id ORDER BY first_name ASC';
		$current = $db->query($query)->fetch_all($resulttype = MYSQLI_ASSOC);
		$stati = $db->query('SELECT * FROM status_data;')->fetch_all($resulttype = MYSQLI_ASSOC);
		$x = 0;
		$status_id = 0;
		foreach ($stati as &$status) {
			foreach($current as &$value){
				if($value['status_id'] == $status['status_id']){
					if($x == 0){
						echo '<h1>'.ucwords(str_replace('_',' ',$status['status_name'])).'</h1></br>';
						$x++;
					}echo $value['first_name'].' '.$value['last_name'].'</br>';
				}
			}$x = 0;
		}
	?>
</body>
</html>