Mon, 25 Feb 2019 22:53:41 +0100
Forgot one file in the install list
<?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);