WebStatus/json.php

46 lines
1.0 KiB
PHP
Raw Permalink Normal View History

<?php
session_start();
include('config.php');
$con = mysqli_connect($config['DBHOST'], $config['DBUSER'], $config['DBPWD'], $config['DBNAME']);
if ( mysqli_connect_errno() ) {
exit('MySQl Connection failed with error: ' . mysqli_connect_error());
}
$status = mysqli_query($con, "SELECT id,status FROM services ORDER BY priority DESC");
$overall;
$jsonObj = new stdClass();
while($statuses = mysqli_fetch_array($status)){
if(strcmp($statuses['status'], "Offline") == 0) {
$overall = "offline";
} else if((strcmp($statuses['status'], "Maintenance") == 0) && !$overall == "offline"){
$overall = "maintenance";
}
$id = $statuses['id'];
$jsonObj->$id = $statuses['status'];
}
switch($overall) {
case "online":
$jsonObj->overall = "Online";
break;
case "maintenance":
$jsonObj->overall = "Maintenance";
break;
case "offline":
$jsonObj->overall = "Offline";
break;
default:
$jsonObj->overall = "Online";
break;
}
$json = json_encode($jsonObj);
echo $json;
?>