Mercurial > bms / file revision

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

www/gethopsources.php@cf145b35d65f

www/gethopsources.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 771

9856238e9217

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');

$query = "SELECT record,name,alpha,beta,humulene,caryophyllene,cohumulone,myrcene,hsi,total_oil,type,form,origin,inventory,cost FROM inventory_hops ORDER BY origin,name";
$connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
if (! $connect) {
	echo "[]";
	return;
}
mysqli_set_charset($connect, "utf8" );
$result = mysqli_query($connect, $query);
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
	$hops[] = $row;
}
header("Content-type: application/json");
echo json_encode($hops);