Mercurial > bms / file revision

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

www/getyeastsources.php@ff45488d480e

www/getyeastsources.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 141

fe9e2a677611

child 232

daf2d9d6fa18

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_yeasts ORDER BY laboratory,product_id,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)) {
	$yeasts[] = array(
		'record' => $row['record'],
		'name' => $row['name'],
		'type' => $row['type'],
		'form' => $row['form'],
		'laboratory' => $row['laboratory'],
		'product_id' => $row['product_id'],
		'min_temperature' => $row['min_temperature'],
		'max_temperature' => $row['max_temperature'],
		'attenuation' => $row['attenuation'],
		'inventory' => $row['inventory'],
		'cost' => $row['cost']
	);
}
echo json_encode($yeasts);