www/getfermenters.php

changeset 7
59048cd5f00d
parent 2
282e7d2bb28a
equal deleted inserted replaced
6:366f270a2446 7:59048cd5f00d
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);

mercurial