www/getfermentablesources.php

changeset 57
bb9a06aa9acd
child 65
5d5c67818d11
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/www/getfermentablesources.php	Thu Sep 20 16:19:09 2018 +0200
@@ -0,0 +1,33 @@
+<?php
+require_once('config.php');
+
+$query = "SELECT * FROM inventory_fermentables 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)) {
+	$fermentables[] = array(
+		'record' => $row['record'],
+		'name' => $row['name'],
+		'type' => $row['type'],
+		'yield' => $row['yield'],
+		'color' => $row['color'],
+		'add_after_boil' => $row['add_after_boil'],
+		'origin' => $row['origin'],
+		'supplier' => $row['supplier'],
+		'coarse_fine_diff' => $row['coarse_fine_diff'],
+		'moisture' => $row['moisture'],
+		'diastatic_power' => $row['diastatic_power'],
+		'protein' => $row['protein'],
+		'max_in_batch' => $row['max_in_batch'],
+		'recommend_mash' => $row['recommend_mash'],
+		'graintype' => $row['graintype'],
+		'di_ph' => $row['di_ph'],
+		'inventory' => $row['inventory'],
+		'cost' => $row['cost']
+	);
+}
+echo json_encode($fermentables);

mercurial