Thu, 13 Jun 2024 17:12:00 +0200
Brought the web interface in sync with the new bmsapp water treatment.
<?php require_once('config.php'); if (isset($_GET["code"])) $code = $_GET["code"]; else $code = "CB0111"; $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); if (! $connect) { die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); } mysqli_set_charset($connect, "utf8" ); function HydroCorrection($mg, $tr, $tc) { $trf = $tr * 1.8 + 32; $tcf = $tc * 1.8 + 32; return $mg * ((1.00130346 - 1.34722124E-4 * $trf + 2.04052596E-6 * $trf * $trf - 2.32820948E-9 * $trf * $trf * $trf) / (1.00130346 - 1.34722124E-4 * $tcf + 2.04052596E-6 * $tcf * $tcf - 2.32820948E-9 * $tcf * $tcf * $tcf)); } $query = "SELECT * FROM log_ispindel WHERE code='".$code."' ORDER BY datetime;"; $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $SG = HydroCorrection($row['sg'], $row['temperature'], 20.0); $logs[] = array( 'date' => substr($row['datetime'],0,16), 'temperature' => $row['temperature'], 'plato' => $row['plato'], 'sg' => $SG, 'battery' => $row['battery'] ); } header("Content-type: application/json"); echo json_encode($logs);