www/getfermentlog.php@684c651dd165 (annotated)
www/getfermentlog.php
Sat, 05 Jan 2019 17:10:39 +0100
- author
- Michiel Broek <mbroek@mbse.eu>
- date
- Sat, 05 Jan 2019 17:10:39 +0100
- changeset 172
- 684c651dd165
- child 179
- 8adaeecd9dc8
- permissions
- -rw-r--r--
Added fermentation graph screen
| 172 | 1 | <?php |
| 2 | ||
| 3 | require_once('config.php'); | |
| 4 | ||
| 5 | if (isset($_GET["code"])) | |
| 6 | $code = $_GET["code"]; | |
| 7 | else | |
| 8 | $code = "CB0068"; | |
| 9 | ||
| 10 | $query = "SELECT datetime,temperature_air,temperature_beer,temperature_chiller,temperature_room,target_low,target_high,heater_power,cooler_power FROM log_fermentation WHERE product_code='".$code."'"; | |
| 11 | $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); | |
| 12 | if (! $connect) { | |
| 13 | echo "[]"; | |
| 14 | return; | |
| 15 | } | |
| 16 | $result = mysqli_query($connect, $query); | |
| 17 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
| 18 | $logs[] = array( | |
| 19 | 'date' => $row['datetime'], | |
| 20 | 'air' => $row['temperature_air'], | |
| 21 | 'beer' => $row['temperature_beer'], | |
| 22 | 'chiller' => $row['temperature_chiller'], | |
| 23 | 'room' => $row['temperature_room'], | |
| 24 | 'tlo' => $row['target_low'], | |
| 25 | 'thi' => $row['target_high'], | |
| 26 | 'heater' => $row['heater_power'], | |
| 27 | 'cooler' => $row['cooler_power'] | |
| 28 | ); | |
| 29 | } | |
| 30 | echo json_encode($logs); |
