comparison: www/includes/db_recipes.php
www/includes/db_recipes.php
- changeset 72
- 93a0be4f5be3
- parent 71
- e1c50b21b7e3
- child 77
- a9f8de2d7b2b
equal
deleted
inserted
replaced
| 71:e1c50b21b7e3 | 72:93a0be4f5be3 |
|---|---|
| 28 } | 28 } |
| 29 // Basic settings | 29 // Basic settings |
| 30 $sql .= "st_name='" . mysqli_real_escape_string($connect, $_POST['st_name']); | 30 $sql .= "st_name='" . mysqli_real_escape_string($connect, $_POST['st_name']); |
| 31 $sql .= "', st_letter='" . mysqli_real_escape_string($connect, $_POST['st_letter']); | 31 $sql .= "', st_letter='" . mysqli_real_escape_string($connect, $_POST['st_letter']); |
| 32 $sql .= "', st_guide='" . mysqli_real_escape_string($connect, $_POST['st_guide']); | 32 $sql .= "', st_guide='" . mysqli_real_escape_string($connect, $_POST['st_guide']); |
| 33 // st_category st_category_number st_type | 33 $sql .= "', st_type='" . mysqli_real_escape_string($connect, $_POST['st_type']); |
| 34 $sql .= "', st_category='" . mysqli_real_escape_string($connect, $_POST['st_categpry']); | |
| 35 $sql .= "', st_category_number='" . $_POST['st_category_number']; | |
| 34 $sql .= "', st_og_min='" . $_POST['st_og_min']; | 36 $sql .= "', st_og_min='" . $_POST['st_og_min']; |
| 35 $sql .= "', st_og_max='" . $_POST['st_og_max']; | 37 $sql .= "', st_og_max='" . $_POST['st_og_max']; |
| 36 $sql .= "', st_fg_min='" . $_POST['st_fg_min']; | 38 $sql .= "', st_fg_min='" . $_POST['st_fg_min']; |
| 37 $sql .= "', st_fg_max='" . $_POST['st_fg_max']; | 39 $sql .= "', st_fg_max='" . $_POST['st_fg_max']; |
| 38 $sql .= "', st_ibu_min='" . $_POST['st_ibu_min']; | 40 $sql .= "', st_ibu_min='" . $_POST['st_ibu_min']; |
| 49 $sql .= "', batch_size='" . $_POST['batch_size']; | 51 $sql .= "', batch_size='" . $_POST['batch_size']; |
| 50 $sql .= "', boil_time='" . $_POST['boil_time']; | 52 $sql .= "', boil_time='" . $_POST['boil_time']; |
| 51 $sql .= "', efficiency='" . $_POST['efficiency']; | 53 $sql .= "', efficiency='" . $_POST['efficiency']; |
| 52 $sql .= "', est_og='" . $_POST['est_og']; | 54 $sql .= "', est_og='" . $_POST['est_og']; |
| 53 $sql .= "', est_fg='" . $_POST['est_fg']; | 55 $sql .= "', est_fg='" . $_POST['est_fg']; |
| 56 $sql .= "', est_abv='" . $_POST['est_abv']; | |
| 57 $sql .= "', est_carb='" . $_POST['est_carb']; | |
| 54 $sql .= "', est_color='" . $_POST['est_color']; | 58 $sql .= "', est_color='" . $_POST['est_color']; |
| 55 $sql .= "', color_method='" . $_POST['color_method']; | 59 $sql .= "', color_method='" . $_POST['color_method']; |
| 56 $sql .= "', est_ibu='" . $_POST['est_ibu']; | 60 $sql .= "', est_ibu='" . $_POST['est_ibu']; |
| 57 $sql .= "', ibu_method='" . $_POST['ibu_method']; | 61 $sql .= "', ibu_method='" . $_POST['ibu_method']; |
| 58 $sql .= "', mash_sparge_temp='" . $_POST['mash_sparge_temp']; | 62 $sql .= "', mash_sparge_temp='" . $_POST['mash_sparge_temp']; |
| 138 syslog(LOG_NOTICE, "db_recipes: result: ".mysqli_error($connect)); | 142 syslog(LOG_NOTICE, "db_recipes: result: ".mysqli_error($connect)); |
| 139 } else { | 143 } else { |
| 140 if (isset($_POST['update'])) { | 144 if (isset($_POST['update'])) { |
| 141 syslog(LOG_NOTICE, "db_recipes: updated record ".$_POST['record']); | 145 syslog(LOG_NOTICE, "db_recipes: updated record ".$_POST['record']); |
| 142 } else { | 146 } else { |
| 143 syslog(LOG_NOTICE, "db_recipes: inserted ".$_POST['name']); | 147 $lastid = mysqli_insert_id($connect); |
| 148 syslog(LOG_NOTICE, "db_recipes: inserted record ".$lastid); | |
| 144 } | 149 } |
| 145 } | 150 } |
| 146 echo $result; | 151 echo $result; |
| 147 | 152 |
| 148 } else if (isset($_POST['delete'])) { | 153 } else if (isset($_POST['delete'])) { |
| 149 // DELETE COMMAND | 154 // DELETE COMMAND |
| 150 $sql = "DELETE FROM `recipes` WHERE record='".$_POST['record']."';"; | 155 $sql = "DELETE FROM `recipes` WHERE record='".$_POST['record']."';"; |
| 151 $result = mysqli_query($connect, $sql); | 156 $result = mysqli_query($connect, $sql); |
| 152 if (! $result) { | 157 if (! $result) { |
| 153 // syslog(LOG_NOTICE, "db_recipes: ".$sql." result: ".mysqli_error($connect)); | |
| 154 syslog(LOG_NOTICE, "db_recipes: result: ".mysqli_error($connect)); | 158 syslog(LOG_NOTICE, "db_recipes: result: ".mysqli_error($connect)); |
| 155 } else { | 159 } else { |
| 156 syslog(LOG_NOTICE, "db_recipes: deleted record ".$_POST['record']); | 160 syslog(LOG_NOTICE, "db_recipes: deleted record ".$_POST['record']); |
| 157 } | 161 } |
| 158 echo $result; | 162 echo $result; |
| 170 $comma = TRUE; | 174 $comma = TRUE; |
| 171 $recipes .= '{"record":' . $row['record']; | 175 $recipes .= '{"record":' . $row['record']; |
| 172 $recipes .= ',"st_guide":"' . str_replace($escapers, $replacements, $row['st_guide']); | 176 $recipes .= ',"st_guide":"' . str_replace($escapers, $replacements, $row['st_guide']); |
| 173 $recipes .= '","st_letter":"' . str_replace($escapers, $replacements, $row['st_letter']); | 177 $recipes .= '","st_letter":"' . str_replace($escapers, $replacements, $row['st_letter']); |
| 174 $recipes .= '","st_name":"' . str_replace($escapers, $replacements, $row['st_name']); | 178 $recipes .= '","st_name":"' . str_replace($escapers, $replacements, $row['st_name']); |
| 175 $recipes .= '","st_og_min":' . floatval($row['st_og_min']); | 179 $recipes .= '","st_type":"' . str_replace($escapers, $replacements, $row['st_type']); |
| 180 $recipes .= '","st_category":"' . str_replace($escapers, $replacements, $row['st_category']); | |
| 181 $recipes .= '","st_category_number":' . floatval($row['st_category_number']); | |
| 182 $recipes .= ',"st_og_min":' . floatval($row['st_og_min']); | |
| 176 $recipes .= ',"st_og_max":' . floatval($row['st_og_max']); | 183 $recipes .= ',"st_og_max":' . floatval($row['st_og_max']); |
| 177 $recipes .= ',"st_fg_min":' . floatval($row['st_fg_min']); | 184 $recipes .= ',"st_fg_min":' . floatval($row['st_fg_min']); |
| 178 $recipes .= ',"st_fg_max":' . floatval($row['st_fg_max']); | 185 $recipes .= ',"st_fg_max":' . floatval($row['st_fg_max']); |
| 179 $recipes .= ',"st_ibu_min":' . floatval($row['st_ibu_min']); | 186 $recipes .= ',"st_ibu_min":' . floatval($row['st_ibu_min']); |
| 180 $recipes .= ',"st_ibu_max":' . floatval($row['st_ibu_max']); | 187 $recipes .= ',"st_ibu_max":' . floatval($row['st_ibu_max']); |
| 190 $recipes .= '","batch_size":' . floatval($row['batch_size']); | 197 $recipes .= '","batch_size":' . floatval($row['batch_size']); |
| 191 $recipes .= ',"boil_time":' . floatval($row['boil_time']); | 198 $recipes .= ',"boil_time":' . floatval($row['boil_time']); |
| 192 $recipes .= ',"efficiency":' . floatval($row['efficiency']); | 199 $recipes .= ',"efficiency":' . floatval($row['efficiency']); |
| 193 $recipes .= ',"est_og":' . floatval($row['est_og']); | 200 $recipes .= ',"est_og":' . floatval($row['est_og']); |
| 194 $recipes .= ',"est_fg":' . floatval($row['est_fg']); | 201 $recipes .= ',"est_fg":' . floatval($row['est_fg']); |
| 202 $recipes .= ',"est_abv":' . floatval($row['est_abv']); | |
| 203 $recipes .= ',"est_carb":' . floatval($row['est_carb']); | |
| 195 $recipes .= ',"est_color":' . floatval($row['est_color']); | 204 $recipes .= ',"est_color":' . floatval($row['est_color']); |
| 196 $recipes .= ',"color_method":"' . $row['color_method']; | 205 $recipes .= ',"color_method":"' . $row['color_method']; |
| 197 $recipes .= '","est_ibu":' . floatval($row['est_ibu']); | 206 $recipes .= '","est_ibu":' . floatval($row['est_ibu']); |
| 198 $recipes .= ',"ibu_method":"' . $row['ibu_method']; | 207 $recipes .= ',"ibu_method":"' . $row['ibu_method']; |
| 199 $recipes .= '","mash_sparge_temp":' . $row['mash_sparge_temp']; | 208 $recipes .= '","mash_sparge_temp":' . $row['mash_sparge_temp']; |
