www/getnode.php

Wed, 30 Jan 2019 16:40:23 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Wed, 30 Jan 2019 16:40:23 +0100
changeset 221
a8aabb63fbcc
parent 180
a5aa3502310c
child 296
69fadd1aded2
permissions
-rw-r--r--

Added two missing fields in getfermentablesources.php. When getting a single recipe from the database, update the fermentables json data with available inventory and ingredient. Added inventory column in the fermentable grid. Added ingredient selection in the fermentable popup window to replace ingredient.

<?php

require_once('config.php');

if (isset($_GET["uuid"]))
    $uuid = $_GET["uuid"];
else
    $uuid = "'c0c17800-fabb-4f22-a02a-4f83a7b1b21b'";


$query = "SELECT * FROM mon_nodes WHERE uuid=".$uuid."";
$mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
$result = $mysqli->query($query);
//Copy result into a associative array
$resultArray = $result->fetch_array(MYSQLI_ASSOC);
if ($resultArray['online'] == 'Y') {
    $resultArray['online'] = 1;
} else {
    $resultArray['online'] = 0;
}
echo json_encode($resultArray);

mercurial