|
1 <?php |
|
2 require($_SERVER['DOCUMENT_ROOT']."/config.php"); |
|
3 require($_SERVER['DOCUMENT_ROOT']."/version.php"); |
|
4 |
|
5 #Connect to the database |
|
6 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
|
7 if (! $connect) { |
|
8 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
|
9 } |
|
10 mysqli_set_charset($connect, "utf8" ); |
|
11 |
|
12 $escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c"); |
|
13 $replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b"); |
|
14 |
|
15 $query = "SELECT * FROM profile_setup WHERE record='1'"; |
|
16 |
|
17 if (isset($_POST['update'])) { |
|
18 /* Search water record */ |
|
19 $result = mysqli_query($connect, "SELECT record FROM inventory_waters WHERE name='".$_POST['default_water']."';"); |
|
20 if ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) |
|
21 $default_water = $row['record']; |
|
22 else |
|
23 $default_water = 0; |
|
24 $sql = "UPDATE `profile_setup` SET "; |
|
25 $sql .= "brewery_name='" . mysqli_real_escape_string($connect, $_POST['brewery_name']); |
|
26 $sql .= "', factor_mashhop='" . $_POST['factor_mashhop']; |
|
27 $sql .= "', factor_fwh='" . $_POST['factor_fwh']; |
|
28 $sql .= "', factor_pellet='" . $_POST['factor_pellet']; |
|
29 $sql .= "', factor_plug='" . $_POST['factor_plug']; |
|
30 $sql .= "', color_method='" . mysqli_real_escape_string($connect, $_POST['color_method']); |
|
31 $sql .= "', ibu_method='" . mysqli_real_escape_string($connect, $_POST['ibu_method']); |
|
32 $sql .= "', brix_correction='" . $_POST['brix_correction']; |
|
33 $sql .= "', grain_absorbtion='" . $_POST['grain_absorbtion']; |
|
34 $sql .= "', default_water='" . $default_water; |
|
35 $sql .= "' WHERE record='1';"; |
|
36 // syslog(LOG_NOTICE, $sql); |
|
37 $result = mysqli_query($connect, $sql); |
|
38 if (! $result) { |
|
39 syslog(LOG_NOTICE, "db_profile_setup: ".$sql." result: ".mysqli_error($connect)); |
|
40 } else { |
|
41 syslog(LOG_NOTICE, "db_profile_setup: updated record 1"); |
|
42 } |
|
43 echo $result; |
|
44 } else { |
|
45 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
|
46 if ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
|
47 /* search water name */ |
|
48 $wresult = mysqli_query($connect, "SELECT name FROM inventory_waters WHERE record='".$row['default_water']."';"); |
|
49 if ($wrow = mysqli_fetch_array($wresult, MYSQLI_ASSOC)) |
|
50 $default_water = $wrow['name']; |
|
51 else |
|
52 $default_water = ''; |
|
53 $data = '{"record":' . $row['record']; |
|
54 $data .= ',"brewery_name":"' . str_replace($escapers, $replacements, $row['brewery_name']); |
|
55 $data .= '","factor_mashhop":' . $row['factor_mashhop']; |
|
56 $data .= ',"factor_fwh":' . $row['factor_fwh']; |
|
57 $data .= ',"factor_pellet":' . $row['factor_pellet']; |
|
58 $data .= ',"factor_plug":' . $row['factor_plug']; |
|
59 $data .= ',"ibu_method":"' . str_replace($escapers, $replacements, $row['ibu_method']); |
|
60 $data .= '","color_method":"' . str_replace($escapers, $replacements, $row['color_method']); |
|
61 $data .= '","brix_correction":' . floatval($row['brix_correction']); |
|
62 $data .= ',"grain_absorbtion":' . floatval($row['grain_absorbtion']); |
|
63 $data .= ',"default_water":"' . str_replace($escapers, $replacements, $default_water); |
|
64 $data .= '"}'; |
|
65 } |
|
66 header("Content-type: application/json"); |
|
67 echo $data; |
|
68 } |
|
69 ?> |