Mercurial > bms / file revision

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

www/getmiscsources.php@16079aef4c4c

www/getmiscsources.php

Thu, 12 Oct 2023 14:19:46 +0200

author

Michiel Broek <mbroek@mbse.eu>

date

Thu, 12 Oct 2023 14:19:46 +0200

changeset 849

16079aef4c4c

parent 771

9856238e9217

permissions

-rw-r--r--

Version 0.3.44. Moved iSpindel Plato calculation from the php script to bmsd. This uses calibration data in the mon_ispindels table. Setup of this data will be done by the bmsapp applications. Default settings are stored in MySQL. From now on you don't need to store calibration data in the iSpindel.

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

$query = "SELECT record,name,type,use_use,time,amount_is_weight,inventory,cost FROM inventory_miscs ORDER BY 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)) {
	$miscs[] = $row;
}
header("Content-type: application/json");
echo json_encode($miscs);