";
} else {
die( 'Could not connect: ' . mysqli_error($conn) );
}
// {"device_id":"myesp32_1","value_1":"aaa","value_2":"bbb"}
$data = json_decode(file_get_contents("php://input"));
$datetime = $data->datetime;
$deviceid = $data->device_id;
$temp = $data->temp;
$humidity = $data->humidity;
$h2s = $data->h2s;
$tvoc = $data->tvoc;
$eco2 = $data->eco2;
$nh3 = $data->nh3;
$co = $data->co;
$ch4 = $data->ch4;
$pm1_0 = $data->pm1_0;
$pm2_5 = $data->pm2_5;
$pm10 = $data->pm10;
$ver = $data->ver;
//$ipaddr = $data->ipaddr;
$lat = $data->lat;:
$lng = $data->lng;
$alt = $data->alt;
if( $temp < -20 ) {
$temp = -20;
}
if (!isset($lat) || $lat === null) $lat = 37.854;
if (!isset($lng) || $lng === null) $lng = 127.726;
if (!isset($alt) || $alt === null) $alt = 75;
// @@ ==================================================================== @@ //
// datetime 비교, 마지막 저장된 시간과 비교하여 5분 이상 차이나는 경우만 저장
$sql_time = "select datetime from ns40_1 where deviceid='$deviceid' order by num desc limit 1";
$result_time = mysqli_query($conn, $sql_time);
$row_time = mysqli_fetch_array($result_time);
//echo $row_time['datetime'];
date_default_timezone_set('Asia/Seoul');
//date_default_timezone_set('Asia/Ho_Chi_Minh');
$date = date('Y-m-d H:i:s', time());
//echo $date;
$gapMin = (int)((strtotime($date) - strtotime($row_time['datetime'])) / 60);
//echo $gapMin."분 차이";
if($gapMin > 4) {
if(empty($datetime) != true || empty($deviceid) != true) {
$sql = "INSERT INTO ns40_1" .
"(num, datetime, deviceid, temp, humidity, h2s, tvoc, eco2, nh3, co, ch4, pm1_0, pm2_5, pm10, ver)" .
"VALUES" .
"(null, '$datetime', '$deviceid', '$temp', '$humidity', '$h2s', '$tvoc', '$eco2', '$nh3', '$co', " .
"'$ch4', '$pm1_0', '$pm2_5', '$pm10', '$ver', '$lat', $lng', '$alt')";
$result = mysqli_query($conn, $sql);
if($result) {
echo "insert success!";
} else {
echo "failure";
}
}
}
?>