Mercurial > bms / file diff

--- 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 {