Fri, 14 Jun 2024 10:29:21 +0200
SO4/Cl ratio using target_water and final water.
172 | 1 | <?php |
2 | ||
3 | require_once('config.php'); | |
4 | ||
5 | if (isset($_GET["code"])) | |
836
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
6 | $code = $_GET["code"]; |
172 | 7 | else |
836
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
8 | $code = "TB0015"; |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
9 | |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
10 | $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
11 | if (! $connect) { |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
12 | die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
13 | } |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
14 | mysqli_set_charset($connect, "utf8" ); |
172 | 15 | |
836
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
16 | $query = "SELECT * FROM log_fermenter WHERE code='".$code."' ORDER BY datetime;"; |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
17 | $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
18 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
19 | |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
20 | $logs[] = array( |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
21 | 'date' => substr($row['datetime'],0,16), |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
22 | 'air' => $row['temp_air'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
23 | 'beer' => $row['temp_beer'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
24 | 'chiller' => $row['temp_chiller'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
25 | 'room' => $row['temp_room'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
26 | 'tlo' => $row['sp_low'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
27 | 'thi' => $row['sp_high'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
28 | 'heater' => $row['heater_power'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
29 | 'cooler' => $row['cooler_power'], |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
30 | 'event' => $row['event'] |
409f8c497429
Switch fermenter graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
601
diff
changeset
|
31 | ); |
601
112c278be803
All graph displays now check if the log excists.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
32 | } |
112c278be803
All graph displays now check if the log excists.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
33 | |
296
69fadd1aded2
Updated design document. Add content header application/json to all scripts that produce json output. Chart prints show the beer code and name in the header. Charts don't display the menu anymore.
Michiel Broek <mbroek@mbse.eu>
parents:
194
diff
changeset
|
34 | header("Content-type: application/json"); |
172 | 35 | echo json_encode($logs); |