www/getfermenters.php

Sat, 18 Aug 2018 17:31:11 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Sat, 18 Aug 2018 17:31:11 +0200
changeset 23
4b157d7a1cee
parent 7
59048cd5f00d
permissions
-rw-r--r--

Added first part of mash profiles. Steps are in the database but not in the web ui.

2
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
1 <?php
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
2 require_once('config.php');
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
3 $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
4 $result = $mysqli->query("SELECT uuid,node,alias,online,mode FROM fermenters");
7
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
5 while($row = $result->fetch_array(MYSQLI_ASSOC)) {
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
6 if ($row['online'] == 'Y')
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
7 $row['online'] = true;
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
8 else
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
9 $row['online'] = false;
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
10 $resultArray[] = $row;
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
11 }
2
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
12 echo json_encode($resultArray);

mercurial