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