Mercurial > bms / file revision

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

www/getmiscsources.php@bcc4583fd013

www/getmiscsources.php

Mon, 10 Dec 2018 22:20:19 +0100

author

Michiel Broek <mbroek@mbse.eu>

date

Mon, 10 Dec 2018 22:20:19 +0100

changeset 136

bcc4583fd013

parent 60

dbbe408108ea

child 296

69fadd1aded2

permissions

-rw-r--r--

Fixed estimate FG calculation during recipes import. Added estimate FG calculation in the recipe editor but do not yet update the recipe. Added SVG calculation to the recipes editor. Added calculations for hop aroma and flavour contribution.

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

$query = "SELECT * FROM inventory_miscs ORDER BY 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)) {
	$miscs[] = array(
		'record' => $row['record'],
		'name' => $row['name'],
		'type' => $row['type'],
		'use_use' => $row['use_use'],
		'time' => $row['time'],
		'amount_is_weight' => $row['amount_is_weight'],
		'inventory' => $row['inventory'],
		'cost' => $row['cost']
	);
}
echo json_encode($miscs);