1 <?php |
1 <?php |
2 |
|
3 require_once('config.php'); |
2 require_once('config.php'); |
4 |
|
5 $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
3 $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
6 $result = $mysqli->query("SELECT uuid,node,alias,online,mode FROM fermenters"); |
4 $result = $mysqli->query("SELECT uuid,node,alias,online,mode FROM fermenters"); |
7 //Copy result into a associative array |
5 while($row = $result->fetch_array(MYSQLI_ASSOC)) { |
8 $resultArray = $result->fetch_all(MYSQLI_ASSOC); |
6 if ($row['online'] == 'Y') |
|
7 $row['online'] = true; |
|
8 else |
|
9 $row['online'] = false; |
|
10 $resultArray[] = $row; |
|
11 } |
9 echo json_encode($resultArray); |
12 echo json_encode($resultArray); |