Sat, 01 Dec 2018 22:24:46 +0100
Renamed some fields in prod_main to prevent ambigous names with the join. Delete product also deletes the corresponding recipe. Fixed equipment load and save. Read data from the product main joined with prod_recipes completed. The brewday page is now almost complete, the calculations must be added.
<?php require_once('config.php'); $query = "SELECT * FROM inventory_miscs ORDER BY 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)) { $miscs[] = array( 'record' => $row['record'], 'name' => $row['name'], 'type' => $row['type'], 'use_use' => $row['use_use'], 'time' => $row['time'], 'amount_is_weight' => $row['amount_is_weight'], 'inventory' => $row['inventory'], 'cost' => $row['cost'] ); } echo json_encode($miscs);