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 |
195 $sql .= "', prop2_volume='" . $row['prop2_volume']; |
198 $sql .= "', prop2_volume='" . $row['prop2_volume']; |
196 $sql .= "', prop3_type='" . $row['prop3_type']; |
199 $sql .= "', prop3_type='" . $row['prop3_type']; |
197 $sql .= "', prop3_volume='" . $row['prop3_volume']; |
200 $sql .= "', prop3_volume='" . $row['prop3_volume']; |
198 $sql .= "', prop4_type='" . $row['prop4_type']; |
201 $sql .= "', prop4_type='" . $row['prop4_type']; |
199 $sql .= "', prop4_volume='" . $row['prop4_volume']; |
202 $sql .= "', prop4_volume='" . $row['prop4_volume']; |
200 $sql .= "', json_fermentables='" . $row['json_fermentables']; |
203 $sql .= "', json_fermentables='" . str_replace($rescapers,$rreplacements,$row['json_fermentables']); |
201 $sql .= "', json_hops='" . $row['json_hops']; |
204 $sql .= "', json_hops='" . str_replace($rescapers,$rreplacements,$row['json_hops']); |
202 $sql .= "', json_miscs='" . $row['json_miscs']; |
205 $sql .= "', json_miscs='" . str_replace($rescapers,$rreplacements,$row['json_miscs']); |
203 $sql .= "', json_yeasts='" . $row['json_yeasts']; |
206 $sql .= "', json_yeasts='" . str_replace($rescapers,$rreplacements,$row['json_yeasts']); |
204 $sql .= "', json_mashs='" . $row['json_mashs']; |
207 $sql .= "', json_mashs='" . str_replace($rescapers,$rreplacements,$row['json_mashs']); |
205 $sql .= "';"; |
208 $sql .= "';"; |
206 syslog(LOG_NOTICE, $sql); |
209 syslog(LOG_NOTICE, $sql); |
207 |
210 |
208 $result = mysqli_query($link, $sql); |
211 $result = mysqli_query($link, $sql); |
209 if (! $result) { |
212 if (! $result) { |