www/getnodes.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 2
282e7d2bb28a
permissions
-rw-r--r--

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

2
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
1 <?php
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
2 require_once('config.php');
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
3 $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
4 $result = $mysqli->query("SELECT uuid,node,online,net_address FROM nodes");
7
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
5 while($row = $result->fetch_array(MYSQLI_ASSOC)) {
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
6 if ($row['online'] == 'Y')
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
7 $row['online'] = true;
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
8 else
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
9 $row['online'] = false;
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
10 $resultArray[] = $row;
59048cd5f00d Fixes boolean values and only display valid fields in node view.
Michiel Broek <mbroek@mbse.eu>
parents: 2
diff changeset
11 }
2
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
12 echo json_encode($resultArray);

mercurial