Mon, 31 Dec 2018 16:48:56 +0100
Added more information on the brewday tab. Move almost all screen init widgets in the source so they are in the Tabs order. This should make searching for them easier.
61 | 1 | <?php |
2 | require_once('config.php'); | |
3 | ||
141
fe9e2a677611
The yeast droplist sorting order changed. Misc ingredients time editor uses minutes or days depending on the use of the ingredient. The yeast editor can now use grams, ml or packs.
Michiel Broek <mbroek@mbse.eu>
parents:
61
diff
changeset
|
4 | $query = "SELECT * FROM inventory_yeasts ORDER BY laboratory,product_id,name"; |
61 | 5 | $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
6 | if (! $connect) { | |
7 | echo "[]"; | |
8 | return; | |
9 | } | |
10 | $result = mysqli_query($connect, $query); | |
11 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
12 | $yeasts[] = array( | |
13 | 'record' => $row['record'], | |
14 | 'name' => $row['name'], | |
15 | 'type' => $row['type'], | |
16 | 'form' => $row['form'], | |
17 | 'laboratory' => $row['laboratory'], | |
18 | 'product_id' => $row['product_id'], | |
19 | 'min_temperature' => $row['min_temperature'], | |
20 | 'max_temperature' => $row['max_temperature'], | |
21 | 'attenuation' => $row['attenuation'], | |
22 | 'inventory' => $row['inventory'], | |
23 | 'cost' => $row['cost'] | |
24 | ); | |
25 | } | |
26 | echo json_encode($yeasts); |