www/getyeastsources.php@fe9e2a677611 (annotated)
www/getyeastsources.php
Sat, 15 Dec 2018 11:06:14 +0100
- author
- Michiel Broek <mbroek@mbse.eu>
- date
- Sat, 15 Dec 2018 11:06:14 +0100
- changeset 141
- fe9e2a677611
- parent 61
- 3469979f83be
- child 232
- daf2d9d6fa18
- permissions
- -rw-r--r--
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.
| 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); |
