www/getnode.php

Tue, 22 Jan 2019 20:27:45 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Tue, 22 Jan 2019 20:27:45 +0100
changeset 195
2ac491548d8d
parent 180
a5aa3502310c
child 296
69fadd1aded2
permissions
-rw-r--r--

Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.

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 = "'c0c17800-fabb-4f22-a02a-4f83a7b1b21b'";
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
44
6fea20eead56 A small but fatal typo
Michiel Broek <mbroek@mbse.eu>
parents: 43
diff changeset
11 $query = "SELECT * FROM mon_nodes WHERE uuid=".$uuid."";
4
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
12 $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
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 //Copy result into a associative array
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
15 $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
16 if ($resultArray['online'] == 'Y') {
180
a5aa3502310c Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents: 44
diff changeset
17 $resultArray['online'] = 1;
7
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 4
diff changeset
18 } else {
180
a5aa3502310c Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents: 44
diff changeset
19 $resultArray['online'] = 0;
7
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 4
diff changeset
20 }
4
1750b6cae48e Web pages nodes display works.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
21 echo json_encode($resultArray);

mercurial