www/getyeastsources.php@ac993ef43b13 (annotated)
www/getyeastsources.php
Fri, 30 Nov 2018 17:40:39 +0100
- author
- Michiel Broek <mbroek@mbse.eu>
- date
- Fri, 30 Nov 2018 17:40:39 +0100
- changeset 116
- ac993ef43b13
- parent 61
- 3469979f83be
- child 141
- fe9e2a677611
- permissions
- -rw-r--r--
Removed all calculations from the equipemnts database script and added missing fields. Added missing fields to the inventory equipemnts edit screen. Added conditional batch size calculation to the equipments editor. Added specific heat settings to the equipments editor.
| 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); |
