www/getnode.php

Fri, 10 Aug 2018 21:22:09 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Fri, 10 Aug 2018 21:22:09 +0200
changeset 7
59048cd5f00d
parent 4
1750b6cae48e
child 43
dcb9ff8846fa
permissions
-rw-r--r--

Fixes boolean values and only display valid fields in node view.

<?php

require_once('config.php');

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


$query = "SELECT * FROM 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'] = true;
} else {
    $resultArray['online'] = false;
}
echo json_encode($resultArray);

mercurial