Mercurial > bms / file revision

<?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);