Mercurial > bms / file revision

• file
• latest
• revisions
• annotate
• diff
• comparison
• raw

www/getfermenters.php@59048cd5f00d

www/getfermenters.php

Fri, 10 Aug 2018 21:22:09 +0200

author

Michiel Broek <mbroek@mbse.eu>

date

Fri, 10 Aug 2018 21:22:09 +0200

changeset 7

59048cd5f00d

parent 2

282e7d2bb28a

permissions

-rw-r--r--

Fixes boolean values and only display valid fields in node view.

<?php
require_once('config.php');
$mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
$result = $mysqli->query("SELECT uuid,node,alias,online,mode FROM fermenters");
while($row = $result->fetch_array(MYSQLI_ASSOC)) {
  if ($row['online'] == 'Y')
    $row['online'] = true;
  else
    $row['online'] = false;
  $resultArray[] = $row;
}
echo json_encode($resultArray);