Mercurial > bms / file revision

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

$query = "SELECT record,name,type,yield,color,add_after_boil,origin,supplier,coarse_fine_diff,moisture,diastatic_power,protein,dissolved_protein,max_in_batch,recommend_mash,graintype,di_ph,acid_to_ph_57,inventory,cost FROM inventory_fermentables ORDER BY supplier,name";
$connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
if (! $connect) {
	echo "[]";
	return;
}
mysqli_set_charset($connect, "utf8");
$result = mysqli_query($connect, $query);
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
	$fermentables[] = $row;
}
header("Content-type: application/json");
echo json_encode($fermentables, JSON_UNESCAPED_UNICODE);