diff -r b702c25661e7 -r d13be50c0049 www/includes/db_product.php --- a/www/includes/db_product.php Sun Jun 27 10:15:09 2021 +0200 +++ b/www/includes/db_product.php Sun Jun 27 11:12:24 2021 +0200 @@ -16,6 +16,11 @@ $rreplacements = array("\\'"); $disallowed = array('visibleindex','uniqueid','boundindex','uid','h_weight','m_weight'); +$response = array( + 'error' => false, + 'msg' => 'Ok', +); + if (isset($_POST['insert']) || isset($_POST['update'])) { if (isset($_POST['insert'])) { $sql = "INSERT INTO `products` SET "; @@ -522,7 +527,9 @@ $result = mysqli_query($connect, $sql); if (! $result) { - syslog(LOG_NOTICE, "db_product: result: ".mysqli_error($connect)); + syslog(LOG_NOTICE, "db_product: result: ".mysqli_error($connect)); + $response['error'] = true; + $response['msg'] = "SQL fout: ".mysqli_error($link); } else { if (isset($_POST['update'])) { //syslog(LOG_NOTICE, "db_product: updated record ".$_POST['record']); @@ -532,7 +539,7 @@ //syslog(LOG_NOTICE, "db_product: inserted record ".$lastid); } } - echo $result; + echo json_encode($response); } else if (isset($_POST['splitit'])) { /* @@ -548,10 +555,12 @@ $result = mysqli_query($connect, $sql); if (! $result) { syslog(LOG_NOTICE, "db_product: result: ".mysqli_error($connect)); + $response['error'] = true; + $response['msg'] = "SQL update fout: ".mysqli_error($link); } else { syslog(LOG_NOTICE, "db_product: updated (divide) record ".$_POST['record']); - } - echo $result; + } + echo json_encode($response); } else if (isset($_POST['delete'])) { /* @@ -561,10 +570,12 @@ $result = mysqli_query($connect, $sql); if (! $result) { syslog(LOG_NOTICE, "db_product: ".$sql." result: ".mysqli_error($connect)); + $response['error'] = true; + $response['msg'] = "SQL delete fout: ".mysqli_error($link); } else { syslog(LOG_NOTICE, "db_product: deleted product uuid ".$_POST['uuid']); } - echo $result; + echo json_encode($response); } else { /*