32 $sql .= "', inventory='" . $_GET['inventory']; |
32 $sql .= "', inventory='" . $_GET['inventory']; |
33 $sql .= "', cost='" . $_GET['cost']; |
33 $sql .= "', cost='" . $_GET['cost']; |
34 $sql .= "', production_date='" . $_GET['production_date']; |
34 $sql .= "', production_date='" . $_GET['production_date']; |
35 $sql .= "', tht_date='" . $_GET['tht_date']; |
35 $sql .= "', tht_date='" . $_GET['tht_date']; |
36 $sql .= "';"; |
36 $sql .= "';"; |
37 error_log("\"$sql\""); |
37 $result = mysqli_query($connect, $sql); |
38 $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); |
38 if (! $result) { |
39 error_log("result " . $result); |
39 syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect)); |
|
40 } else { |
|
41 syslog(LOG_NOTICE, "db_inventory_yeasts: inserted ".$_GET['name']); |
|
42 } |
40 echo $result; |
43 echo $result; |
41 |
44 |
42 } else if (isset($_GET['update'])) { |
45 } else if (isset($_GET['update'])) { |
43 // UPDATE COMMAND |
46 // UPDATE COMMAND |
44 $sql = "UPDATE `inventory_yeasts` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
47 $sql = "UPDATE `inventory_yeasts` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
60 $sql .= "', inventory='" . $_GET['inventory']; |
63 $sql .= "', inventory='" . $_GET['inventory']; |
61 $sql .= "', cost='" . $_GET['cost']; |
64 $sql .= "', cost='" . $_GET['cost']; |
62 $sql .= "', production_date='" . $_GET['production_date']; |
65 $sql .= "', production_date='" . $_GET['production_date']; |
63 $sql .= "', tht_date='" . $_GET['tht_date']; |
66 $sql .= "', tht_date='" . $_GET['tht_date']; |
64 $sql .= "' WHERE record='" . $_GET['record'] . "';"; |
67 $sql .= "' WHERE record='" . $_GET['record'] . "';"; |
65 error_log("\"$sql\""); |
68 $result = mysqli_query($connect, $sql); |
66 $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); |
69 if (! $result) { |
67 error_log("result " . $result); |
70 syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect)); |
|
71 } else { |
|
72 syslog(LOG_NOTICE, "db_inventory_yeasts: updated record ".$_GET['record']); |
|
73 } |
68 echo $result; |
74 echo $result; |
69 |
75 |
70 } else if (isset($_GET['delete'])) { |
76 } else if (isset($_GET['delete'])) { |
71 // DELETE COMMAND |
77 // DELETE COMMAND |
72 $sql = "DELETE FROM `inventory_yeasts` WHERE record='".$_GET['record']."';"; |
78 $sql = "DELETE FROM `inventory_yeasts` WHERE record='".$_GET['record']."';"; |
73 error_log("\"$sql\""); |
79 $result = mysqli_query($connect, $sql); |
74 $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); |
80 if (! $result) { |
75 error_log("result " . $result); |
81 syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect)); |
|
82 } else { |
|
83 syslog(LOG_NOTICE, "db_inventory_yeasts: deleted record ".$_GET['record']); |
|
84 } |
76 echo $result; |
85 echo $result; |
77 |
86 |
78 } else { |
87 } else { |
79 // SELECT COMMAND |
88 // SELECT COMMAND |
80 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
89 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |