Fri, 13 Dec 2019 16:49:50 +0100
Initial code for iSpindel support in the daemon
<?php require_once('config.php'); $query = "SELECT * FROM inventory_hops ORDER BY origin,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)) { $hops[] = array( 'record' => $row['record'], 'name' => $row['name'], 'alpha' => $row['alpha'], 'beta' => $row['beta'], 'humulene' => $row['humulene'], 'caryophyllene' => $row['caryophyllene'], 'cohumulone' => $row['cohumulone'], 'myrcene' => $row['myrcene'], 'hsi' => $row['hsi'], 'total_oil' => $row['total_oil'], 'type' => $row['type'], 'form' => $row['form'], 'origin' => $row['origin'], 'inventory' => $row['inventory'], 'cost' => $row['cost'] ); } header("Content-type: application/json"); echo json_encode($hops);