www/includes/db_recipes.php

changeset 94
295c3af2a421
parent 80
75b9227fb98c
child 130
601920b902e5
equal deleted inserted replaced
93:357d59d8ec5e 94:295c3af2a421
48 $sql .= "', st_abv_max='" . $_POST['st_abv_max']; 48 $sql .= "', st_abv_max='" . $_POST['st_abv_max'];
49 $sql .= "', name='" . mysqli_real_escape_string($connect, $_POST['name']); 49 $sql .= "', name='" . mysqli_real_escape_string($connect, $_POST['name']);
50 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']); 50 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']);
51 $sql .= "', type='" . $_POST['type']; 51 $sql .= "', type='" . $_POST['type'];
52 $sql .= "', batch_size='" . $_POST['batch_size']; 52 $sql .= "', batch_size='" . $_POST['batch_size'];
53 $sql .= "', boil_size='" . $_POST['boil_size'];
53 $sql .= "', boil_time='" . $_POST['boil_time']; 54 $sql .= "', boil_time='" . $_POST['boil_time'];
54 $sql .= "', efficiency='" . $_POST['efficiency']; 55 $sql .= "', efficiency='" . $_POST['efficiency'];
55 $sql .= "', est_og='" . $_POST['est_og']; 56 $sql .= "', est_og='" . $_POST['est_og'];
56 $sql .= "', est_fg='" . $_POST['est_fg']; 57 $sql .= "', est_fg='" . $_POST['est_fg'];
57 $sql .= "', est_abv='" . $_POST['est_abv']; 58 $sql .= "', est_abv='" . $_POST['est_abv'];
194 $recipes .= ',"st_abv_max":' . floatval($row['st_abv_max']); 195 $recipes .= ',"st_abv_max":' . floatval($row['st_abv_max']);
195 $recipes .= ',"name":"' . str_replace($escapers, $replacements, $row['name']); 196 $recipes .= ',"name":"' . str_replace($escapers, $replacements, $row['name']);
196 $recipes .= '","notes":"' . str_replace($escapers, $replacements, $row['notes']); 197 $recipes .= '","notes":"' . str_replace($escapers, $replacements, $row['notes']);
197 $recipes .= '","type":"' . $row['type']; 198 $recipes .= '","type":"' . $row['type'];
198 $recipes .= '","batch_size":' . floatval($row['batch_size']); 199 $recipes .= '","batch_size":' . floatval($row['batch_size']);
200 $recipes .= ',"boil_size":' . floatval($row['boil_size']);
199 $recipes .= ',"boil_time":' . floatval($row['boil_time']); 201 $recipes .= ',"boil_time":' . floatval($row['boil_time']);
200 $recipes .= ',"efficiency":' . floatval($row['efficiency']); 202 $recipes .= ',"efficiency":' . floatval($row['efficiency']);
201 $recipes .= ',"est_og":' . floatval($row['est_og']); 203 $recipes .= ',"est_og":' . floatval($row['est_og']);
202 $recipes .= ',"est_fg":' . floatval($row['est_fg']); 204 $recipes .= ',"est_fg":' . floatval($row['est_fg']);
203 $recipes .= ',"est_abv":' . floatval($row['est_abv']); 205 $recipes .= ',"est_abv":' . floatval($row['est_abv']);

mercurial