www/getyeastsources.php

Sat, 15 Dec 2018 11:06:14 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Sat, 15 Dec 2018 11:06:14 +0100
changeset 141
fe9e2a677611
parent 61
3469979f83be
child 232
daf2d9d6fa18
permissions
-rw-r--r--

The yeast droplist sorting order changed. Misc ingredients time editor uses minutes or days depending on the use of the ingredient. The yeast editor can now use grams, ml or packs.

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

mercurial