Mercurial > bms / file diff

--- a/www/includes/db_inventory_water.php	Sun Jul 04 12:16:25 2021 +0200
+++ b/www/includes/db_inventory_water.php	Sun Jul 04 14:25:52 2021 +0200
@@ -10,6 +10,10 @@
 }
 mysqli_set_charset($connect, "utf8" );
 
+$response = array(
+   'error' => false,
+   'msg' => 'Ok',
+);
 
 if (isset($_POST['insert']) || isset($_POST['update'])) {
 	if (isset($_POST['insert'])) {
@@ -38,20 +42,13 @@
 	if (isset($_POST['update'])) {
 		$sql .= "' WHERE record='" . $_POST['record'] . "';";
 	}
-	//syslog(LOG_NOTICE, $sql);
-
 	$result = mysqli_query($connect, $sql);
 	if (! $result) {
 		syslog(LOG_NOTICE, "db_inventory_waters: ".$sql." result: ".mysqli_error($connect));
-	//} else {
-	//	if (isset($_POST['update'])) {
-	//		syslog(LOG_NOTICE, "db_inventory_waters: updated record ".$_POST['record']);
-	//	} else {
-	//		$lastid = mysqli_insert_id($connect);
-	//		syslog(LOG_NOTICE, "db_inventory_waters: inserted record ".$lastid);
-	//	}
-	}
-	echo $result;
+                $response['error'] = true;
+                $response['msg'] = "SQL fout: ".mysqli_error($connect);
+        }
+        exit(json_encode($response));
 
 } else if (isset($_POST['delete'])) {
 	// DELETE COMMAND
@@ -59,10 +56,10 @@
 	$result = mysqli_query($connect, $sql);
 	if (! $result) {
 		syslog(LOG_NOTICE, "db_inventory_waters: ".$sql." result: ".mysqli_error($connect));
-	} else {
-		syslog(LOG_NOTICE, "db_inventory_waters: deleted record ".$_POST['record']);
-	}
-	echo $result;
+                $response['error'] = true;
+                $response['msg'] = "SQL fout: ".mysqli_error($connect);
+        }
+        exit(json_encode($response));
 
 } else {
 	// SELECT COMMAND
@@ -87,6 +84,12 @@
 		);
 	}
 	header("Content-type: application/json");
-	echo json_encode($waters);
+	exit(json_encode($waters));
 }
+
+syslog(LOG_NOTICE, "db_inventory_water: missing arguments");
+$response['error'] = true;
+$response['msg'] = "missing arguments";
+echo json_encode($response);
+
 ?>