Das ist noch html
";
echo "Not that easy to do an sql-injection =)"."
";
die("Stopped");
}
$timestamp = time()+3600; //bei sommerzeit 2h hinter UTC. IM WINTER UNBEDINGT AUF 3600 FÜR 1H ÄNDERN
//echo $timestamp."
";
$datum = date("Y-m-d", $timestamp);
$time = date("H:i:s", $timestamp);
// connect to mysql database using mysqli
$connect = mysqli_connect($hostname, $username, $password, $databaseName);
if (!$connect) {
die("Connection failed: " . mysqli_connect_error());
}
// mysql query to insert data
$query = "INSERT INTO FeinstaubVonPi (ID, Datum, Zeit, Breitengrad, Langengrad, PM25, PM10, temperature, humidity, pressure, windSpeed, windAngle, clouds) VALUES
($id,'$datum','$time',$y,$x,$pm25,$pm10,$temp,$humi,$pres,0,0,0)";
//echo $query;
// check if mysql query successful
//echo $query."
";
if(mysqli_query($connect,$query))
{
//echo 'Data Inserted';
}
else{
echo "Error: " . $query . "
" . mysqli_error($connect);
}
mysqli_close($connect);
?>