--- a/www/includes/global.inc.php Wed Aug 29 23:13:13 2018 +0200
+++ b/www/includes/global.inc.php Thu Aug 30 22:22:09 2018 +0200
@@ -93,9 +93,9 @@
<li>Systemen
<ul>
<?php
-$mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
-$result = $mysqli->query("SELECT uuid,node,online,net_address FROM mon_nodes ORDER BY node");
-while($row = $result->fetch_array(MYSQLI_ASSOC)) {
+$connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
+$result = mysqli_query($connect, "SELECT uuid,node,online,net_address FROM mon_nodes ORDER BY node");
+while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
echo ' <li><a href="mon_node.php?uuid='.$row['uuid'].'">'.$row['node'].'</a></li>'.PHP_EOL;
}
mysqli_free_result($result);
@@ -105,8 +105,8 @@
<li>Klimaatkasten
<ul>
<?php
-$result = $mysqli->query("SELECT uuid,node,alias,online,mode FROM mon_fermenters ORDER BY node,alias");
-while($row = $result->fetch_array(MYSQLI_ASSOC)) {
+$result = mysqli_query($connect, "SELECT uuid,node,alias,online,mode FROM mon_fermenters ORDER BY node,alias");
+while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
echo ' <li><a href="mon_fermenter.php?uuid='.$row['uuid'].'">'.$row['node'].'/'.$row['alias'].'</a></li>'.PHP_EOL;
}
mysqli_free_result($result);
@@ -118,6 +118,43 @@
<li>Productie
</li>
<li>Recepten
+ <ul>
+<?php
+$result = mysqli_query($connect, "SELECT DISTINCT style_guide FROM recipes ORDER BY style_guide");
+while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
+ $guide = $row['style_guide'];
+ echo ' <li>' . $guide . PHP_EOL;
+ echo ' <ul>'.PHP_EOL;
+ $result2 = mysqli_query($connect, "SELECT DISTINCT style_letter FROM recipes WHERE style_guide='".$guide."' ORDER BY style_letter");
+ while($row2 = mysqli_fetch_array($result2, MYSQLI_ASSOC)) {
+ $letter = $row2['style_letter'];
+ echo ' <li>' . $letter . PHP_EOL;
+ echo ' <ul>'.PHP_EOL;
+ $result3 = mysqli_query($connect, "SELECT DISTINCT style_name FROM recipes WHERE style_guide='".$guide."' and style_letter='".$letter."' ORDER BY style_name");
+ while ($row3 = mysqli_fetch_array($result3, MYSQLI_ASSOC)) {
+ $name = $row3['style_name'];
+ echo ' <li>' . $name . PHP_EOL;
+ echo ' <ul>'.PHP_EOL;
+ $result4 = mysqli_query($connect, "SELECT DISTINCT record,name FROM recipes WHERE style_guide='".$guide."' and style_letter='".$letter."' and style_name='".$name."'ORDER BY name");
+ while ($row4 = mysqli_fetch_array($result4, MYSQLI_ASSOC)) {
+ echo ' <li><a href="recipe.php?record='.$row4['record'].'">' . $row4['name'] . '</a></li>' . PHP_EOL;
+ }
+ mysqli_free_result($result4);
+ echo ' </ul>'.PHP_EOL;
+ echo ' </li>' . PHP_EOL;
+ }
+ mysqli_free_result($result3);
+ echo ' </ul>'.PHP_EOL;
+ echo ' </li>'.PHP_EOL;
+ }
+ mysqli_free_result($result2);
+ echo ' </ul>'.PHP_EOL;
+ echo ' </li>'.PHP_EOL;
+}
+mysqli_free_result($result);
+?>
+ <li>Nieuw</li>
+ </ul>
</li>
<li>Inventaris
<ul>