diff -r bb97e0de63cf -r 395833e20f88 www/includes/db_inventory_yeasts.php --- a/www/includes/db_inventory_yeasts.php Mon Aug 13 23:01:25 2018 +0200 +++ b/www/includes/db_inventory_yeasts.php Thu Aug 16 16:01:13 2018 +0200 @@ -34,9 +34,12 @@ $sql .= "', production_date='" . $_GET['production_date']; $sql .= "', tht_date='" . $_GET['tht_date']; $sql .= "';"; - error_log("\"$sql\""); - $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); - error_log("result " . $result); + $result = mysqli_query($connect, $sql); + if (! $result) { + syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect)); + } else { + syslog(LOG_NOTICE, "db_inventory_yeasts: inserted ".$_GET['name']); + } echo $result; } else if (isset($_GET['update'])) { @@ -62,17 +65,23 @@ $sql .= "', production_date='" . $_GET['production_date']; $sql .= "', tht_date='" . $_GET['tht_date']; $sql .= "' WHERE record='" . $_GET['record'] . "';"; - error_log("\"$sql\""); - $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); - error_log("result " . $result); + $result = mysqli_query($connect, $sql); + if (! $result) { + syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect)); + } else { + syslog(LOG_NOTICE, "db_inventory_yeasts: updated record ".$_GET['record']); + } echo $result; } else if (isset($_GET['delete'])) { // DELETE COMMAND $sql = "DELETE FROM `inventory_yeasts` WHERE record='".$_GET['record']."';"; - error_log("\"$sql\""); - $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); - error_log("result " . $result); + $result = mysqli_query($connect, $sql); + if (! $result) { + syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect)); + } else { + syslog(LOG_NOTICE, "db_inventory_yeasts: deleted record ".$_GET['record']); + } echo $result; } else {