Xiaomi Mijia lywsd03mmc - Versionsgeschichte

Gabriel am 29. August 2023 um 19:16 Uhr

2023-08-29T19:16:05Z

@@ Zeile 482: / Zeile 482: @@
 #echo($_POST["addr"]);
 ?>
 </source>

Gabriel am 29. August 2023 um 19:14 Uhr

2023-08-29T19:14:20Z

@@ Zeile 417: / Zeile 417: @@
 #echo($addr[$_GET["id"]]);
+}
 ?>
 </source>

Gabriel am 29. August 2023 um 19:09 Uhr

2023-08-29T19:09:26Z

← Nächstältere Version		Version vom 29. August 2023, 19:09 Uhr
Zeile 287:		Zeile 287:
	}		}

			</source>


			Database structure:

			<source lang="bash">
			Current database: innenklima

			mysql> show tables;
			+----------------------+
			\| Tables_in_innenklima \|
			+----------------------+
			\| Bad \|
			\| Dachboden \|
			\| Gaestezimmer \|
			...
			+----------------------+
			12 rows in set (0,01 sec)

			mysql> describe Bad;
			+-------------+-------+------+-----+---------+-------+
			\| Field \| Type \| Null \| Key \| Default \| Extra \|
			+-------------+-------+------+-----+---------+-------+
			\| timestamp \| int \| NO \| PRI \| NULL \| \|
			\| temperature \| float \| YES \| \| NULL \| \|
			\| humidity \| float \| YES \| \| NULL \| \|
			\| abshumidity \| float \| YES \| \| NULL \| \|
			+-------------+-------+------+-----+---------+-------+
			4 rows in set (0,05 sec)


			</source>


			webserver files:


			sensoren.php
			<source lang="PHP">
			<?php
			require_once __DIR__ . '/dicts.php';

			#for t_rh.php
			function nameFromID($id){
			return $names[$id];
			}

			function readNextId(){
			$filename = 'next.txt';
			return intval(file_get_contents($filename));
			}

			function incrementId($id,$addr){
			$filename = 'next.txt';
			$f = fopen($filename, 'w');

			if($addr[$id]=="end" or count($addr)<=($id)){
			$n=1;
			}else{
			$n=$id+1;
			}
			fwrite($f,$n);
			fclose($f);
			}


			#for ESP32 https call
			if($_POST["type"]=="addr"){
			$id=readNextId();
			echo ($addr[$id]);
			incrementId($id,$addr);
			}else{
			echo($names[$_GET["id"]]);
			echo "<br>";
			echo($addr[$_GET["id"]]);
			}
			?>

			</source>

			dicts.php:

			<source lang="PHP">
			<?php

			$names=array(
			1=>"Dachboden",
			2=>"Wintergarten",
			3=>"Bad",
			4=>"Wohnzimmer",
			5=>"Gaestezimmer",
			6=>"Naehzimmer",
			7=>"Schlafzimmer",
			8=>"Waschkueche",
			9=>"Kueche",
			10=>"KuecheUnten",
			11=>"Garage",
			12=>"end"

			);

			$addr=array(
			1=>"A4:C1:38:EB:2C:14",
			2=>"A4:C1:38:FF:28:B4",
			3=>"A4:C1:38:2A:CE:FE",
			4=>"A4:C1:38:B1:21:FD",
			5=>"A4:C1:38:98:C1:16",
			6=>"A4:C1:38:CE:B6:5D",
			7=>"A4:C1:38:B6:80:4C",
			8=>"A4:C1:38:5E:55:5E",
			9=>"A4:C1:38:09:5C:AF",
			10=>"A4:C1:38:AE:ED:3C",
			11=>"A4:C1:38:0D:0B:54",
			12=>"end"
			);

			#for t_rh.php





			#for ESP32 https call
			if($_POST["type"]=="addr"){
			echo ($addr[$_POST["id"]]);
			}else{
			#echo($names[$_GET["id"]]);
			#echo "<br>";
			#echo($addr[$_GET["id"]]);
			}
			?>
	</source>		</source>

Gabriel am 29. August 2023 um 19:03 Uhr

2023-08-29T19:03:16Z

Änderungen zeigen

Gabriel: Die Seite wurde neu angelegt: „Xiaomi Mijia lywsd03mmc“

2023-08-29T18:49:24Z

Die Seite wurde neu angelegt: „Xiaomi Mijia lywsd03mmc“

Neue Seite

Xiaomi Mijia lywsd03mmc