--- 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);
+
?>