diff -r 08c0343b622b -r ae1195153fa2 www/includes/db_profile_mash.php --- a/www/includes/db_profile_mash.php Sun Jul 04 14:25:52 2021 +0200 +++ b/www/includes/db_profile_mash.php Sun Jul 04 20:01:13 2021 +0200 @@ -13,6 +13,11 @@ $rescapers = array("'"); $rreplacements = array("\\'"); +$response = array( + 'error' => false, + 'msg' => 'Ok', +); + if (isset($_POST['insert']) || isset($_POST['update'])) { if (isset($_POST['insert'])) { $sql = "INSERT INTO"; @@ -48,20 +53,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_mash: ".$sql." result: ".mysqli_error($connect)); - //} else { - // if (isset($_POST['update'])) { - // syslog(LOG_NOTICE, "db_profile_mash: updated record ".$_POST['record']); - // } else { - // $lastid = mysqli_insert_id($connect); - // syslog(LOG_NOTICE, "db_profile_mash: 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 @@ -69,10 +67,10 @@ $result = mysqli_query($connect, $sql); if (! $result) { syslog(LOG_NOTICE, "db_profile_mash: ".$sql." result: ".mysqli_error($connect)); - } else { - syslog(LOG_NOTICE, "db_profile_mash: deleted record ".$_POST['record']); - } - echo $result; + $response['error'] = true; + $response['msg'] = "SQL fout: ".mysqli_error($connect); + } + exit(json_encode($response)); } else { // SELECT COMMAND @@ -90,11 +88,16 @@ $mashprofile .= ',"name":' . $row['JSON_QUOTE(name)']; $mashprofile .= ',"notes":' . $row['JSON_QUOTE(notes)']; $mashprofile .= ',"steps":' . $row['steps'] . '}'; -//syslog(LOG_NOTICE, $mashprofile); $mashprofiles .= $mashprofile; } $mashprofiles .= ']'; header("Content-type: application/json"); - echo $mashprofiles; + exit($mashprofiles); } + +syslog(LOG_NOTICE, "db_profile_mash: missing arguments"); +$response['error'] = true; +$response['msg'] = "missing arguments"; +echo json_encode($response); + ?>