Fri, 22 Jul 2022 12:15:05 +0200
Version 0.3.41. Use INSERT IGNORE .. for insert log messages from fermenters, co2meters and ispindels. Connect to MySQL servers with MYSQL_OPT_RECONNECT instead of manual working around the connection lost problem if a mysql server is restarted. Removed unused bms_mysql_ping function.
<?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); header("Content-type: application/json"); echo json_encode($resultArray);