Sun, 30 Oct 2022 16:46:03 +0100
Removed use of obsolete product equipment fields and added the equipment chiller fields. Changed tab 2 of the product view to show the chiller method.
<?php require_once('config.php'); $query = "SELECT record,name,alpha,beta,humulene,caryophyllene,cohumulone,myrcene,hsi,total_oil,type,form,origin,inventory,cost FROM inventory_hops ORDER BY origin,name"; $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); if (! $connect) { echo "[]"; return; } mysqli_set_charset($connect, "utf8" ); $result = mysqli_query($connect, $query); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $hops[] = $row; } header("Content-type: application/json"); echo json_encode($hops);