comparison: www/includes/db_setup.php
www/includes/db_setup.php
- changeset 768
- ae1195153fa2
- parent 625
- 57bc32b5f411
equal
deleted
inserted
replaced
| 767:08c0343b622b | 768:ae1195153fa2 |
|---|---|
| 9 } | 9 } |
| 10 mysqli_set_charset($connect, "utf8" ); | 10 mysqli_set_charset($connect, "utf8" ); |
| 11 | 11 |
| 12 $escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c"); | 12 $escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c"); |
| 13 $replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b"); | 13 $replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b"); |
| 14 | |
| 15 $response = array( | |
| 16 'error' => false, | |
| 17 'msg' => 'Ok', | |
| 18 ); | |
| 14 | 19 |
| 15 $query = "SELECT * FROM profile_setup WHERE record='1'"; | 20 $query = "SELECT * FROM profile_setup WHERE record='1'"; |
| 16 | 21 |
| 17 if (isset($_POST['update'])) { | 22 if (isset($_POST['update'])) { |
| 18 /* Search water record */ | 23 /* Search water record */ |
| 34 $sql .= "', brix_correction='" . $_POST['brix_correction']; | 39 $sql .= "', brix_correction='" . $_POST['brix_correction']; |
| 35 $sql .= "', grain_absorbtion='" . $_POST['grain_absorbtion']; | 40 $sql .= "', grain_absorbtion='" . $_POST['grain_absorbtion']; |
| 36 $sql .= "', default_water='" . $default_water; | 41 $sql .= "', default_water='" . $default_water; |
| 37 $sql .= "', my_yeastlab='" . $_POST['my_yeastlab']; | 42 $sql .= "', my_yeastlab='" . $_POST['my_yeastlab']; |
| 38 $sql .= "' WHERE record='1';"; | 43 $sql .= "' WHERE record='1';"; |
| 39 //syslog(LOG_NOTICE, $sql); | |
| 40 $result = mysqli_query($connect, $sql); | 44 $result = mysqli_query($connect, $sql); |
| 41 if (! $result) { | 45 if (! $result) { |
| 42 syslog(LOG_NOTICE, "db_profile_setup: ".$sql." result: ".mysqli_error($connect)); | 46 syslog(LOG_NOTICE, "db_profile_setup: ".$sql." result: ".mysqli_error($connect)); |
| 43 } else { | 47 $response['error'] = true; |
| 44 syslog(LOG_NOTICE, "db_profile_setup: updated record 1"); | 48 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
| 45 } | 49 } |
| 46 echo $result; | 50 exit(json_encode($response)); |
| 51 | |
| 47 } else { | 52 } else { |
| 48 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | 53 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
| 49 if ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | 54 if ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 50 /* search water name */ | 55 /* search water name */ |
| 51 $wresult = mysqli_query($connect, "SELECT name FROM inventory_waters WHERE record='".$row['default_water']."';"); | 56 $wresult = mysqli_query($connect, "SELECT name FROM inventory_waters WHERE record='".$row['default_water']."';"); |
| 68 $data .= ',"default_water":"' . str_replace($escapers, $replacements, $default_water); | 73 $data .= ',"default_water":"' . str_replace($escapers, $replacements, $default_water); |
| 69 $data .= '","my_yeastlab":"' . str_replace($escapers, $replacements, $row['my_yeastlab']); | 74 $data .= '","my_yeastlab":"' . str_replace($escapers, $replacements, $row['my_yeastlab']); |
| 70 $data .= '"}'; | 75 $data .= '"}'; |
| 71 } | 76 } |
| 72 header("Content-type: application/json"); | 77 header("Content-type: application/json"); |
| 73 echo $data; | 78 exit($data); |
| 74 } | 79 } |
| 75 ?> | 80 ?> |
