diff -r 08c0343b622b -r ae1195153fa2 www/includes/db_setup.php --- 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); } ?>