www/getyeastsources.php@082c23b26055 (annotated)
www/getyeastsources.php
Mon, 12 Nov 2018 16:34:43 +0100
- author
- Michiel Broek <mbroek@mbse.eu>
- date
- Mon, 12 Nov 2018 16:34:43 +0100
- changeset 89
- 082c23b26055
- parent 61
- 3469979f83be
- child 141
- fe9e2a677611
- permissions
- -rw-r--r--
Missing Water agent costs from Brouwhulp import are now added from the imported miscs database. The printed recipe report now calculates the beer color from the ingredients. Also set during recipes import. This will later allow to set the color method for each recipe individually.
| 61 | 1 | <?php |
| 2 | require_once('config.php'); | |
| 3 | ||
| 4 | $query = "SELECT * FROM inventory_yeasts ORDER BY name"; | |
| 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); |
