7 } |
7 } |
8 if (! mysqli_set_charset($link, "utf8" )) { |
8 if (! mysqli_set_charset($link, "utf8" )) { |
9 echo "error"; |
9 echo "error"; |
10 return 1; |
10 return 1; |
11 } |
11 } |
|
12 |
|
13 $rescapers = array("'"); |
|
14 $rreplacements = array("\\'"); |
12 |
15 |
13 date_default_timezone_set('Europe/Amsterdam'); |
16 date_default_timezone_set('Europe/Amsterdam'); |
14 if (isset($_GET["record"])) |
17 if (isset($_GET["record"])) |
15 $record = $_GET["record"]; |
18 $record = $_GET["record"]; |
16 else |
19 else |
88 $sql .= "', w2_ph='" . $row['w2_ph']; |
91 $sql .= "', w2_ph='" . $row['w2_ph']; |
89 $sql .= "', w2_cost='" . $row['w2_cost']; |
92 $sql .= "', w2_cost='" . $row['w2_cost']; |
90 $sql .= "', wa_acid_name='" . $row['wa_acid_name']; |
93 $sql .= "', wa_acid_name='" . $row['wa_acid_name']; |
91 $sql .= "', wa_acid_perc='" . $row['wa_acid_perc']; |
94 $sql .= "', wa_acid_perc='" . $row['wa_acid_perc']; |
92 $sql .= "', wa_base_name='" . $row['wa_base_name']; |
95 $sql .= "', wa_base_name='" . $row['wa_base_name']; |
93 $sql .= "', json_fermentables='" . $row['json_fermentables']; |
96 $sql .= "', json_fermentables='" . str_replace($rescapers,$rreplacements,$row['json_fermentables']); |
94 $sql .= "', json_hops='" . $row['json_hops']; |
97 $sql .= "', json_hops='" . str_replace($rescapers,$rreplacements,$row['json_hops']); |
95 $sql .= "', json_miscs='" . $row['json_miscs']; |
98 $sql .= "', json_miscs='" . str_replace($rescapers,$rreplacements,$row['json_miscs']); |
96 $sql .= "', json_yeasts='" . $row['json_yeasts']; |
99 $sql .= "', json_yeasts='" . str_replace($rescapers,$rreplacements,$row['json_yeasts']); |
97 $sql .= "', json_mashs='" . $row['json_mashs']; |
100 $sql .= "', json_mashs='" . str_replace($rescapers,$rreplacements,$row['json_mashs']); |
98 $sql .= "';"; |
101 $sql .= "';"; |
99 syslog(LOG_NOTICE, $sql); |
102 syslog(LOG_NOTICE, $sql); |
100 |
103 |
101 $result = mysqli_query($link, $sql); |
104 $result = mysqli_query($link, $sql); |
102 if (! $result) { |
105 if (! $result) { |