-
Notifications
You must be signed in to change notification settings - Fork 4
/
insert_weather.php
24 lines (24 loc) · 744 Bytes
/
insert_weather.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<?php
$temp = filter_input(INPUT_GET, 'temp', FILTER_SANITIZE_NUMBER_FLOAT);
$humid = filter_input(INPUT_GET, 'humid', FILTER_SANITIZE_NUMBER_FLOAT);
if (is_null($temp) || is_null($humid) ) {
//Gravar log de erros
die("Dados inválidos");
}
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "maker";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
//Gravar log de erros
die("Não foi possível estabelecer conexão com o BD: " . $conn->connect_error);
}
$sql = "INSERT INTO weather (wea_temp, wea_humid) VALUES ($temp,$humid)";
if (!$conn->query($sql)) {
//Gravar log de erros
die("Erro na gravação dos dados no BD");
}
$conn->close();
?>