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 = "'c0c17800-fabb-4f22-a02a-4f83a7b1b21b'"; $query = "SELECT * FROM mon_nodes WHERE uuid=".$uuid.""; $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); $result = $mysqli->query($query); //Copy result into a associative array $resultArray = $result->fetch_array(MYSQLI_ASSOC); if ($resultArray['online'] == 'Y') { $resultArray['online'] = true; } else { $resultArray['online'] = false; } echo json_encode($resultArray);