comparison: www/includes/db_recipes.php
www/includes/db_recipes.php
- changeset 51
- 7224109adfe1
- parent 50
- 6d94167c2697
- child 52
- b1f2a893572f
equal
deleted
inserted
replaced
| 50:6d94167c2697 | 51:7224109adfe1 |
|---|---|
| 14 | 14 |
| 15 $escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c"); | 15 $escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c"); |
| 16 $replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b"); | 16 $replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b"); |
| 17 | 17 |
| 18 // get data and store in a json array | 18 // get data and store in a json array |
| 19 $query = "SELECT * FROM recipes ORDER BY style_guide,style_letter,style_name,name"; | 19 $query = "SELECT * FROM recipes ORDER BY st_guide,st_letter,st_name,name"; |
| 20 if (isset($_GET['insert'])) { | 20 if (isset($_GET['insert'])) { |
| 21 // // INSERT COMMAND | 21 // // INSERT COMMAND |
| 22 // $sql = "INSERT INTO `profile_mash` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | 22 // $sql = "INSERT INTO `profile_mash` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
| 23 // $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | 23 // $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); |
| 24 // $sql .= "', steps='" . json_encode($_GET['steps']); | 24 // $sql .= "', steps='" . json_encode($_GET['steps']); |
| 66 if ($comma) { | 66 if ($comma) { |
| 67 $recipes .= ','; | 67 $recipes .= ','; |
| 68 } | 68 } |
| 69 $comma = TRUE; | 69 $comma = TRUE; |
| 70 $recipes .= '{"record":' . $row['record']; | 70 $recipes .= '{"record":' . $row['record']; |
| 71 $recipes .= ',"style_guide":"' . str_replace($escapers, $replacements, $row['style_guide']); | 71 $recipes .= ',"st_guide":"' . str_replace($escapers, $replacements, $row['st_guide']); |
| 72 $recipes .= '","style_letter":"' . str_replace($escapers, $replacements, $row['style_letter']); | 72 $recipes .= '","st_letter":"' . str_replace($escapers, $replacements, $row['st_letter']); |
| 73 $recipes .= '","style_name":"' . str_replace($escapers, $replacements, $row['style_name']); | 73 $recipes .= '","st_name":"' . str_replace($escapers, $replacements, $row['st_name']); |
| 74 $recipes .= '","name":"' . str_replace($escapers, $replacements, $row['name']); | 74 $recipes .= '","st_og_min":' . floatval($row['st_og_min']); |
| 75 $recipes .= ',"st_og_max":' . floatval($row['st_og_max']); | |
| 76 $recipes .= ',"st_fg_min":' . floatval($row['st_fg_min']); | |
| 77 $recipes .= ',"st_fg_max":' . floatval($row['st_fg_max']); | |
| 78 $recipes .= ',"st_ibu_min":' . floatval($row['st_ibu_min']); | |
| 79 $recipes .= ',"st_ibu_max":' . floatval($row['st_ibu_max']); | |
| 80 $recipes .= ',"st_color_min":' . floatval($row['st_color_min']); | |
| 81 $recipes .= ',"st_color_max":' . floatval($row['st_color_max']); | |
| 82 $recipes .= ',"st_carb_min":' . floatval($row['st_carb_min']); | |
| 83 $recipes .= ',"st_carb_max":' . floatval($row['st_carb_max']); | |
| 84 $recipes .= ',"st_abv_min":' . floatval($row['st_abv_min']); | |
| 85 $recipes .= ',"st_abv_max":' . floatval($row['st_abv_max']); | |
| 86 $recipes .= ',"name":"' . str_replace($escapers, $replacements, $row['name']); | |
| 75 $recipes .= '","notes":"' . str_replace($escapers, $replacements, $row['notes']); | 87 $recipes .= '","notes":"' . str_replace($escapers, $replacements, $row['notes']); |
| 76 $recipes .= '","type":"' . $row['type']; | 88 $recipes .= '","type":"' . $row['type']; |
| 77 $recipes .= '","batch_size":' . floatval($row['batch_size']); | 89 $recipes .= '","batch_size":' . floatval($row['batch_size']); |
| 78 $recipes .= ',"boil_time":' . floatval($row['boil_time']); | 90 $recipes .= ',"boil_time":' . floatval($row['boil_time']); |
| 79 $recipes .= ',"efficiency":' . floatval($row['efficiency']); | 91 $recipes .= ',"efficiency":' . floatval($row['efficiency']); |
| 81 $recipes .= ',"est_fg":' . floatval($row['est_fg']); | 93 $recipes .= ',"est_fg":' . floatval($row['est_fg']); |
| 82 $recipes .= ',"est_color":' . floatval($row['est_color']); | 94 $recipes .= ',"est_color":' . floatval($row['est_color']); |
| 83 $recipes .= ',"color_method":"' . $row['color_method']; | 95 $recipes .= ',"color_method":"' . $row['color_method']; |
| 84 $recipes .= '","est_ibu":' . floatval($row['est_ibu']); | 96 $recipes .= '","est_ibu":' . floatval($row['est_ibu']); |
| 85 $recipes .= ',"ibu_method":"' . $row['ibu_method']; | 97 $recipes .= ',"ibu_method":"' . $row['ibu_method']; |
| 98 $recipes .= '","mash_sparge_temp":' . $row['mash_sparge_temp']; | |
| 99 $recipes .= ',"mash_ph":' . $row['mash_ph']; | |
| 100 $recipes .= ',"mash_name":"' . $row['mash_name']; | |
| 86 $recipes .= '","fermentables":' . $row['json_fermentables']; | 101 $recipes .= '","fermentables":' . $row['json_fermentables']; |
| 87 $recipes .= ',"hops":' . $row['json_hops']; | 102 $recipes .= ',"hops":' . $row['json_hops']; |
| 88 $recipes .= ',"miscs":' . $row['json_miscs']; | 103 $recipes .= ',"miscs":' . $row['json_miscs']; |
| 89 $recipes .= ',"yeasts":' . $row['json_yeasts']; | 104 $recipes .= ',"yeasts":' . $row['json_yeasts']; |
| 90 $recipes .= ',"waters":' . $row['json_waters']; | 105 $recipes .= ',"waters":' . $row['json_waters']; |
| 91 $recipes .= ',"mash":' . $row['json_mash']; | 106 $recipes .= ',"mashs":' . $row['json_mashs']; |
| 92 $recipes .= '}'; | 107 $recipes .= '}'; |
| 93 } | 108 } |
| 94 $recipes .= ']'; | 109 $recipes .= ']'; |
| 95 header("Content-type: application/json"); | 110 header("Content-type: application/json"); |
| 96 echo $recipes; | 111 echo $recipes; |
