comparison: www/includes/global.inc.php
www/includes/global.inc.php
- changeset 48
- bdd1ec9b9c06
- parent 46
- ff9be9dbcac0
- child 50
- 6d94167c2697
equal
deleted
inserted
replaced
| 47:94cd5ac04b6a | 48:bdd1ec9b9c06 |
|---|---|
| 91 <li>Monitoren | 91 <li>Monitoren |
| 92 <ul> | 92 <ul> |
| 93 <li>Systemen | 93 <li>Systemen |
| 94 <ul> | 94 <ul> |
| 95 <?php | 95 <?php |
| 96 $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); | 96 $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
| 97 $result = $mysqli->query("SELECT uuid,node,online,net_address FROM mon_nodes ORDER BY node"); | 97 $result = mysqli_query($connect, "SELECT uuid,node,online,net_address FROM mon_nodes ORDER BY node"); |
| 98 while($row = $result->fetch_array(MYSQLI_ASSOC)) { | 98 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 99 echo ' <li><a href="mon_node.php?uuid='.$row['uuid'].'">'.$row['node'].'</a></li>'.PHP_EOL; | 99 echo ' <li><a href="mon_node.php?uuid='.$row['uuid'].'">'.$row['node'].'</a></li>'.PHP_EOL; |
| 100 } | 100 } |
| 101 mysqli_free_result($result); | 101 mysqli_free_result($result); |
| 102 ?> | 102 ?> |
| 103 </ul> | 103 </ul> |
| 104 </li> | 104 </li> |
| 105 <li>Klimaatkasten | 105 <li>Klimaatkasten |
| 106 <ul> | 106 <ul> |
| 107 <?php | 107 <?php |
| 108 $result = $mysqli->query("SELECT uuid,node,alias,online,mode FROM mon_fermenters ORDER BY node,alias"); | 108 $result = mysqli_query($connect, "SELECT uuid,node,alias,online,mode FROM mon_fermenters ORDER BY node,alias"); |
| 109 while($row = $result->fetch_array(MYSQLI_ASSOC)) { | 109 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 110 echo ' <li><a href="mon_fermenter.php?uuid='.$row['uuid'].'">'.$row['node'].'/'.$row['alias'].'</a></li>'.PHP_EOL; | 110 echo ' <li><a href="mon_fermenter.php?uuid='.$row['uuid'].'">'.$row['node'].'/'.$row['alias'].'</a></li>'.PHP_EOL; |
| 111 } | 111 } |
| 112 mysqli_free_result($result); | 112 mysqli_free_result($result); |
| 113 ?> | 113 ?> |
| 114 </ul> | 114 </ul> |
| 116 </ul> | 116 </ul> |
| 117 </li> | 117 </li> |
| 118 <li>Productie | 118 <li>Productie |
| 119 </li> | 119 </li> |
| 120 <li>Recepten | 120 <li>Recepten |
| 121 <ul> | |
| 122 <?php | |
| 123 $result = mysqli_query($connect, "SELECT DISTINCT style_guide FROM recipes ORDER BY style_guide"); | |
| 124 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
| 125 $guide = $row['style_guide']; | |
| 126 echo ' <li>' . $guide . PHP_EOL; | |
| 127 echo ' <ul>'.PHP_EOL; | |
| 128 $result2 = mysqli_query($connect, "SELECT DISTINCT style_letter FROM recipes WHERE style_guide='".$guide."' ORDER BY style_letter"); | |
| 129 while($row2 = mysqli_fetch_array($result2, MYSQLI_ASSOC)) { | |
| 130 $letter = $row2['style_letter']; | |
| 131 echo ' <li>' . $letter . PHP_EOL; | |
| 132 echo ' <ul>'.PHP_EOL; | |
| 133 $result3 = mysqli_query($connect, "SELECT DISTINCT style_name FROM recipes WHERE style_guide='".$guide."' and style_letter='".$letter."' ORDER BY style_name"); | |
| 134 while ($row3 = mysqli_fetch_array($result3, MYSQLI_ASSOC)) { | |
| 135 $name = $row3['style_name']; | |
| 136 echo ' <li>' . $name . PHP_EOL; | |
| 137 echo ' <ul>'.PHP_EOL; | |
| 138 $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"); | |
| 139 while ($row4 = mysqli_fetch_array($result4, MYSQLI_ASSOC)) { | |
| 140 echo ' <li><a href="recipe.php?record='.$row4['record'].'">' . $row4['name'] . '</a></li>' . PHP_EOL; | |
| 141 } | |
| 142 mysqli_free_result($result4); | |
| 143 echo ' </ul>'.PHP_EOL; | |
| 144 echo ' </li>' . PHP_EOL; | |
| 145 } | |
| 146 mysqli_free_result($result3); | |
| 147 echo ' </ul>'.PHP_EOL; | |
| 148 echo ' </li>'.PHP_EOL; | |
| 149 } | |
| 150 mysqli_free_result($result2); | |
| 151 echo ' </ul>'.PHP_EOL; | |
| 152 echo ' </li>'.PHP_EOL; | |
| 153 } | |
| 154 mysqli_free_result($result); | |
| 155 ?> | |
| 156 <li>Nieuw</li> | |
| 157 </ul> | |
| 121 </li> | 158 </li> |
| 122 <li>Inventaris | 159 <li>Inventaris |
| 123 <ul> | 160 <ul> |
| 124 <li><a href="inv_suppliers.php">Leveranciers</a></li> | 161 <li><a href="inv_suppliers.php">Leveranciers</a></li> |
| 125 <li><a href="inv_fermentables.php">Vergistbare ingredienten</a></li> | 162 <li><a href="inv_fermentables.php">Vergistbare ingredienten</a></li> |
