www/getwatersources.php

Sat, 17 Nov 2018 15:58:13 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Sat, 17 Nov 2018 15:58:13 +0100
changeset 99
f433193f7bb6
parent 54
294dda7f1779
child 146
2a6c00d325b2
permissions
-rw-r--r--

Removed default water setting from the inventory_waters table. Added global setup record with default settings and the default water selection. Added a setup screen.

<?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'],
		'cost' => $row['cost']
	);
}
echo json_encode($waters);

mercurial