diff -r 86289b0c4a27 -r 08c0343b622b www/includes/db_inventory_suppliers.php --- a/www/includes/db_inventory_suppliers.php Sun Jul 04 12:16:25 2021 +0200 +++ b/www/includes/db_inventory_suppliers.php Sun Jul 04 14:25:52 2021 +0200 @@ -10,6 +10,11 @@ } mysqli_set_charset($connect, "utf8" ); +$response = array( + 'error' => false, + 'msg' => 'Ok', +); + // get data and store in a json array $query = "SELECT * FROM inventory_suppliers ORDER BY name"; if (isset($_POST['insert'])) { @@ -27,10 +32,10 @@ $result = mysqli_query($connect, $sql); if (! $result) { syslog(LOG_NOTICE, "db_inventory_suppliers: ".$sql." result: ".mysqli_error($connect)); - //} else { - // syslog(LOG_NOTICE, "db_inventory_suppliers: inserted ".$_POST['name']); - } - echo $result; + $response['error'] = true; + $response['msg'] = "SQL fout: ".mysqli_error($connect); + } + exit(json_encode($response)); } else if (isset($_POST['update'])) { // UPDATE COMMAND @@ -47,22 +52,21 @@ $result = mysqli_query($connect, $sql); if (! $result) { syslog(LOG_NOTICE, "db_inventory_suppliers: ".$sql." result: ".mysqli_error($connect)); - //} else { - // syslog(LOG_NOTICE, "db_inventory_suppliers: updated record ".$_POST['record']); - } - echo $result; + $response['error'] = true; + $response['msg'] = "SQL fout: ".mysqli_error($connect); + } + exit(json_encode($response)); } else if (isset($_POST['delete'])) { // DELETE COMMAND - // FIXME: need to check if the record is in use $sql = "DELETE FROM `inventory_suppliers` WHERE record='".$_POST['record']."';"; $result = mysqli_query($connect, $sql); if (! $result) { syslog(LOG_NOTICE, "db_inventory_suppliers: ".$sql." result: ".mysqli_error($connect)); - } else { - syslog(LOG_NOTICE, "db_inventory_suppliers: deleted record ".$_POST['record']); - } - echo $result; + $response['error'] = true; + $response['msg'] = "SQL fout: ".mysqli_error($connect); + } + exit(json_encode($response)); } else { // SELECT COMMAND @@ -82,6 +86,12 @@ ); } header("Content-type: application/json"); - echo json_encode($suppliers); + exit(json_encode($suppliers)); } + +syslog(LOG_NOTICE, "db_inventory_suppliers: missing arguments"); +$response['error'] = true; +$response['msg'] = "missing arguments"; +echo json_encode($response); + ?>