-
Notifications
You must be signed in to change notification settings - Fork 0
/
relayStatus.php
66 lines (55 loc) · 1.75 KB
/
relayStatus.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
<?php
header("Content-type:application/json");
$_SERVER['CONTENT_TYPE'] = "application/x-www-form-urlencoded";
error_reporting (E_ALL ^ E_WARNING && E_NOTICE);
// Response class
class RelayStatusResponse {
var $successful;
var $roomActive;
var $relaysOn;
function __construct () {
$this->successful = false;
$this->roomActive = false;
$this->relaysOn = 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);
}
$roomID = $_POST['roomID'];
$getRelays = "SELECT relay_used FROM db_classroom_management.tbl_room_status WHERE room_id = $roomID";
$getRelaysResult = mysqli_query($conn, $getRelays);
$relayNo = mysqli_num_rows($getRelaysResult);
// If room status is active...
if ($relayNo > 0) {
$response = new RelayStatusResponse();
$response->successful = true;
$response->roomActive = true;
$row = mysqli_fetch_assoc($getRelaysResult);
$relayString = $row['relay_used'];
while (true) {
$tempRelay = substr($relayString, 0, strpos($relayString, ","));
// Break the loop if the string no longer has a ','
if (!$tempRelay) {
$response->relaysOn[] = $relayString;
break;
}
$relayString = substr($relayString, strpos($relayString, ",")+1);
// Add relay to the array
$response->relaysOn[] = $tempRelay;
}
echo (json_encode($response));
} else {
$response = new RelayStatusResponse();
$response->successful = true;
$response->roomActive = false;
echo (json_encode($response));
}
?>