|
1 <?php |
|
2 |
|
3 require_once('config.php'); |
|
4 |
|
5 if (isset($_GET["code"])) |
|
6 $code = $_GET["code"]; |
|
7 else |
|
8 $code = "CB0068"; |
|
9 |
|
10 $query = "SELECT datetime,temperature_air,temperature_beer,temperature_chiller,temperature_room,target_low,target_high,heater_power,cooler_power FROM log_fermentation WHERE product_code='".$code."'"; |
|
11 $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
|
12 if (! $connect) { |
|
13 echo "[]"; |
|
14 return; |
|
15 } |
|
16 $result = mysqli_query($connect, $query); |
|
17 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
|
18 $logs[] = array( |
|
19 'date' => $row['datetime'], |
|
20 'air' => $row['temperature_air'], |
|
21 'beer' => $row['temperature_beer'], |
|
22 'chiller' => $row['temperature_chiller'], |
|
23 'room' => $row['temperature_room'], |
|
24 'tlo' => $row['target_low'], |
|
25 'thi' => $row['target_high'], |
|
26 'heater' => $row['heater_power'], |
|
27 'cooler' => $row['cooler_power'] |
|
28 ); |
|
29 } |
|
30 echo json_encode($logs); |