--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/www/getyeastsources.php	Sat Sep 22 19:14:02 2018 +0200
@@ -0,0 +1,26 @@
+<?php
+require_once('config.php');
+
+$query = "SELECT * FROM inventory_yeasts 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)) {
+	$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);