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'); if (isset($_GET["uuid"])) $uuid = $_GET["uuid"]; else $uuid = "'ef166f25-1bb4-4bef-b112-a867af77f766'"; $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); $query = "SELECT * FROM mon_fermenters WHERE uuid=".$uuid.""; $result = $mysqli->query($query); $resultArray = $result->fetch_array(MYSQLI_ASSOC); if ($resultArray['online'] == 'Y') { $resultArray['online'] = true; } else { $resultArray['online'] = false; } echo json_encode($resultArray);