Wed, 19 Dec 2018 21:58:21 +0100
Source waters are fixed, removed grid editor. Redesigned the water screen. Made a simple visual if water treatments are out of range. Water mixer for standard and dillute water works. Swapped the mash and water tabs.
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); |