comparison: www/includes/db_setup.php
www/includes/db_setup.php
- changeset 289
- 4082c41f45e9
- parent 99
- f433193f7bb6
- child 446
- ee7bcfb8e270
equal
deleted
inserted
replaced
| 288:06dd071a429d | 289:4082c41f45e9 |
|---|---|
| 25 $sql .= "brewery_name='" . mysqli_real_escape_string($connect, $_POST['brewery_name']); | 25 $sql .= "brewery_name='" . mysqli_real_escape_string($connect, $_POST['brewery_name']); |
| 26 $sql .= "', factor_mashhop='" . $_POST['factor_mashhop']; | 26 $sql .= "', factor_mashhop='" . $_POST['factor_mashhop']; |
| 27 $sql .= "', factor_fwh='" . $_POST['factor_fwh']; | 27 $sql .= "', factor_fwh='" . $_POST['factor_fwh']; |
| 28 $sql .= "', factor_pellet='" . $_POST['factor_pellet']; | 28 $sql .= "', factor_pellet='" . $_POST['factor_pellet']; |
| 29 $sql .= "', factor_plug='" . $_POST['factor_plug']; | 29 $sql .= "', factor_plug='" . $_POST['factor_plug']; |
| 30 $sql .= "', color_method='" . mysqli_real_escape_string($connect, $_POST['color_method']); | 30 $sql .= "', factor_wethop='" . $_POST['factor_wethop']; |
| 31 $sql .= "', ibu_method='" . mysqli_real_escape_string($connect, $_POST['ibu_method']); | 31 $sql .= "', color_method='" . $_POST['color_method']; |
| 32 $sql .= "', ibu_method='" . $_POST['ibu_method']; | |
| 32 $sql .= "', brix_correction='" . $_POST['brix_correction']; | 33 $sql .= "', brix_correction='" . $_POST['brix_correction']; |
| 33 $sql .= "', grain_absorbtion='" . $_POST['grain_absorbtion']; | 34 $sql .= "', grain_absorbtion='" . $_POST['grain_absorbtion']; |
| 34 $sql .= "', default_water='" . $default_water; | 35 $sql .= "', default_water='" . $default_water; |
| 35 $sql .= "' WHERE record='1';"; | 36 $sql .= "' WHERE record='1';"; |
| 36 // syslog(LOG_NOTICE, $sql); | 37 //syslog(LOG_NOTICE, $sql); |
| 37 $result = mysqli_query($connect, $sql); | 38 $result = mysqli_query($connect, $sql); |
| 38 if (! $result) { | 39 if (! $result) { |
| 39 syslog(LOG_NOTICE, "db_profile_setup: ".$sql." result: ".mysqli_error($connect)); | 40 syslog(LOG_NOTICE, "db_profile_setup: ".$sql." result: ".mysqli_error($connect)); |
| 40 } else { | 41 } else { |
| 41 syslog(LOG_NOTICE, "db_profile_setup: updated record 1"); | 42 syslog(LOG_NOTICE, "db_profile_setup: updated record 1"); |
| 54 $data .= ',"brewery_name":"' . str_replace($escapers, $replacements, $row['brewery_name']); | 55 $data .= ',"brewery_name":"' . str_replace($escapers, $replacements, $row['brewery_name']); |
| 55 $data .= '","factor_mashhop":' . $row['factor_mashhop']; | 56 $data .= '","factor_mashhop":' . $row['factor_mashhop']; |
| 56 $data .= ',"factor_fwh":' . $row['factor_fwh']; | 57 $data .= ',"factor_fwh":' . $row['factor_fwh']; |
| 57 $data .= ',"factor_pellet":' . $row['factor_pellet']; | 58 $data .= ',"factor_pellet":' . $row['factor_pellet']; |
| 58 $data .= ',"factor_plug":' . $row['factor_plug']; | 59 $data .= ',"factor_plug":' . $row['factor_plug']; |
| 59 $data .= ',"ibu_method":"' . str_replace($escapers, $replacements, $row['ibu_method']); | 60 $data .= ',"factor_wethop":' . $row['factor_wethop']; |
| 60 $data .= '","color_method":"' . str_replace($escapers, $replacements, $row['color_method']); | 61 $data .= ',"ibu_method":' . $row['ibu_method']; |
| 61 $data .= '","brix_correction":' . floatval($row['brix_correction']); | 62 $data .= ',"color_method":' . $row['color_method']; |
| 63 $data .= ',"brix_correction":' . floatval($row['brix_correction']); | |
| 62 $data .= ',"grain_absorbtion":' . floatval($row['grain_absorbtion']); | 64 $data .= ',"grain_absorbtion":' . floatval($row['grain_absorbtion']); |
| 63 $data .= ',"default_water":"' . str_replace($escapers, $replacements, $default_water); | 65 $data .= ',"default_water":"' . str_replace($escapers, $replacements, $default_water); |
| 64 $data .= '"}'; | 66 $data .= '"}'; |
| 65 } | 67 } |
| 66 header("Content-type: application/json"); | 68 header("Content-type: application/json"); |
