diff -r c26af32428a4 -r b8c3ca152984 www/includes/db_inventory_hops.php --- 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);