11 if (! $connect) { |
11 if (! $connect) { |
12 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
12 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
13 } |
13 } |
14 mysqli_set_charset($connect, "utf8" ); |
14 mysqli_set_charset($connect, "utf8" ); |
15 |
15 |
16 $query = "SELECT * FROM log_brews WHERE product_code='".$code."' ORDER BY datetime;"; |
16 $query = "SELECT * FROM log_brews WHERE code='".$code."' ORDER BY datetime;"; |
17 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
17 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
18 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
18 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
19 $lines[] = array( |
19 $lines[] = array( |
20 'record' => $row['record'], |
20 'record' => $row['record'], |
21 'date' => substr($row['datetime'],0,16), |
21 'date' => substr($row['datetime'],0,16), |
22 'version' => $row['version'], |
22 'version' => $row['version'], |
23 'code' => $row['product_code'], |
23 'code' => $row['code'], |
24 'name' => $row['product_name'], |
24 'name' => $row['name'], |
25 'pv_mlt' => $row['temperature_mlt'], |
25 'pv_mlt' => $row['pv_mlt'], |
26 'pv_bk' => $row['temperature_bk'], |
26 'pv_hlt' => $row['pv_hlt'], |
27 'pv_hlt' => $row['temperature_hlt'], |
27 'pv_room' => $row['pv_room'], |
28 'pv_room' => $row['temperature_room'], |
28 'sp_mlt' => $row['sp_mlt'], |
29 'sp_mlt' => $row['setpoint_mlt'], |
29 'sp_hlt' => $row['sp_hlt'], |
30 'sp_bk' => $row['setpoint_bk'], |
30 'pwm_mlt' => $row['pwm_mlt'], |
31 'sp_hlt' => $row['setpoint_hlt'], |
31 'pwm_hlt' => $row['pwm_hlt'], |
32 'event' => $row['event'] |
32 'event' => $row['event'] |
33 ); |
33 ); |
34 } |
34 } |
35 header("Content-type: application/json"); |
35 header("Content-type: application/json"); |
36 echo json_encode($lines); |
36 echo json_encode($lines); |