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); ?>