Mercurial > bms / file diff

--- a/www/includes/db_setup.php	Sun Jul 04 14:25:52 2021 +0200
+++ b/www/includes/db_setup.php	Sun Jul 04 20:01:13 2021 +0200
@@ -12,6 +12,11 @@
 $escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c");
 $replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b");
 
+$response = array(
+   'error' => false,
+   'msg' => 'Ok',
+);
+
 $query = "SELECT * FROM profile_setup WHERE record='1'";
 
 if (isset($_POST['update'])) {
@@ -36,14 +41,14 @@
 	$sql .= "', default_water='" . $default_water;
 	$sql .= "', my_yeastlab='" . $_POST['my_yeastlab'];
 	$sql .= "' WHERE record='1';";
-	//syslog(LOG_NOTICE, $sql);
 	$result = mysqli_query($connect, $sql);
 	if (! $result) {
 		syslog(LOG_NOTICE, "db_profile_setup: ".$sql." result: ".mysqli_error($connect));
-	} else {
-		syslog(LOG_NOTICE, "db_profile_setup: updated record 1");
-	}
-	echo $result;
+                $response['error'] = true;
+                $response['msg'] = "SQL fout: ".mysqli_error($connect);
+        }
+        exit(json_encode($response));
+
 } else {
 	$result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
 	if ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
@@ -70,6 +75,6 @@
 		$data .= '"}';
 	}
 	header("Content-type: application/json");
-	echo $data;
+	exit($data);
 }
 ?>