comparison: www/includes/db_inventory_hops.php
www/includes/db_inventory_hops.php
- changeset 514
- 3c680d1dea35
- parent 296
- 69fadd1aded2
- child 712
- 65da479b5542
equal
deleted
inserted
replaced
| 513:217ba4596c4d | 514:3c680d1dea35 |
|---|---|
| 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 require($_SERVER['DOCUMENT_ROOT']."/includes/constants.php"); | |
| 5 | 6 |
| 6 | 7 |
| 7 #Connect to the database | 8 #Connect to the database |
| 8 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); | 9 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
| 9 if (! $connect) { | 10 if (! $connect) { |
| 25 $sql .= "', humulene='" . $_POST['humulene']; | 26 $sql .= "', humulene='" . $_POST['humulene']; |
| 26 $sql .= "', caryophyllene='" . $_POST['caryophyllene']; | 27 $sql .= "', caryophyllene='" . $_POST['caryophyllene']; |
| 27 $sql .= "', cohumulone='" . $_POST['cohumulone']; | 28 $sql .= "', cohumulone='" . $_POST['cohumulone']; |
| 28 $sql .= "', myrcene='" . $_POST['myrcene']; | 29 $sql .= "', myrcene='" . $_POST['myrcene']; |
| 29 $sql .= "', hsi='" . $_POST['hsi']; | 30 $sql .= "', hsi='" . $_POST['hsi']; |
| 30 $sql .= "', type='" . $_POST['type']; | 31 $sql .= "', type='" . array_search($_POST['type'], $hoptype); |
| 31 $sql .= "', form='" . $_POST['form']; | 32 $sql .= "', form='" . array_search($_POST['form'], $hopform); |
| 32 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']); | 33 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']); |
| 33 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_POST['origin']); | 34 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_POST['origin']); |
| 34 $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_POST['substitutes']); | 35 $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_POST['substitutes']); |
| 35 ($_POST['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; | 36 ($_POST['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; |
| 36 $sql .= "', inventory='" . floatval($_POST['inventory']) / 1000.0; | 37 $sql .= "', inventory='" . floatval($_POST['inventory']) / 1000.0; |
| 89 'humulene' => $row['humulene'], | 90 'humulene' => $row['humulene'], |
| 90 'caryophyllene' => $row['caryophyllene'], | 91 'caryophyllene' => $row['caryophyllene'], |
| 91 'cohumulone' => $row['cohumulone'], | 92 'cohumulone' => $row['cohumulone'], |
| 92 'myrcene' => $row['myrcene'], | 93 'myrcene' => $row['myrcene'], |
| 93 'hsi' => $row['hsi'], | 94 'hsi' => $row['hsi'], |
| 94 'type' => $row['type'], | 95 'type' => $hoptype[$row['type']], |
| 95 'form' => $row['form'], | 96 'form' => $hopform[$row['form']], |
| 96 'notes' => $row['notes'], | 97 'notes' => $row['notes'], |
| 97 'origin' => $row['origin'], | 98 'origin' => $row['origin'], |
| 98 'substitutes' => $row['substitutes'], | 99 'substitutes' => $row['substitutes'], |
| 99 'always_on_stock' => $row['always_on_stock'], | 100 'always_on_stock' => $row['always_on_stock'], |
| 100 'inventory' => floatval($row['inventory']) * 1000.0, | 101 'inventory' => floatval($row['inventory']) * 1000.0, |
