comparison: www/includes/db_setup.php
www/includes/db_setup.php
- changeset 625
- 57bc32b5f411
- parent 446
- ee7bcfb8e270
- child 768
- ae1195153fa2
equal
deleted
inserted
replaced
| 624:7509f9ed5686 | 625:57bc32b5f411 |
|---|---|
| 32 $sql .= "', color_method='" . $_POST['color_method']; | 32 $sql .= "', color_method='" . $_POST['color_method']; |
| 33 $sql .= "', ibu_method='" . $_POST['ibu_method']; | 33 $sql .= "', ibu_method='" . $_POST['ibu_method']; |
| 34 $sql .= "', brix_correction='" . $_POST['brix_correction']; | 34 $sql .= "', brix_correction='" . $_POST['brix_correction']; |
| 35 $sql .= "', grain_absorbtion='" . $_POST['grain_absorbtion']; | 35 $sql .= "', grain_absorbtion='" . $_POST['grain_absorbtion']; |
| 36 $sql .= "', default_water='" . $default_water; | 36 $sql .= "', default_water='" . $default_water; |
| 37 $sql .= "', my_yeastlab='" . $_POST['my_yeastlab']; | |
| 37 $sql .= "' WHERE record='1';"; | 38 $sql .= "' WHERE record='1';"; |
| 38 //syslog(LOG_NOTICE, $sql); | 39 //syslog(LOG_NOTICE, $sql); |
| 39 $result = mysqli_query($connect, $sql); | 40 $result = mysqli_query($connect, $sql); |
| 40 if (! $result) { | 41 if (! $result) { |
| 41 syslog(LOG_NOTICE, "db_profile_setup: ".$sql." result: ".mysqli_error($connect)); | 42 syslog(LOG_NOTICE, "db_profile_setup: ".$sql." result: ".mysqli_error($connect)); |
| 63 $data .= ',"ibu_method":' . $row['ibu_method']; | 64 $data .= ',"ibu_method":' . $row['ibu_method']; |
| 64 $data .= ',"color_method":' . $row['color_method']; | 65 $data .= ',"color_method":' . $row['color_method']; |
| 65 $data .= ',"brix_correction":' . floatval($row['brix_correction']); | 66 $data .= ',"brix_correction":' . floatval($row['brix_correction']); |
| 66 $data .= ',"grain_absorbtion":' . floatval($row['grain_absorbtion']); | 67 $data .= ',"grain_absorbtion":' . floatval($row['grain_absorbtion']); |
| 67 $data .= ',"default_water":"' . str_replace($escapers, $replacements, $default_water); | 68 $data .= ',"default_water":"' . str_replace($escapers, $replacements, $default_water); |
| 69 $data .= '","my_yeastlab":"' . str_replace($escapers, $replacements, $row['my_yeastlab']); | |
| 68 $data .= '"}'; | 70 $data .= '"}'; |
| 69 } | 71 } |
| 70 header("Content-type: application/json"); | 72 header("Content-type: application/json"); |
| 71 echo $data; | 73 echo $data; |
| 72 } | 74 } |
