Mercurial > bms / file diff

--- a/www/getwatersources.php	Mon Jul 05 20:59:10 2021 +0200
+++ b/www/getwatersources.php	Sun Jul 11 15:55:44 2021 +0200
@@ -1,7 +1,7 @@
 <?php
 require_once('config.php');
 
-$query = "SELECT * FROM inventory_waters ORDER BY name";
+$query = "SELECT record,name,unlimited_stock,calcium,sulfate,chloride,sodium,magnesium,ph,total_alkalinity,inventory,cost FROM inventory_waters ORDER BY name";
 $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
 if (! $connect) {
 	echo "[]";
@@ -10,20 +10,7 @@
 mysqli_set_charset($connect, "utf8");
 $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']
-	);
+	$waters[] = $row;
 }
 header("Content-type: application/json");
 echo json_encode($waters);