Mercurial > bms / file revision

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

www/getwatersources.php@48f8f3fce7c0

www/getwatersources.php

Mon, 18 May 2020 11:00:59 +0200

author

Michiel Broek <mbroek@mbse.eu>

date

Mon, 18 May 2020 11:00:59 +0200

changeset 679

48f8f3fce7c0

parent 296

69fadd1aded2

child 705

d77b723f7b35

permissions

-rw-r--r--

Added reconnecting-websocket.js to automatic reconnect the websocket if the connection is lost. Usefull for mobile devices that go to sleep after a while. Changed mon_fermenters to use websockets instead of polling. Fixed wrong temperature color ranges on the fermenter monior. Increased the websocket receive buffer to 2048. In cannot overflow, but larger messages are chunked and the application does not handle these split messages. Needs termferm 0.9.9 or newer.

<?php
require_once('config.php');

$query = "SELECT * FROM inventory_waters ORDER BY name";
$connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
if (! $connect) {
	echo "[]";
	return;
}
$result = mysqli_query($connect, $query);
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
	$waters[] = array(
		'record' => $row['record'],
		'name' => $row['name'],
		'unlimited_stock' => $row['unlimited_stock'],
		'calcium' => $row['calcium'],
		'sulfate' => $row['sulfate'],
		'chloride' => $row['chloride'],
		'sodium' => $row['sodium'],
		'magnesium' => $row['magnesium'],
		'ph' => $row['ph'],
		'total_alkalinity' => $row['total_alkalinity'],
		'inventory' => $row['inventory'],
		'cost' => $row['cost']
	);
}
header("Content-type: application/json");
echo json_encode($waters);