--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/www/getbrewlog.php Mon Feb 25 22:49:22 2019 +0100 @@ -0,0 +1,36 @@ +<?php + +require_once('config.php'); + +if (isset($_GET["code"])) + $code = $_GET["code"]; +else + $code = "CB0011"; + +$connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); +if (! $connect) { + die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); +} +mysqli_set_charset($connect, "utf8" ); + +$query = "SELECT * FROM log_brews WHERE product_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'], + 'event' => $row['event'] + ); +} + +echo json_encode($lines);