Mercurial > bms / file diff

--- a/www/includes/db_profile_fermentation.php	Sun Jul 04 14:25:52 2021 +0200
+++ b/www/includes/db_profile_fermentation.php	Sun Jul 04 20:01:13 2021 +0200
@@ -10,6 +10,11 @@
 }
 mysqli_set_charset($connect, "utf8" );
 
+$response = array(
+   'error' => false,
+   'msg' => 'Ok',
+);
+
 $rescapers = array("'");
 $rreplacements = array("\\'");
 
@@ -60,20 +65,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_profile_fermentation: ".$sql." result: ".mysqli_error($connect));
-	//} else {
-	//	if (isset($_POST['update'])) {
-	//		syslog(LOG_NOTICE, "db_profile_fermentation: updated record ".$_POST['record']);
-	//	} else {
-	//		$lastid = mysqli_insert_id($connect);
-	//		syslog(LOG_NOTICE, "db_profile_fermentation: 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
@@ -81,10 +79,10 @@
 	$result = mysqli_query($connect, $sql);
 	if (! $result) {
 		syslog(LOG_NOTICE, "db_profile_fermentation: ".$sql." result: ".mysqli_error($connect));
-	} else {
-		syslog(LOG_NOTICE, "db_profile_fermentation: deleted record ".$_POST['record']);
-	}
-	echo $result;
+                $response['error'] = true;
+                $response['msg'] = "SQL fout: ".mysqli_error($connect);
+        }
+	exit(json_encode($response));
 
 } else {
 	// SELECT COMMAND
@@ -111,8 +109,13 @@
 		$profiles .= '}';
 	}
 	$profiles .= ']';
-//	syslog(LOG_NOTICE, $profiles);
 	header("Content-type: application/json");
-	echo $profiles;
+	exit($profiles);
 }
+
+syslog(LOG_NOTICE, "db_profile_fermentation: missing arguments");
+$response['error'] = true;
+$response['msg'] = "missing arguments";
+echo json_encode($response);
+
 ?>