www/getfermentlog.php

changeset 172
684c651dd165
child 179
8adaeecd9dc8
--- /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);

mercurial