comparison: www/includes/db_inventory_hops.php
www/includes/db_inventory_hops.php
- changeset 18
- 395833e20f88
- parent 13
- b8c3ca152984
- child 19
- 057a6256bd7b
equal
deleted
inserted
replaced
| 17:bb97e0de63cf | 18:395833e20f88 |
|---|---|
| 1 <?php | 1 <?php |
| 2 | 2 |
| 3 require($_SERVER['DOCUMENT_ROOT']."/config.php"); | 3 require($_SERVER['DOCUMENT_ROOT']."/config.php"); |
| 4 require($_SERVER['DOCUMENT_ROOT']."/version.php"); | 4 require($_SERVER['DOCUMENT_ROOT']."/version.php"); |
| 5 | |
| 6 syslog(LOG_NOTICE, "db_inventory_hops: script start"); | |
| 5 | 7 |
| 6 #Connect to the database | 8 #Connect to the database |
| 7 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); | 9 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
| 8 if (! $connect) { | 10 if (! $connect) { |
| 9 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | 11 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
| 33 $sql .= "', production_date='" . $_GET['production_date']; | 35 $sql .= "', production_date='" . $_GET['production_date']; |
| 34 $sql .= "', tht_date='" . $_GET['tht_date']; | 36 $sql .= "', tht_date='" . $_GET['tht_date']; |
| 35 $sql .= "', supplier_rec='" . $_GET['supplier_rec']; | 37 $sql .= "', supplier_rec='" . $_GET['supplier_rec']; |
| 36 $sql .= "', total_oil'" . $_GET['total_oil']; | 38 $sql .= "', total_oil'" . $_GET['total_oil']; |
| 37 $sql .= "';"; | 39 $sql .= "';"; |
| 38 error_log("\"$sql\""); | 40 $result = mysqli_query($connect, $sql); |
| 39 $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); | 41 if (! $result) { |
| 40 error_log("result " . $result); | 42 syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); |
| 43 } else { | |
| 44 syslog(LOG_NOTICE, "db_inventory_hops: inserted ".$_GET['name']); | |
| 45 } | |
| 41 echo $result; | 46 echo $result; |
| 42 | 47 |
| 43 } else if (isset($_GET['update'])) { | 48 } else if (isset($_GET['update'])) { |
| 44 // UPDATE COMMAND | 49 // UPDATE COMMAND |
| 45 $sql = "UPDATE `inventory_hops` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | 50 $sql = "UPDATE `inventory_hops` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
| 62 $sql .= "', production_date='" . $_GET['production_date']; | 67 $sql .= "', production_date='" . $_GET['production_date']; |
| 63 $sql .= "', tht_date='" . $_GET['tht_date']; | 68 $sql .= "', tht_date='" . $_GET['tht_date']; |
| 64 $sql .= "', supplier_rec='" . $_GET['supplier_rec']; | 69 $sql .= "', supplier_rec='" . $_GET['supplier_rec']; |
| 65 $sql .= "', total_oil'" . $_GET['total_oil']; | 70 $sql .= "', total_oil'" . $_GET['total_oil']; |
| 66 $sql .= "' WHERE record='" . $_GET['record'] . "';"; | 71 $sql .= "' WHERE record='" . $_GET['record'] . "';"; |
| 67 error_log("\"$sql\""); | 72 $result = mysqli_query($connect, $sql); |
| 68 $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); | 73 if (! $result) { |
| 69 error_log("result " . $result); | 74 syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); |
| 75 } else { | |
| 76 syslog(LOG_NOTICE, "db_inventory_hops: updated record ".$_GET['record']); | |
| 77 } | |
| 70 echo $result; | 78 echo $result; |
| 71 | 79 |
| 72 } else if (isset($_GET['delete'])) { | 80 } else if (isset($_GET['delete'])) { |
| 73 // DELETE COMMAND | 81 // DELETE COMMAND |
| 74 $sql = "DELETE FROM `inventory_hops` WHERE record='".$_GET['record']."';"; | 82 $sql = "DELETE FROM `inventory_hops` WHERE record='".$_GET['record']."';"; |
| 75 error_log("\"$sql\""); | 83 $result = mysqli_query($connect, $sql); |
| 76 $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); | 84 if (! $result) { |
| 77 error_log("result " . $result); | 85 syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); |
| 86 } else { | |
| 87 syslog(LOG_NOTICE, "db_inventory_hops: deleted record ".$_GET['record']); | |
| 88 } | |
| 78 echo $result; | 89 echo $result; |
| 79 | 90 |
| 80 } else { | 91 } else { |
| 81 // SELECT COMMAND | 92 // SELECT COMMAND |
| 82 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | 93 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
