www/getnode.php

Mon, 12 Nov 2018 16:34:43 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Mon, 12 Nov 2018 16:34:43 +0100
changeset 89
082c23b26055
parent 44
6fea20eead56
child 180
a5aa3502310c
permissions
-rw-r--r--

Missing Water agent costs from Brouwhulp import are now added from the imported miscs database. The printed recipe report now calculates the beer color from the ingredients. Also set during recipes import. This will later allow to set the color method for each recipe individually.

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') {
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 4
diff changeset
17 $resultArray['online'] = true;
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 4
diff changeset
18 } else {
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 4
diff changeset
19 $resultArray['online'] = false;
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