www/includes/db_recipes.php

changeset 156
35860890224c
parent 154
ef298b5aa994
child 166
635033a29c48
equal deleted inserted replaced
155:041af8a82d77 156:35860890224c
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 .= "', sparge_temp='" . $_POST['sparge_temp']; 62 $sql .= "', sparge_temp='" . $_POST['sparge_temp'];
63 $sql .= "', sparge_ph='" . $_POST['sparge_ph']; 63 $sql .= "', sparge_ph='" . $_POST['sparge_ph'];
64 $sql .= "', sparge_volume='" . $_POST['sparge_volume']; 64 $sql .= "', sparge_volume='" . $_POST['sparge_volume'];
65 // $sql .= "', sparge_acid_type='" . $_POST['sparge_acid_type']; 65 $sql .= "', sparge_source='" . $_POST['sparge_source'];
66 // $sql .= "', sparge_acid_perc='" . $_POST['sparge_acid_perc']; 66 $sql .= "', sparge_acid_type='" . $_POST['sparge_acid_type'];
67 // $sql .= "', sparge_acid_amount='" . $_POST['sparge_acid_amount']; 67 $sql .= "', sparge_acid_perc='" . $_POST['sparge_acid_perc'];
68 $sql .= "', sparge_acid_amount='" . $_POST['sparge_acid_amount'];
68 $sql .= "', mash_ph='" . $_POST['mash_ph']; 69 $sql .= "', mash_ph='" . $_POST['mash_ph'];
69 $sql .= "', mash_name='" . $_POST['mash_name']; 70 $sql .= "', mash_name='" . $_POST['mash_name'];
70 $sql .= "', calc_acid='" . $_POST['calc_acid']; 71 ($_POST['calc_acid'] == 'true') ? $sql .= "', calc_acid='1" : $sql .= "', calc_acid='0";
71 if (isset($_POST['w1_name'])) { 72 if (isset($_POST['w1_name'])) {
72 $sql .= "', w1_name='" . mysqli_real_escape_string($connect, $_POST['w1_name']); 73 $sql .= "', w1_name='" . mysqli_real_escape_string($connect, $_POST['w1_name']);
73 $sql .= "', w1_amount='" . $_POST['w1_amount']; 74 $sql .= "', w1_amount='" . $_POST['w1_amount'];
74 $sql .= "', w1_calcium='" . $_POST['w1_calcium']; 75 $sql .= "', w1_calcium='" . $_POST['w1_calcium'];
75 $sql .= "', w1_sulfate='" . $_POST['w1_sulfate']; 76 $sql .= "', w1_sulfate='" . $_POST['w1_sulfate'];
233 $recipes .= '","est_ibu":' . floatval($row['est_ibu']); 234 $recipes .= '","est_ibu":' . floatval($row['est_ibu']);
234 $recipes .= ',"ibu_method":"' . $row['ibu_method']; 235 $recipes .= ',"ibu_method":"' . $row['ibu_method'];
235 $recipes .= '","sparge_temp":' . $row['sparge_temp']; 236 $recipes .= '","sparge_temp":' . $row['sparge_temp'];
236 $recipes .= ',"sparge_ph":' . $row['sparge_ph']; 237 $recipes .= ',"sparge_ph":' . $row['sparge_ph'];
237 $recipes .= ',"sparge_volume":' . $row['sparge_volume']; 238 $recipes .= ',"sparge_volume":' . $row['sparge_volume'];
238 $recipes .= ',"sparge_acid_type":"' . $row['sparge_acid_type']; 239 $recipes .= ',"sparge_source":"' . $row['sparge_source'];
240 $recipes .= '","sparge_acid_type":"' . $row['sparge_acid_type'];
239 $recipes .= '","sparge_acid_perc":' . $row['sparge_acid_perc']; 241 $recipes .= '","sparge_acid_perc":' . $row['sparge_acid_perc'];
240 $recipes .= ',"sparge_acid_amount":' . $row['sparge_acid_amount']; 242 $recipes .= ',"sparge_acid_amount":' . $row['sparge_acid_amount'];
241 $recipes .= ',"mash_ph":' . $row['mash_ph']; 243 $recipes .= ',"mash_ph":' . $row['mash_ph'];
242 $recipes .= ',"mash_name":"' . $row['mash_name']; 244 $recipes .= ',"mash_name":"' . $row['mash_name'];
243 $recipes .= '","calc_acid":' . $row['calc_acid']; 245 $recipes .= '","calc_acid":' . $row['calc_acid'];

mercurial