--- a/www/getyeastsources.php Mon Jul 05 20:59:10 2021 +0200
+++ b/www/getyeastsources.php Sun Jul 11 15:55:44 2021 +0200
@@ -1,7 +1,7 @@
<?php
require_once('config.php');
-$query = "SELECT * FROM inventory_yeasts ORDER BY laboratory,product_id,name";
+$query = "SELECT record,name,type,form,laboratory,product_id,min_temperature,max_temperature,flocculation,attenuation,cells,inventory,cost,tolerance,sta1,bacteria,harvest_top,harvest_time,pitch_temperature,pofpos,zymocide,gr_hl_lo,sg_lo,gr_hl_hi,sg_hi FROM inventory_yeasts ORDER BY laboratory,product_id,name";
$connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
if (! $connect) {
echo "[]";
@@ -10,33 +10,7 @@
mysqli_set_charset($connect, "utf8");
$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'],
- 'flocculation' => $row['flocculation'],
- 'attenuation' => $row['attenuation'],
- 'cells' => $row['cells'],
- 'inventory' => $row['inventory'],
- 'cost' => $row['cost'],
- 'tolerance' => $row['tolerance'],
- 'sta1' => $row['sta1'],
- 'bacteria' => $row['bacteria'],
- 'harvest_top' => $row['harvest_top'],
- 'harvest_time' => $row['harvest_time'],
- 'pitch_temperature' => $row['pitch_temperature'],
- 'pofpos' => $row['pofpos'],
- 'zymocide' => $row['zymocide'],
- 'gr_hl_lo' => $row['gr_hl_lo'],
- 'sg_lo' => $row['sg_lo'],
- 'gr_hl_hi' => $row['gr_hl_hi'],
- 'sg_hi' => $row['sg_hi']
- );
+ $yeasts[] = $row;
}
header("Content-type: application/json");
echo json_encode($yeasts);