www/getfermenter.php

Wed, 29 Aug 2018 14:44:12 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Wed, 29 Aug 2018 14:44:12 +0200
changeset 43
dcb9ff8846fa
parent 7
59048cd5f00d
child 180
a5aa3502310c
permissions
-rw-r--r--

Renamed monitor database tables

4
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
1 <?php
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
2
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
3 require_once('config.php');
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
4
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
5 if (isset($_GET["uuid"]))
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
6 $uuid = $_GET["uuid"];
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
7 else
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
8 $uuid = "'ef166f25-1bb4-4bef-b112-a867af77f766'";
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
9
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
10
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
11 $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
43
dcb9ff8846fa Renamed monitor database tables
Michiel Broek <mbroek@mbse.eu>
parents: 7
diff changeset
12 $query = "SELECT * FROM mon_fermenters WHERE uuid=".$uuid."";
4
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
13 $result = $mysqli->query($query);
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
14 $resultArray = $result->fetch_array(MYSQLI_ASSOC);
7
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 4
diff changeset
15 if ($resultArray['online'] == 'Y') {
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 4
diff changeset
16 $resultArray['online'] = true;
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 4
diff changeset
17 } else {
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 4
diff changeset
18 $resultArray['online'] = false;
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 4
diff changeset
19 }
4
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
20 echo json_encode($resultArray);

mercurial