|
<html lang="de"> <head> <title>StromLogger</title> <link rel="stylesheet" type="text/css" href="styles/style.css"> </head> <body> <?php // Zugangsdaten geg. anpassen $con=mysqli_connect("localhost","Tasmota","Tasmota","StromLogger"); date_default_timezone_set('Europe/Luxembourg'); // Daten sammeln $jahr=2000+date('y'); $monat = date('m'); $tag = date('j'); $stunde = date('H'); $minute = date('i'); $sekunde = date('s'); $date = $jahr; $date .= "-"; $date .= $monat; $date .= "-"; $date .= $tag; $time = $stunde; $time .= ":"; $time .= $minute; $time .= ":"; $time .= $sekunde; $in = $_GET['a']; $out = $_GET['b']; $cur = $_GET['c']; $sql = "INSERT INTO Verbrauch(Datum,Uhrzeit,Bezug,Einspeisen,Watt) VALUES('$date','$time','$in','$out','$cur')"; if (!mysqli_query($con,$sql)) { die('Fehler: ' . mysqli_error($con)); } else echo "OK"; mysqli_close($con); ?> </body> </html> |