www/includes/db_inventory_hops.php

changeset 767
08c0343b622b
parent 715
8fb922c00a2d
child 785
aa79acfdf8a9
--- a/www/includes/db_inventory_hops.php	Sun Jul 04 12:16:25 2021 +0200
+++ b/www/includes/db_inventory_hops.php	Sun Jul 04 14:25:52 2021 +0200
@@ -12,6 +12,11 @@
 }
 mysqli_set_charset($connect, "utf8" );
 
+$response = array(
+   'error' => false,
+   'msg' => 'Ok',
+);
+
 if (isset($_POST['insert']) || isset($_POST['update'])) {
 	if (isset($_POST['insert'])) {
 		$sql  = "INSERT INTO `inventory_hops` SET ";
@@ -51,20 +56,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_hops: ".$sql." result: ".mysqli_error($connect));
-	//} else {
-	//	if (isset($_POST['update'])) {
-	//		syslog(LOG_NOTICE, "db_inventory_hops: updated record ".$_POST['record']);
-	//	} else {
-	//		$lastid = mysqli_insert_id($connect);
-	//		syslog(LOG_NOTICE, "db_inventory_hops: 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
@@ -72,10 +70,10 @@
 	$result = mysqli_query($connect, $sql);
 	if (! $result) {
 		syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect));
-	} else {
-		syslog(LOG_NOTICE, "db_inventory_hops: deleted record ".$_POST['record']);
-	}
-	echo $result;
+                $response['error'] = true;
+                $response['msg'] = "SQL fout: ".mysqli_error($connect);
+        }
+	exit(json_encode($response));
 
 } else {
 	// SELECT COMMAND
@@ -106,6 +104,12 @@
 		);
 	}
 	header("Content-type: application/json");
-	echo json_encode($hops);
+	exit(json_encode($hops));
 }
+
+syslog(LOG_NOTICE, "db_inventory_hops: missing arguments");
+$response['error'] = true;
+$response['msg'] = "missing arguments";
+echo json_encode($response);
+
 ?>

mercurial