diff -r 94cd5ac04b6a -r bdd1ec9b9c06 www/includes/global.inc.php
--- 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 @@
Systemen
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 ' - '.$row['node'].'
'.PHP_EOL;
}
mysqli_free_result($result);
@@ -105,8 +105,8 @@
- Klimaatkasten
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 ' - '.$row['node'].'/'.$row['alias'].'
'.PHP_EOL;
}
mysqli_free_result($result);
@@ -118,6 +118,43 @@
- Productie
- Recepten
+
+' . $guide . PHP_EOL;
+ echo ' '.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 ' - ' . $letter . PHP_EOL;
+ echo '
'.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 ' - ' . $name . PHP_EOL;
+ echo '
'.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 ' - ' . $row4['name'] . '
' . PHP_EOL;
+ }
+ mysqli_free_result($result4);
+ echo '
'.PHP_EOL;
+ echo ' ' . PHP_EOL;
+ }
+ mysqli_free_result($result3);
+ echo '
'.PHP_EOL;
+ echo ' '.PHP_EOL;
+ }
+ mysqli_free_result($result2);
+ echo '
'.PHP_EOL;
+ echo '
'.PHP_EOL;
+}
+mysqli_free_result($result);
+?>
+ - Nieuw
+
- Inventaris