Mercurial > bms / file revision

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

www/getmiscsources.php@ff45488d480e

www/getmiscsources.php

Sun, 23 Dec 2018 20:13:36 +0100

author

Michiel Broek <mbroek@mbse.eu>

date

Sun, 23 Dec 2018 20:13:36 +0100

changeset 149

ff45488d480e

parent 60

dbbe408108ea

child 296

69fadd1aded2

permissions

-rw-r--r--

Added some icons from Brewersfriend. They should be replaced someday. Added maximum mash weight setting to the equipment database. Usefull for brew automate and RIMS systems. During recipes import acid and base additions are translated. Brews and recipes now have 2 water sources. Added water mixer. Added basic water treatment, but not for pH yet. Redesigned the fermentables and water tabs.

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