comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 419
- 99a7f2a6976e
- parent 411
- 077ada2dda9b
- child 422
- 7943afc0fcde
equal
deleted
inserted
replaced
| 416:0c719ea7e680 | 419:99a7f2a6976e |
|---|---|
| 125 $sql .= ", tertiary_temp='" . $_POST['tertiary_temp']; | 125 $sql .= ", tertiary_temp='" . $_POST['tertiary_temp']; |
| 126 if ($_POST['package_date'] == '') | 126 if ($_POST['package_date'] == '') |
| 127 $sql .= "', package_date=NULL"; | 127 $sql .= "', package_date=NULL"; |
| 128 else | 128 else |
| 129 $sql .= "', package_date='" . $_POST['package_date'] ."'"; | 129 $sql .= "', package_date='" . $_POST['package_date'] ."'"; |
| 130 $sql .= ", bottle_amount='" . $_POST['bottle_amount']; | 130 $sql .= ", package_volume='" . $_POST['package_volume']; |
| 131 $sql .= "', package_infuse_amount='" . $_POST['package_infuse_amount']; | |
| 132 $sql .= "', package_infuse_abv='" . $_POST['package_infuse_abv']; | |
| 133 $sql .= "', package_infuse_notes='" . mysqli_real_escape_string($connect, $_POST['package_infuse_notes']); | |
| 134 $sql .= "', package_abv='" . $_POST['package_abv']; | |
| 135 $sql .= "', bottle_amount='" . $_POST['bottle_amount']; | |
| 131 $sql .= "', bottle_carbonation='" . $_POST['bottle_carbonation']; | 136 $sql .= "', bottle_carbonation='" . $_POST['bottle_carbonation']; |
| 132 //$sql .= "', bottle_priming_sugar='" . $_POST['bottle_priming_sugar']; | 137 $sql .= "', bottle_priming_water='" . $_POST['bottle_priming_water']; |
| 133 $sql .= "', bottle_priming_amount='" . $_POST['bottle_priming_amount']; | 138 $sql .= "', bottle_priming_amount='" . $_POST['bottle_priming_amount']; |
| 134 $sql .= "', bottle_carbonation_temp='" . $_POST['bottle_carbonation_temp']; | 139 $sql .= "', bottle_carbonation_temp='" . $_POST['bottle_carbonation_temp']; |
| 135 $sql .= "', keg_amount='" . $_POST['keg_amount']; | 140 $sql .= "', keg_amount='" . $_POST['keg_amount']; |
| 136 $sql .= "', keg_carbonation='" . $_POST['keg_carbonation']; | 141 $sql .= "', keg_carbonation='" . $_POST['keg_carbonation']; |
| 137 //$sql .= "', keg_priming_sugar='" . $_POST['keg_priming_sugar']; | 142 $sql .= "', keg_priming_water='" . $_POST['keg_priming_water']; |
| 138 $sql .= "', keg_priming_amount='" . $_POST['keg_priming_amount']; | 143 $sql .= "', keg_priming_amount='" . $_POST['keg_priming_amount']; |
| 139 $sql .= "', keg_carbonation_temp='" . $_POST['keg_carbonation_temp']; | 144 $sql .= "', keg_carbonation_temp='" . $_POST['keg_carbonation_temp']; |
| 140 $sql .= "', keg_forced_carb='" . $_POST['keg_forced_carb']; | 145 $sql .= "', keg_forced_carb='" . $_POST['keg_forced_carb']; |
| 141 $sql .= "', keg_pressure='" . $_POST['keg_pressure']; | 146 $sql .= "', keg_pressure='" . $_POST['keg_pressure']; |
| 142 $sql .= "', taste_notes='" . mysqli_real_escape_string($connect, $_POST['taste_notes']); | 147 $sql .= "', taste_notes='" . mysqli_real_escape_string($connect, $_POST['taste_notes']); |
| 709 $brew .= ',"primary_end_date":"' . $row['primary_end_date']; | 714 $brew .= ',"primary_end_date":"' . $row['primary_end_date']; |
| 710 $brew .= '","secondary_temp":' . floatval($row['secondary_temp']); | 715 $brew .= '","secondary_temp":' . floatval($row['secondary_temp']); |
| 711 $brew .= ',"secondary_end_date":"' . $row['secondary_end_date']; | 716 $brew .= ',"secondary_end_date":"' . $row['secondary_end_date']; |
| 712 $brew .= '","tertiary_temp":' . floatval($row['tertiary_temp']); | 717 $brew .= '","tertiary_temp":' . floatval($row['tertiary_temp']); |
| 713 $brew .= ',"package_date":"' . $row['package_date']; | 718 $brew .= ',"package_date":"' . $row['package_date']; |
| 714 $brew .= '","bottle_amount":' . floatval($row['bottle_amount']); | 719 $brew .= '","package_volume":' . floatval($row['package_volume']); |
| 720 $brew .= ',"package_infuse_amount":' . floatval($row['package_infuse_amount']); | |
| 721 $brew .= ',"package_infuse_abv":' . floatval($row['package_infuse_abv']); | |
| 722 $brew .= ',"package_infuse_notes":"' . $row['package_infuse_notes']; | |
| 723 $brew .= '","package_abv":' . floatval($row['package_abv']); | |
| 724 $brew .= ',"bottle_amount":' . floatval($row['bottle_amount']); | |
| 715 $brew .= ',"bottle_carbonation":' . floatval($row['bottle_carbonation']); | 725 $brew .= ',"bottle_carbonation":' . floatval($row['bottle_carbonation']); |
| 716 //$brew .= ',"bottle_priming_sugar":' . $row['bottle_priming_sugar']; | 726 $brew .= ',"bottle_priming_water":' . $row['bottle_priming_water']; |
| 717 $brew .= ',"bottle_priming_amount":' . floatval($row['bottle_priming_amount']); | 727 $brew .= ',"bottle_priming_amount":' . floatval($row['bottle_priming_amount']); |
| 718 $brew .= ',"bottle_carbonation_temp":' . floatval($row['bottle_carbonation_temp']); | 728 $brew .= ',"bottle_carbonation_temp":' . floatval($row['bottle_carbonation_temp']); |
| 719 $brew .= ',"keg_amount":' . floatval($row['keg_amount']); | 729 $brew .= ',"keg_amount":' . floatval($row['keg_amount']); |
| 720 $brew .= ',"keg_carbonation":' . floatval($row['keg_carbonation']); | 730 $brew .= ',"keg_carbonation":' . floatval($row['keg_carbonation']); |
| 721 //$brew .= ',"keg_priming_sugar":' . $row['keg_priming_sugar']; | 731 $brew .= ',"keg_priming_water":' . $row['keg_priming_water']; |
| 722 $brew .= ',"keg_priming_amount":' . floatval($row['keg_priming_amount']); | 732 $brew .= ',"keg_priming_amount":' . floatval($row['keg_priming_amount']); |
| 723 $brew .= ',"keg_carbonation_temp":' . floatval($row['keg_carbonation_temp']); | 733 $brew .= ',"keg_carbonation_temp":' . floatval($row['keg_carbonation_temp']); |
| 724 $brew .= ',"keg_forced_carb":' . floatval($row['keg_forced_carb']); | 734 $brew .= ',"keg_forced_carb":' . floatval($row['keg_forced_carb']); |
| 725 $brew .= ',"keg_pressure":' . floatval($row['keg_pressure']); | 735 $brew .= ',"keg_pressure":' . floatval($row['keg_pressure']); |
| 726 $brew .= ',"taste_notes":"' . str_replace($escapers, $replacements, $row['taste_notes']); | 736 $brew .= ',"taste_notes":"' . str_replace($escapers, $replacements, $row['taste_notes']); |
