comparison: www/prod_duplicate.php
www/prod_duplicate.php
- changeset 305
- bb55e065888a
- parent 303
- 98c2afc88780
- child 432
- 99dcd8488b62
equal
deleted
inserted
replaced
| 304:c0ca21cdd291 | 305:bb55e065888a |
|---|---|
| 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) { |
