-
Notifications
You must be signed in to change notification settings - Fork 0
/
teacherSchedule.php
128 lines (110 loc) · 3.92 KB
/
teacherSchedule.php
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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?php
header("Content-type:application/json");
$_SERVER['CONTENT_TYPE'] = "application/x-www-form-urlencoded";
error_reporting (E_ALL ^ E_WARNING && E_NOTICE);
// Schedule item class
class ScheduleItem {
var $courseName;
var $teacherID;
var $roomID;
var $courseID;
var $dayOfWeek;
var $slot;
var $classLength;
var $classAttendance;
var $isExtra; // if came from extra schedule table. False if not and True if yes.
}
// Response class
class SchedResponse {
var $scheduleFound;
var $scheduleItems;
function __construct () {
$this->scheduleFound = false;
$this->scheduleItems = array();
}
}
// Connection properties
$servername = "localhost";
$username = "root";
$password = "admin";
// Create connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Extract id and password from GET
$userID = $_POST["userID"];
// Run normal schedule query
$getNormalScheduleQuery = "SELECT * FROM db_classroom_management.view_teacher_normal_schedule where teacher_id=".$userID;
$getNormalScheduleQueryResult = mysqli_query($conn, $getNormalScheduleQuery);
// Handle normal schedule query result
$numberOfRows = mysqli_num_rows($getNormalScheduleQueryResult);
$response = new SchedResponse;
$response->scheduleFound = false;
// Alot the data in response class
if ($numberOfRows >= 1) {
$response->scheduleFound = true;
while ($row = mysqli_fetch_assoc($getNormalScheduleQueryResult)) {
$temp = new ScheduleItem();
$temp->isExtra = false;
$temp->courseName = $row['course_name'];
$temp->teacherID = $row['teacher_id'];
$temp->roomID = $row['room_id'];
$temp->courseID = $row['course_id'];
$temp->dayOfWeek = $row['day_of_week'];
$temp->slot = $row['slot'];
$temp->classLength = $row['class_length'];
$response->scheduleItems[] = $temp;
}
} else {
$response->scheduleFound = false;
}
// Run Extra schedule query
$getExtraScheduleQuery = "SELECT * FROM db_classroom_management.view_teacher_extra_schedule where teacher_id=".$userID;
$getExtraScheduleQueryResult = mysqli_query($conn, $getExtraScheduleQuery);
// Handle Extra schedule query result
$numberOfRows = mysqli_num_rows($getExtraScheduleQueryResult);
// Alot the data in response class
if ($numberOfRows >= 1) {
$response->scheduleFound = true;
while ($row = mysqli_fetch_assoc($getExtraScheduleQueryResult)) {
$temp = new ScheduleItem();
$temp->isExtra = true;
$temp->courseName = $row['course_name'];
$temp->teacherID = $row['teacher_id'];
$temp->roomID = $row['room_id'];
$temp->courseID = $row['course_id'];
$temp->dayOfWeek = $row['day_of_week'];
$temp->slot = $row['slot'];
$temp->classLength = $row['class_length'];
$response->scheduleItems[] = $temp;
}
}
echo json_encode($response);
/*
//Run query for login authorization
$getNormalScheduleQuery = "SELECT * FROM db_classroom_management.view_teacher_schedule where teacher_id=".$userID;
$getNormalScheduleQueryResult = mysqli_query($conn, $getNormalScheduleQuery);
//Handle login authorization response
$numberOfRows = mysqli_num_rows($getNormalScheduleQueryResult);
$response = new SchedResponse;
if ($numberOfRows >= 1) {
$response->scheduleFound = true;
while ($row = mysqli_fetch_assoc($getNormalScheduleQueryResult)) {
$temp = new ScheduleItem();
$temp->courseName = $row['course_name'];
$temp->teacherID = $row['teacher_id'];
$temp->roomID = $row['room_id'];
$temp->courseID = $row['course_id'];
$temp->dayOfWeek = $row['day_of_week'];
$temp->slot = $row['slot'];
$temp->classLength = $row['class_length'];
$response->scheduleItems[] = $temp;
}
} else {
$response->scheduleFound = false;
}
echo json_encode($response);
*/
?>