www/includes/db_inventory_yeasts.php

changeset 767
08c0343b622b
parent 725
30346e5b9e12
child 785
aa79acfdf8a9
--- a/www/includes/db_inventory_yeasts.php	Sun Jul 04 12:16:25 2021 +0200
+++ b/www/includes/db_inventory_yeasts.php	Sun Jul 04 14:25:52 2021 +0200
@@ -11,6 +11,10 @@
 }
 mysqli_set_charset($connect, "utf8" );
 
+$response = array(
+   'error' => false,
+   'msg' => 'Ok',
+);
 
 // get data and store in a json array
 if (isset($_POST['insert']) || isset($_POST['update'])) {
@@ -63,19 +67,13 @@
 	if (isset($_POST['update'])) {
 		$sql .= " WHERE record='" . $_POST['record'] . "';";
 	}
-
 	$result = mysqli_query($connect, $sql);
 	if (! $result) {
 		syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect));
-	//} else {
-	//	if (isset($_POST['update'])) {
-	//		syslog(LOG_NOTICE, "db_inventory_yeasts: updated record ".$_POST['record']);
-	//	} else {
-	//		$lastid = mysqli_insert_id($connect);
-	//		syslog(LOG_NOTICE, "db_inventory_yeasts: 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
@@ -83,10 +81,10 @@
 	$result = mysqli_query($connect, $sql);
 	if (! $result) {
 		syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect));
-	} else {
-		syslog(LOG_NOTICE, "db_inventory_yeasts: deleted record ".$_POST['record']);
-	}
-	echo $result;
+                $response['error'] = true;
+                $response['msg'] = "SQL fout: ".mysqli_error($connect);
+        }
+        exit(json_encode($response));
 
 } else {
 	// SELECT COMMAND
@@ -128,6 +126,12 @@
 		);
 	}
 	header("Content-type: application/json");
-	echo json_encode($yeasts);
+	exit(json_encode($yeasts));
 }
+
+syslog(LOG_NOTICE, "db_inventory_yeasts: missing arguments");
+$response['error'] = true;
+$response['msg'] = "missing arguments";
+echo json_encode($response);
+
 ?>

mercurial