www/includes/global.inc.php

changeset 36
4b829f689d7e
parent 34
a720353fada9
child 39
400aae9fb0c8
equal deleted inserted replaced
35:d6314a95021c 36:4b829f689d7e
90 <ul> 90 <ul>
91 <li>Systemen 91 <li>Systemen
92 <ul> 92 <ul>
93 <?php 93 <?php
94 $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); 94 $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
95 $result = $mysqli->query("SELECT uuid,node,online,net_address FROM nodes"); 95 $result = $mysqli->query("SELECT uuid,node,online,net_address FROM nodes ORDER BY node");
96 while($row = $result->fetch_array(MYSQLI_ASSOC)) { 96 while($row = $result->fetch_array(MYSQLI_ASSOC)) {
97 echo ' <li><a href="mon_node.php?uuid='.$row['uuid'].'">'.$row['node'].'</a></li>'.PHP_EOL; 97 echo ' <li><a href="mon_node.php?uuid='.$row['uuid'].'">'.$row['node'].'</a></li>'.PHP_EOL;
98 } 98 }
99 mysqli_free_result($result); 99 mysqli_free_result($result);
100 ?> 100 ?>
101 </ul> 101 </ul>
102 </li> 102 </li>
103 <li>Klimaatkasten 103 <li>Klimaatkasten
104 <ul> 104 <ul>
105 <?php 105 <?php
106 $result = $mysqli->query("SELECT uuid,node,alias,online,mode FROM fermenters"); 106 $result = $mysqli->query("SELECT uuid,node,alias,online,mode FROM fermenters ORDER BY node,alias");
107 while($row = $result->fetch_array(MYSQLI_ASSOC)) { 107 while($row = $result->fetch_array(MYSQLI_ASSOC)) {
108 echo ' <li><a href="mon_fermenter.php?uuid='.$row['uuid'].'">'.$row['node'].'/'.$row['alias'].'</a></li>'.PHP_EOL; 108 echo ' <li><a href="mon_fermenter.php?uuid='.$row['uuid'].'">'.$row['node'].'/'.$row['alias'].'</a></li>'.PHP_EOL;
109 } 109 }
110 mysqli_free_result($result); 110 mysqli_free_result($result);
111 ?> 111 ?>

mercurial