Mercurial > bms / file diff

--- a/www/includes/db_inventory_hops.php	Mon Aug 13 23:01:25 2018 +0200
+++ b/www/includes/db_inventory_hops.php	Thu Aug 16 16:01:13 2018 +0200
@@ -3,6 +3,8 @@
 require($_SERVER['DOCUMENT_ROOT']."/config.php");
 require($_SERVER['DOCUMENT_ROOT']."/version.php");
 
+syslog(LOG_NOTICE, "db_inventory_hops: script start");
+
 #Connect to the database
 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME);
 if (! $connect) {
@@ -35,9 +37,12 @@
 	$sql .= "', supplier_rec='" . $_GET['supplier_rec'];
 	$sql .= "', total_oil'" . $_GET['total_oil'];
 	$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_hops: ".$sql." result: ".mysqli_error($connect));
+	} else {
+		syslog(LOG_NOTICE, "db_inventory_hops: inserted ".$_GET['name']);
+	}
 	echo $result;
 
 } else if (isset($_GET['update'])) {
@@ -64,17 +69,23 @@
 	$sql .= "', supplier_rec='" . $_GET['supplier_rec'];
 	$sql .= "', total_oil'" . $_GET['total_oil'];
 	$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_hops: ".$sql." result: ".mysqli_error($connect));
+	} else {
+		syslog(LOG_NOTICE, "db_inventory_hops: updated record ".$_GET['record']);
+	}
 	echo $result;
 
 } else if (isset($_GET['delete'])) {
 	// DELETE COMMAND
 	$sql = "DELETE FROM `inventory_hops` 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_hops: ".$sql." result: ".mysqli_error($connect));
+	} else {
+		syslog(LOG_NOTICE, "db_inventory_hops: deleted record ".$_GET['record']);
+	}
 	echo $result;
 
 } else {