comparison: www/includes/db_recipes.php
www/includes/db_recipes.php
- changeset 49
- 4d27a7fb1265
- child 50
- 6d94167c2697
equal
deleted
inserted
replaced
| 48:bdd1ec9b9c06 | 49:4d27a7fb1265 |
|---|---|
| 1 <?php | |
| 2 | |
| 3 //require($_SERVER['DOCUMENT_ROOT']."/config.php"); | |
| 4 //require($_SERVER['DOCUMENT_ROOT']."/version.php"); | |
| 5 require("../config.php"); | |
| 6 require("../version.php"); | |
| 7 | |
| 8 | |
| 9 #Connect to the database | |
| 10 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); | |
| 11 if (! $connect) { | |
| 12 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | |
| 13 } | |
| 14 | |
| 15 // get data and store in a json array | |
| 16 $query = "SELECT * FROM recipes ORDER BY style_guide,style_letter,style_name,name"; | |
| 17 if (isset($_GET['insert'])) { | |
| 18 // // INSERT COMMAND | |
| 19 // $sql = "INSERT INTO `profile_mash` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | |
| 20 // $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | |
| 21 // $sql .= "', steps='" . json_encode($_GET['steps']); | |
| 22 // $sql .= "';"; | |
| 23 // $result = mysqli_query($connect, $sql); | |
| 24 // if (! $result) { | |
| 25 // syslog(LOG_NOTICE, "db_profile_mash: ".$sql." result: ".mysqli_error($connect)); | |
| 26 // } else { | |
| 27 // syslog(LOG_NOTICE, "db_profile_mash: inserted ".$_GET['name']); | |
| 28 // } | |
| 29 // echo $result; | |
| 30 | |
| 31 //} else if (isset($_GET['update'])) { | |
| 32 // // UPDATE COMMAND | |
| 33 // $sql = "UPDATE `profile_mash` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | |
| 34 // $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | |
| 35 // $sql .= "', steps='" . json_encode($_GET['steps']); | |
| 36 // $sql .= "' WHERE record='" . $_GET['record'] . "';"; | |
| 37 // $result = mysqli_query($connect, $sql); | |
| 38 // if (! $result) { | |
| 39 // syslog(LOG_NOTICE, "db_profile_mash: ".$sql." result: ".mysqli_error($connect)); | |
| 40 // } else { | |
| 41 // syslog(LOG_NOTICE, "db_profile_mash: updated record ".$_GET['record']); | |
| 42 // } | |
| 43 // echo $result; | |
| 44 | |
| 45 //} else if (isset($_GET['delete'])) { | |
| 46 // // DELETE COMMAND | |
| 47 // $sql = "DELETE FROM `profile_mash` WHERE record='".$_GET['record']."';"; | |
| 48 // $result = mysqli_query($connect, $sql); | |
| 49 // if (! $result) { | |
| 50 // syslog(LOG_NOTICE, "db_profile_mash: ".$sql." result: ".mysqli_error($connect)); | |
| 51 // } else { | |
| 52 // syslog(LOG_NOTICE, "db_profile_mash: deleted record ".$_GET['record']); | |
| 53 // } | |
| 54 // echo $result; | |
| 55 | |
| 56 } else { | |
| 57 // SELECT COMMAND | |
| 58 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | |
| 59 $recipes = '['; | |
| 60 $comma = FALSE; | |
| 61 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
| 62 // Manual encode to JSON. | |
| 63 if ($comma) { | |
| 64 $recipes .= ','; | |
| 65 } | |
| 66 $comma = TRUE; | |
| 67 $recipes .= '{"record":' . $row['record']; | |
| 68 $recipes .= ',"style_guide":"' . $row['style_guide']; | |
| 69 $recipes .= '","style_letter":"' . $row['style_letter']; | |
| 70 $recipes .= '","style_name":"' . $row['style_name']; | |
| 71 $recipes .= '","name":"' . $row['name']; | |
| 72 $recipes .= '","notes":"' . $row['notes']; | |
| 73 $recipes .= '","type":"' . $row['type']; | |
| 74 $recipes .= '","batch_size":' . floatval($row['batch_size']); | |
| 75 $recipes .= ',"boil_time":' . floatval($row['boil_time']); | |
| 76 $recipes .= ',"efficiency":' . floatval($row['efficiency']); | |
| 77 $recipes .= ',"est_og":' . floatval($row['est_og']); | |
| 78 $recipes .= ',"est_fg":' . floatval($row['est_fg']); | |
| 79 $recipes .= ',"est_color":' . floatval($row['est_color']); | |
| 80 $recipes .= ',"color_method":"' . $row['color_method']; | |
| 81 $recipes .= '","est_ibu":' . floatval($row['est_ibu']); | |
| 82 $recipes .= ',"ibu_method":"' . $row['ibu_method']; | |
| 83 $recipes .= '","fermentables":' . $row['json_fermentables']; | |
| 84 $recipes .= ',"hops":' . $row['json_hops']; | |
| 85 $recipes .= ',"miscs":' . $row['json_miscs']; | |
| 86 $recipes .= ',"yeasts":' . $row['json_yeasts']; | |
| 87 $recipes .= ',"waters":' . $row['json_waters']; | |
| 88 $recipes .= ',"mash":' . $row['json_mash']; | |
| 89 $recipes .= '}'; | |
| 90 } | |
| 91 $recipes .= ']'; | |
| 92 header("Content-type: application/json"); | |
| 93 echo $recipes; | |
| 94 } | |
| 95 ?> |
