Mercurial > bms / file revision

<?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']
	);
}
header("Content-type: application/json");
echo json_encode($lines);