www/getbrewlog.php

changeset 297
5e2424bfbc4a
parent 296
69fadd1aded2
--- a/www/getbrewlog.php	Tue Feb 26 16:18:16 2019 +0100
+++ b/www/getbrewlog.php	Wed Feb 27 14:39:25 2019 +0100
@@ -13,22 +13,22 @@
 }
 mysqli_set_charset($connect, "utf8" );
 
-$query = "SELECT * FROM log_brews WHERE product_code='".$code."' ORDER BY datetime;";
+$query = "SELECT * FROM log_brews WHERE code='".$code."' ORDER BY datetime;";
 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
 	$lines[] = array(
 		'record' => $row['record'],
 		'date' => substr($row['datetime'],0,16),
 		'version' => $row['version'],
-		'code' => $row['product_code'],
-		'name' => $row['product_name'],
-		'pv_mlt' => $row['temperature_mlt'],
-		'pv_bk' => $row['temperature_bk'],
-		'pv_hlt' => $row['temperature_hlt'],
-		'pv_room' => $row['temperature_room'],
-		'sp_mlt' => $row['setpoint_mlt'],
-		'sp_bk' => $row['setpoint_bk'],
-		'sp_hlt' => $row['setpoint_hlt'],
+		'code' => $row['code'],
+		'name' => $row['name'],
+		'pv_mlt' => $row['pv_mlt'],
+		'pv_hlt' => $row['pv_hlt'],
+		'pv_room' => $row['pv_room'],
+		'sp_mlt' => $row['sp_mlt'],
+		'sp_hlt' => $row['sp_hlt'],
+		'pwm_mlt' => $row['pwm_mlt'],
+		'pwm_hlt' => $row['pwm_hlt'],
 		'event' => $row['event']
 	);
 }

mercurial