--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/www/getfermentlog.php Sat Jan 05 17:10:39 2019 +0100 @@ -0,0 +1,30 @@ +<?php + +require_once('config.php'); + +if (isset($_GET["code"])) + $code = $_GET["code"]; +else + $code = "CB0068"; + +$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."'"; +$connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); +if (! $connect) { + echo "[]"; + return; +} +$result = mysqli_query($connect, $query); +while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { + $logs[] = array( + 'date' => $row['datetime'], + 'air' => $row['temperature_air'], + 'beer' => $row['temperature_beer'], + 'chiller' => $row['temperature_chiller'], + 'room' => $row['temperature_room'], + 'tlo' => $row['target_low'], + 'thi' => $row['target_high'], + 'heater' => $row['heater_power'], + 'cooler' => $row['cooler_power'] + ); +} +echo json_encode($logs);