www/gethopsources.php

Fri, 30 Nov 2018 17:40:39 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Fri, 30 Nov 2018 17:40:39 +0100
changeset 116
ac993ef43b13
parent 69
ca25fdce3b85
child 219
4c21eabb3c0e
permissions
-rw-r--r--

Removed all calculations from the equipemnts database script and added missing fields. Added missing fields to the inventory equipemnts edit screen. Added conditional batch size calculation to the equipments editor. Added specific heat settings to the equipments editor.

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

mercurial