Mercurial > bms / file revision

• file
• latest
• revisions
• annotate
• diff
• comparison
• raw

www/getfermenter.php@cf145b35d65f

www/getfermenter.php

Fri, 22 Jul 2022 12:15:05 +0200

author

Michiel Broek <mbroek@mbse.eu>

date

Fri, 22 Jul 2022 12:15:05 +0200

changeset 799

cf145b35d65f

parent 572

7a03181d29a3

permissions

-rw-r--r--

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 = "'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);
header("Content-type: application/json");
echo json_encode($resultArray);