--- a/www/includes/db_inventory_hops.php Sun Aug 12 23:20:17 2018 +0200
+++ b/www/includes/db_inventory_hops.php Mon Aug 13 15:11:26 2018 +0200
@@ -20,6 +20,7 @@
$sql .= "', caryophyllene='" . $_GET['caryophyllene'];
$sql .= "', cohumulone='" . $_GET['cohumulone'];
$sql .= "', myrcene='" . $_GET['myrcene'];
+ $sql .= "', hsi='" . $_GET['hsi'];
$sql .= "', useat='" . $_GET['useat'];
$sql .= "', type='" . $_GET['type'];
$sql .= "', form='" . $_GET['form'];
@@ -32,6 +33,7 @@
$sql .= "', production_date='" . $_GET['production_date'];
$sql .= "', tht_date='" . $_GET['tht_date'];
$sql .= "', supplier_rec='" . $_GET['supplier_rec'];
+ $sql .= "', total_oil'" . $_GET['total_oil'];
$sql .= "';";
error_log("\"$sql\"");
$result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect));
@@ -47,6 +49,7 @@
$sql .= "', caryophyllene='" . $_GET['caryophyllene'];
$sql .= "', cohumulone='" . $_GET['cohumulone'];
$sql .= "', myrcene='" . $_GET['myrcene'];
+ $sql .= "', hsi='" . $_GET['hsi'];
$sql .= "', useat='" . $_GET['useat'];
$sql .= "', type='" . $_GET['type'];
$sql .= "', form='" . $_GET['form'];
@@ -59,6 +62,7 @@
$sql .= "', production_date='" . $_GET['production_date'];
$sql .= "', tht_date='" . $_GET['tht_date'];
$sql .= "', supplier_rec='" . $_GET['supplier_rec'];
+ $sql .= "', total_oil'" . $_GET['total_oil'];
$sql .= "' WHERE record='" . $_GET['record'] . "';";
error_log("\"$sql\"");
$result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect));
@@ -86,6 +90,7 @@
'caryophyllene' => $row['caryophyllene'],
'cohumulone' => $row['cohumulone'],
'myrcene' => $row['myrcene'],
+ 'hsi' => $row['hsi'],
'useat' => $row['useat'],
'type' => $row['type'],
'form' => $row['form'],
@@ -97,7 +102,8 @@
'cost' => $row['cost'],
'production_date' => $row['production_date'],
'tht_date' => $row['tht_date'],
- 'supplier_rec' => $row['supplier_rec']
+ 'supplier_rec' => $row['supplier_rec'],
+ 'total_oil' => $row['total_oil']
);
}
echo json_encode($hops);