www/includes/db_recipes.php

changeset 147
e6e5d007eb54
parent 143
122f64716161
child 148
c0f0bbfefd63
equal deleted inserted replaced
146:2a6c00d325b2 147:e6e5d007eb54
57 $sql .= "', est_carb='" . $_POST['est_carb']; 57 $sql .= "', est_carb='" . $_POST['est_carb'];
58 $sql .= "', est_color='" . $_POST['est_color']; 58 $sql .= "', est_color='" . $_POST['est_color'];
59 $sql .= "', color_method='" . $_POST['color_method']; 59 $sql .= "', color_method='" . $_POST['color_method'];
60 $sql .= "', est_ibu='" . $_POST['est_ibu']; 60 $sql .= "', est_ibu='" . $_POST['est_ibu'];
61 $sql .= "', ibu_method='" . $_POST['ibu_method']; 61 $sql .= "', ibu_method='" . $_POST['ibu_method'];
62 $sql .= "', mash_sparge_temp='" . $_POST['mash_sparge_temp']; 62 $sql .= "', sparge_temp='" . $_POST['sparge_temp'];
63 $sql .= "', sparge_ph='" . $_POST['sparge_ph'];
64 $sql .= "', sparge_volume='" . $_POST['sparge_volume'];
65 $sql .= "', sparge_acid_type='" . $_POST['sparge_acid_type'];
66 $sql .= "', sparge_acid_perc='" . $_POST['sparge_acid_perc'];
67 $sql .= "', sparge_acid_amount='" . $_POST['sparge_acid_amount'];
63 $sql .= "', mash_ph='" . $_POST['mash_ph']; 68 $sql .= "', mash_ph='" . $_POST['mash_ph'];
64 $sql .= "', mash_name='" . $_POST['mash_name']; 69 $sql .= "', mash_name='" . $_POST['mash_name'];
70 $sql .= "', calc_acid='" . $_POST['calc_acid'];
65 syslog(LOG_NOTICE, $sql); 71 syslog(LOG_NOTICE, $sql);
66 72
67 if (isset($_POST['fermentables'])) { 73 if (isset($_POST['fermentables'])) {
68 $array = $_POST['fermentables']; 74 $array = $_POST['fermentables'];
69 foreach($array as $key => $item){ 75 foreach($array as $key => $item){
211 $recipes .= ',"est_carb":' . floatval($row['est_carb']); 217 $recipes .= ',"est_carb":' . floatval($row['est_carb']);
212 $recipes .= ',"est_color":' . floatval($row['est_color']); 218 $recipes .= ',"est_color":' . floatval($row['est_color']);
213 $recipes .= ',"color_method":"' . $row['color_method']; 219 $recipes .= ',"color_method":"' . $row['color_method'];
214 $recipes .= '","est_ibu":' . floatval($row['est_ibu']); 220 $recipes .= '","est_ibu":' . floatval($row['est_ibu']);
215 $recipes .= ',"ibu_method":"' . $row['ibu_method']; 221 $recipes .= ',"ibu_method":"' . $row['ibu_method'];
216 $recipes .= '","mash_sparge_temp":' . $row['mash_sparge_temp']; 222 $recipes .= '","sparge_temp":' . $row['sparge_temp'];
223 $recipes .= ',"sparge_ph":' . $row['sparge_ph'];
224 $recipes .= ',"sparge_volume":' . $row['sparge_volume'];
225 $recipes .= ',"sparge_acid_type":"' . $row['sparge_acid_type'];
226 $recipes .= '","sparge_acid_perc":' . $row['sparge_acid_perc'];
227 $recipes .= ',"sparge_acid_amount":' . $row['sparge_acid_amount'];
217 $recipes .= ',"mash_ph":' . $row['mash_ph']; 228 $recipes .= ',"mash_ph":' . $row['mash_ph'];
218 $recipes .= ',"mash_name":"' . $row['mash_name']; 229 $recipes .= ',"mash_name":"' . $row['mash_name'];
219 $recipes .= '","fermentables":' . $row['json_fermentables']; 230 $recipes .= '","calc_acid":' . $row['calc_acid'];
231 $recipes .= ',"fermentables":' . $row['json_fermentables'];
220 $recipes .= ',"hops":' . $row['json_hops']; 232 $recipes .= ',"hops":' . $row['json_hops'];
221 $recipes .= ',"miscs":' . $row['json_miscs']; 233 $recipes .= ',"miscs":' . $row['json_miscs'];
222 $recipes .= ',"yeasts":' . $row['json_yeasts']; 234 $recipes .= ',"yeasts":' . $row['json_yeasts'];
223 $recipes .= ',"waters":' . $row['json_waters']; 235 $recipes .= ',"waters":' . $row['json_waters'];
224 $recipes .= ',"mashs":' . $row['json_mashs']; 236 $recipes .= ',"mashs":' . $row['json_mashs'];

mercurial