Mercurial > bms / file revision

• file
• latest
• revisions
• annotate
• diff
• comparison
• raw

www/gethopsources.php@4c25db9e8102

www/gethopsources.php

Thu, 10 Jan 2019 20:22:06 +0100

author

Michiel Broek <mbroek@mbse.eu>

date

Thu, 10 Jan 2019 20:22:06 +0100

changeset 185

4c25db9e8102

parent 69

ca25fdce3b85

child 219

4c21eabb3c0e

permissions

-rw-r--r--

Added configuration settings for MQTT in config.php. Finished screen box sizes for the fermenters monitor. Select beername and code from the current brew products and send it to the fermenter. Added switch commands to the fermenter. Delay data get from the fermenter after sending any command so there is time to process the commands. Turn switches off when the mode changes. Removed 0.2 degrees setpoint diffs for low and high, the fermenter must deal with it. Prevent turning the heater and cooler together on.

<?php
require_once('config.php');

$query = "SELECT * FROM inventory_hops ORDER BY origin,name";
$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)) {
	$hops[] = array(
		'record' => $row['record'],
		'name' => $row['name'],
		'alpha' => $row['alpha'],
		'beta' => $row['beta'],
		'humulene' => $row['humulene'],
		'caryophyllene' => $row['caryophyllene'],
		'cohumulone' => $row['cohumulone'],
		'myrcene' => $row['myrcene'],
		'hsi' => $row['hsi'],
		'total_oil' => $row['total_oil'],
		'useat' => $row['useat'],
		'type' => $row['type'],
		'form' => $row['form'],
		'origin' => $row['origin'],
		'inventory' => $row['inventory'],
		'cost' => $row['cost']
	);
}
echo json_encode($hops);