Fri, 14 Jun 2024 10:29:21 +0200
SO4/Cl ratio using target_water and final water.
507
17f244137a9b
Add refermentation logfile and graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1 | <?php |
17f244137a9b
Add refermentation logfile and graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
2 | |
17f244137a9b
Add refermentation logfile and graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
3 | require_once('config.php'); |
17f244137a9b
Add refermentation logfile and graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
4 | |
17f244137a9b
Add refermentation logfile and graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
5 | if (isset($_GET["code"])) |
838
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
6 | $code = $_GET["code"]; |
507
17f244137a9b
Add refermentation logfile and graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
7 | else |
838
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
8 | $code = "CB0080"; |
507
17f244137a9b
Add refermentation logfile and graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
9 | |
17f244137a9b
Add refermentation logfile and graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
10 | |
838
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
11 | $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
12 | if (! $connect) { |
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
13 | die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
14 | } |
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
15 | mysqli_set_charset($connect, "utf8" ); |
507
17f244137a9b
Add refermentation logfile and graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
16 | |
838
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
17 | $query = "SELECT * FROM log_co2pressure WHERE code='".$code."' ORDER BY datetime;"; |
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
18 | $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
19 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
20 | |
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
21 | $logs[] = array( |
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
22 | 'date' => substr($row['datetime'],0,16), |
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
23 | 'temperature' => $row['temperature'], |
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
24 | 'pressure' => $row['pressure'] |
ce5f39b66a51
Switch co2pressure graph to MySQL
Michiel Broek <mbroek@mbse.eu>
parents:
600
diff
changeset
|
25 | ); |
507
17f244137a9b
Add refermentation logfile and graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
26 | } |
17f244137a9b
Add refermentation logfile and graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
27 | header("Content-type: application/json"); |
17f244137a9b
Add refermentation logfile and graph.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
28 | echo json_encode($logs); |