www/getfermenters.php

Tue, 07 Aug 2018 16:42:49 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Tue, 07 Aug 2018 16:42:49 +0200
changeset 2
282e7d2bb28a
child 7
59048cd5f00d
permissions
-rw-r--r--

Initial web server

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
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
3 require_once('config.php');
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
4
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
5 $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
6 $result = $mysqli->query("SELECT uuid,node,alias,online,mode FROM fermenters");
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
7 //Copy result into a associative array
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
8 $resultArray = $result->fetch_all(MYSQLI_ASSOC);
282e7d2bb28a Initial web server
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
9 echo json_encode($resultArray);

mercurial