comparison: www/includes/db_inventory_hops.php
www/includes/db_inventory_hops.php
- changeset 13
- b8c3ca152984
- parent 12
- c26af32428a4
- child 18
- 395833e20f88
equal
deleted
inserted
replaced
| 12:c26af32428a4 | 13:b8c3ca152984 |
|---|---|
| 18 $sql .= "', beta='" . $_GET['beta']; | 18 $sql .= "', beta='" . $_GET['beta']; |
| 19 $sql .= "', humulene='" . $_GET['humulene']; | 19 $sql .= "', humulene='" . $_GET['humulene']; |
| 20 $sql .= "', caryophyllene='" . $_GET['caryophyllene']; | 20 $sql .= "', caryophyllene='" . $_GET['caryophyllene']; |
| 21 $sql .= "', cohumulone='" . $_GET['cohumulone']; | 21 $sql .= "', cohumulone='" . $_GET['cohumulone']; |
| 22 $sql .= "', myrcene='" . $_GET['myrcene']; | 22 $sql .= "', myrcene='" . $_GET['myrcene']; |
| 23 $sql .= "', hsi='" . $_GET['hsi']; | |
| 23 $sql .= "', useat='" . $_GET['useat']; | 24 $sql .= "', useat='" . $_GET['useat']; |
| 24 $sql .= "', type='" . $_GET['type']; | 25 $sql .= "', type='" . $_GET['type']; |
| 25 $sql .= "', form='" . $_GET['form']; | 26 $sql .= "', form='" . $_GET['form']; |
| 26 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | 27 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); |
| 27 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); | 28 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); |
| 30 $sql .= "', inventory='" . $_GET['inventory']; | 31 $sql .= "', inventory='" . $_GET['inventory']; |
| 31 $sql .= "', cost='" . $_GET['cost']; | 32 $sql .= "', cost='" . $_GET['cost']; |
| 32 $sql .= "', production_date='" . $_GET['production_date']; | 33 $sql .= "', production_date='" . $_GET['production_date']; |
| 33 $sql .= "', tht_date='" . $_GET['tht_date']; | 34 $sql .= "', tht_date='" . $_GET['tht_date']; |
| 34 $sql .= "', supplier_rec='" . $_GET['supplier_rec']; | 35 $sql .= "', supplier_rec='" . $_GET['supplier_rec']; |
| 36 $sql .= "', total_oil'" . $_GET['total_oil']; | |
| 35 $sql .= "';"; | 37 $sql .= "';"; |
| 36 error_log("\"$sql\""); | 38 error_log("\"$sql\""); |
| 37 $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); | 39 $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); |
| 38 error_log("result " . $result); | 40 error_log("result " . $result); |
| 39 echo $result; | 41 echo $result; |
| 45 $sql .= "', beta='" . $_GET['beta']; | 47 $sql .= "', beta='" . $_GET['beta']; |
| 46 $sql .= "', humulene='" . $_GET['humulene']; | 48 $sql .= "', humulene='" . $_GET['humulene']; |
| 47 $sql .= "', caryophyllene='" . $_GET['caryophyllene']; | 49 $sql .= "', caryophyllene='" . $_GET['caryophyllene']; |
| 48 $sql .= "', cohumulone='" . $_GET['cohumulone']; | 50 $sql .= "', cohumulone='" . $_GET['cohumulone']; |
| 49 $sql .= "', myrcene='" . $_GET['myrcene']; | 51 $sql .= "', myrcene='" . $_GET['myrcene']; |
| 52 $sql .= "', hsi='" . $_GET['hsi']; | |
| 50 $sql .= "', useat='" . $_GET['useat']; | 53 $sql .= "', useat='" . $_GET['useat']; |
| 51 $sql .= "', type='" . $_GET['type']; | 54 $sql .= "', type='" . $_GET['type']; |
| 52 $sql .= "', form='" . $_GET['form']; | 55 $sql .= "', form='" . $_GET['form']; |
| 53 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | 56 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); |
| 54 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); | 57 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); |
| 57 $sql .= "', inventory='" . $_GET['inventory']; | 60 $sql .= "', inventory='" . $_GET['inventory']; |
| 58 $sql .= "', cost='" . $_GET['cost']; | 61 $sql .= "', cost='" . $_GET['cost']; |
| 59 $sql .= "', production_date='" . $_GET['production_date']; | 62 $sql .= "', production_date='" . $_GET['production_date']; |
| 60 $sql .= "', tht_date='" . $_GET['tht_date']; | 63 $sql .= "', tht_date='" . $_GET['tht_date']; |
| 61 $sql .= "', supplier_rec='" . $_GET['supplier_rec']; | 64 $sql .= "', supplier_rec='" . $_GET['supplier_rec']; |
| 65 $sql .= "', total_oil'" . $_GET['total_oil']; | |
| 62 $sql .= "' WHERE record='" . $_GET['record'] . "';"; | 66 $sql .= "' WHERE record='" . $_GET['record'] . "';"; |
| 63 error_log("\"$sql\""); | 67 error_log("\"$sql\""); |
| 64 $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); | 68 $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); |
| 65 error_log("result " . $result); | 69 error_log("result " . $result); |
| 66 echo $result; | 70 echo $result; |
| 84 'beta' => $row['beta'], | 88 'beta' => $row['beta'], |
| 85 'humulene' => $row['humulene'], | 89 'humulene' => $row['humulene'], |
| 86 'caryophyllene' => $row['caryophyllene'], | 90 'caryophyllene' => $row['caryophyllene'], |
| 87 'cohumulone' => $row['cohumulone'], | 91 'cohumulone' => $row['cohumulone'], |
| 88 'myrcene' => $row['myrcene'], | 92 'myrcene' => $row['myrcene'], |
| 93 'hsi' => $row['hsi'], | |
| 89 'useat' => $row['useat'], | 94 'useat' => $row['useat'], |
| 90 'type' => $row['type'], | 95 'type' => $row['type'], |
| 91 'form' => $row['form'], | 96 'form' => $row['form'], |
| 92 'notes' => $row['notes'], | 97 'notes' => $row['notes'], |
| 93 'origin' => $row['origin'], | 98 'origin' => $row['origin'], |
| 95 'always_on_stock' => $row['always_on_stock'], | 100 'always_on_stock' => $row['always_on_stock'], |
| 96 'inventory' => $row['inventory'], | 101 'inventory' => $row['inventory'], |
| 97 'cost' => $row['cost'], | 102 'cost' => $row['cost'], |
| 98 'production_date' => $row['production_date'], | 103 'production_date' => $row['production_date'], |
| 99 'tht_date' => $row['tht_date'], | 104 'tht_date' => $row['tht_date'], |
| 100 'supplier_rec' => $row['supplier_rec'] | 105 'supplier_rec' => $row['supplier_rec'], |
| 106 'total_oil' => $row['total_oil'] | |
| 101 ); | 107 ); |
| 102 } | 108 } |
| 103 echo json_encode($hops); | 109 echo json_encode($hops); |
| 104 } | 110 } |
| 105 ?> | 111 ?> |
