comparison: www/includes/db_profile_fermentation.php
www/includes/db_profile_fermentation.php
- changeset 736
- d3d8e3b30a34
- parent 716
- 57118e6a4bdb
- child 762
- bc3cfd98a212
equal
deleted
inserted
replaced
| 735:23d972f5d784 | 736:d3d8e3b30a34 |
|---|---|
| 8 if (! $connect) { | 8 if (! $connect) { |
| 9 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | 9 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
| 10 } | 10 } |
| 11 mysqli_set_charset($connect, "utf8" ); | 11 mysqli_set_charset($connect, "utf8" ); |
| 12 | 12 |
| 13 $escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c"); | |
| 14 $replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b"); | |
| 15 $rescapers = array("'"); | 13 $rescapers = array("'"); |
| 16 $rreplacements = array("\\'"); | 14 $rreplacements = array("\\'"); |
| 17 | 15 |
| 18 if (isset($_POST['insert']) || isset($_POST['update'])) { | 16 if (isset($_POST['insert']) || isset($_POST['update'])) { |
| 19 if (isset($_POST['insert'])) { | 17 if (isset($_POST['insert'])) { |
| 88 } | 86 } |
| 89 echo $result; | 87 echo $result; |
| 90 | 88 |
| 91 } else { | 89 } else { |
| 92 // SELECT COMMAND | 90 // SELECT COMMAND |
| 93 $query = "SELECT * FROM profile_fermentation ORDER BY name;"; | 91 $query = "SELECT record,JSON_QUOTE(uuid),JSON_QUOTE(name),inittemp_lo,inittemp_hi,fridgemode,totalsteps,duration,steps "; |
| 92 $query .= "FROM profile_fermentation ORDER BY name;"; | |
| 94 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | 93 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
| 95 $profiles = '['; | 94 $profiles = '['; |
| 96 $comma = FALSE; | 95 $comma = FALSE; |
| 97 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | 96 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 98 // Manual encode to JSON. | 97 // Manual encode to JSON. |
| 99 if ($comma) { | 98 if ($comma) { |
| 100 $profiles .= ','; | 99 $profiles .= ','; |
| 101 } | 100 } |
| 102 $comma = TRUE; | 101 $comma = TRUE; |
| 103 $profiles .= '{"record":' . $row['record']; | 102 $profiles .= '{"record":' . $row['record']; |
| 104 $profiles .= ',"uuid":"' . $row['uuid']; | 103 $profiles .= ',"uuid":' . $row['JSON_QUOTE(uuid)']; |
| 105 $profiles .= '","name":"' . str_replace($escapers, $replacements, $row['name']); | 104 $profiles .= ',"name":' . $row['JSON_QUOTE(name)']; |
| 106 $profiles .= '","inittemp_lo":' . $row['inittemp_lo']; | 105 $profiles .= ',"inittemp_lo":' . $row['inittemp_lo']; |
| 107 $profiles .= ',"inittemp_hi":' . $row['inittemp_hi']; | 106 $profiles .= ',"inittemp_hi":' . $row['inittemp_hi']; |
| 108 $profiles .= ',"fridgemode":' . $row['fridgemode']; | 107 $profiles .= ',"fridgemode":' . $row['fridgemode']; |
| 109 $profiles .= ',"totalsteps":' . $row['totalsteps']; | 108 $profiles .= ',"totalsteps":' . $row['totalsteps']; |
| 110 $profiles .= ',"duration":' . $row['duration']; | 109 $profiles .= ',"duration":' . $row['duration']; |
| 111 $profiles .= ',"steps":' . $row['steps']; | 110 $profiles .= ',"steps":' . $row['steps']; |
