www/getyeastsources.php

Sat, 02 Feb 2019 14:57:41 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Sat, 02 Feb 2019 14:57:41 +0100
changeset 232
daf2d9d6fa18
parent 141
fe9e2a677611
child 296
69fadd1aded2
permissions
-rw-r--r--

When adding yeast the flocculation and cells fields were not added. Possible fix for double water agents in the miscs grid. Better efforts to set the initial water infuse amount. The new recipe wizzard now uses indexed fields. In recipe print fixed the yeast amount and cost.

<?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'],
		'flocculation' => $row['flocculation'],
		'attenuation' => $row['attenuation'],
		'cells' => $row['cells'],
		'inventory' => $row['inventory'],
		'cost' => $row['cost']
	);
}
echo json_encode($yeasts);

mercurial