comparison: www/includes/db_inventory_hops.php
www/includes/db_inventory_hops.php
- changeset 19
- 057a6256bd7b
- parent 18
- 395833e20f88
- child 30
- f5ab22446aa5
equal
deleted
inserted
replaced
| 18:395833e20f88 | 19:057a6256bd7b |
|---|---|
| 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 | 5 |
| 6 syslog(LOG_NOTICE, "db_inventory_hops: script start"); | |
| 7 | 6 |
| 8 #Connect to the database | 7 #Connect to the database |
| 9 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); | 8 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
| 10 if (! $connect) { | 9 if (! $connect) { |
| 11 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | 10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
| 21 $sql .= "', humulene='" . $_GET['humulene']; | 20 $sql .= "', humulene='" . $_GET['humulene']; |
| 22 $sql .= "', caryophyllene='" . $_GET['caryophyllene']; | 21 $sql .= "', caryophyllene='" . $_GET['caryophyllene']; |
| 23 $sql .= "', cohumulone='" . $_GET['cohumulone']; | 22 $sql .= "', cohumulone='" . $_GET['cohumulone']; |
| 24 $sql .= "', myrcene='" . $_GET['myrcene']; | 23 $sql .= "', myrcene='" . $_GET['myrcene']; |
| 25 $sql .= "', hsi='" . $_GET['hsi']; | 24 $sql .= "', hsi='" . $_GET['hsi']; |
| 26 $sql .= "', useat='" . $_GET['useat']; | |
| 27 $sql .= "', type='" . $_GET['type']; | 25 $sql .= "', type='" . $_GET['type']; |
| 28 $sql .= "', form='" . $_GET['form']; | 26 $sql .= "', form='" . $_GET['form']; |
| 29 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | 27 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); |
| 30 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); | 28 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); |
| 31 $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_GET['substitutes']); | 29 $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_GET['substitutes']); |
| 32 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; | 30 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; |
| 33 $sql .= "', inventory='" . $_GET['inventory']; | 31 $sql .= "', inventory='" . $_GET['inventory']; |
| 34 $sql .= "', cost='" . $_GET['cost']; | 32 $sql .= "', cost='" . $_GET['cost']; |
| 35 $sql .= "', production_date='" . $_GET['production_date']; | 33 $sql .= "', production_date='" . $_GET['production_date']; |
| 36 $sql .= "', tht_date='" . $_GET['tht_date']; | 34 $sql .= "', tht_date='" . $_GET['tht_date']; |
| 37 $sql .= "', supplier_rec='" . $_GET['supplier_rec']; | 35 $sql .= "', total_oil='" . $_GET['total_oil']; |
| 38 $sql .= "', total_oil'" . $_GET['total_oil']; | |
| 39 $sql .= "';"; | 36 $sql .= "';"; |
| 40 $result = mysqli_query($connect, $sql); | 37 $result = mysqli_query($connect, $sql); |
| 41 if (! $result) { | 38 if (! $result) { |
| 42 syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); | 39 syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); |
| 43 } else { | 40 } else { |
| 53 $sql .= "', humulene='" . $_GET['humulene']; | 50 $sql .= "', humulene='" . $_GET['humulene']; |
| 54 $sql .= "', caryophyllene='" . $_GET['caryophyllene']; | 51 $sql .= "', caryophyllene='" . $_GET['caryophyllene']; |
| 55 $sql .= "', cohumulone='" . $_GET['cohumulone']; | 52 $sql .= "', cohumulone='" . $_GET['cohumulone']; |
| 56 $sql .= "', myrcene='" . $_GET['myrcene']; | 53 $sql .= "', myrcene='" . $_GET['myrcene']; |
| 57 $sql .= "', hsi='" . $_GET['hsi']; | 54 $sql .= "', hsi='" . $_GET['hsi']; |
| 58 $sql .= "', useat='" . $_GET['useat']; | |
| 59 $sql .= "', type='" . $_GET['type']; | 55 $sql .= "', type='" . $_GET['type']; |
| 60 $sql .= "', form='" . $_GET['form']; | 56 $sql .= "', form='" . $_GET['form']; |
| 61 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | 57 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); |
| 62 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); | 58 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); |
| 63 $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_GET['substitutes']); | 59 $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_GET['substitutes']); |
| 64 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; | 60 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; |
| 65 $sql .= "', inventory='" . $_GET['inventory']; | 61 $sql .= "', inventory='" . $_GET['inventory']; |
| 66 $sql .= "', cost='" . $_GET['cost']; | 62 $sql .= "', cost='" . $_GET['cost']; |
| 67 $sql .= "', production_date='" . $_GET['production_date']; | 63 $sql .= "', production_date='" . $_GET['production_date']; |
| 68 $sql .= "', tht_date='" . $_GET['tht_date']; | 64 $sql .= "', tht_date='" . $_GET['tht_date']; |
| 69 $sql .= "', supplier_rec='" . $_GET['supplier_rec']; | 65 $sql .= "', total_oil='" . $_GET['total_oil']; |
| 70 $sql .= "', total_oil'" . $_GET['total_oil']; | |
| 71 $sql .= "' WHERE record='" . $_GET['record'] . "';"; | 66 $sql .= "' WHERE record='" . $_GET['record'] . "';"; |
| 72 $result = mysqli_query($connect, $sql); | 67 $result = mysqli_query($connect, $sql); |
| 73 if (! $result) { | 68 if (! $result) { |
| 74 syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); | 69 syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); |
| 75 } else { | 70 } else { |
| 100 'humulene' => $row['humulene'], | 95 'humulene' => $row['humulene'], |
| 101 'caryophyllene' => $row['caryophyllene'], | 96 'caryophyllene' => $row['caryophyllene'], |
| 102 'cohumulone' => $row['cohumulone'], | 97 'cohumulone' => $row['cohumulone'], |
| 103 'myrcene' => $row['myrcene'], | 98 'myrcene' => $row['myrcene'], |
| 104 'hsi' => $row['hsi'], | 99 'hsi' => $row['hsi'], |
| 105 'useat' => $row['useat'], | |
| 106 'type' => $row['type'], | 100 'type' => $row['type'], |
| 107 'form' => $row['form'], | 101 'form' => $row['form'], |
| 108 'notes' => $row['notes'], | 102 'notes' => $row['notes'], |
| 109 'origin' => $row['origin'], | 103 'origin' => $row['origin'], |
| 110 'substitutes' => $row['substitutes'], | 104 'substitutes' => $row['substitutes'], |
| 111 'always_on_stock' => $row['always_on_stock'], | 105 'always_on_stock' => $row['always_on_stock'], |
| 112 'inventory' => $row['inventory'], | 106 'inventory' => $row['inventory'], |
| 113 'cost' => $row['cost'], | 107 'cost' => $row['cost'], |
| 114 'production_date' => $row['production_date'], | 108 'production_date' => $row['production_date'], |
| 115 'tht_date' => $row['tht_date'], | 109 'tht_date' => $row['tht_date'], |
| 116 'supplier_rec' => $row['supplier_rec'], | |
| 117 'total_oil' => $row['total_oil'] | 110 'total_oil' => $row['total_oil'] |
| 118 ); | 111 ); |
| 119 } | 112 } |
| 120 echo json_encode($hops); | 113 echo json_encode($hops); |
| 121 } | 114 } |
