unsigned long timenow;

void setup() {
Serial.begin(115200);
delay(10);
Serial.println();
Serial.println();
Serial.print("Connecting to ");
Serial.println(ssid);
WiFi.mode(WIFI_STA);
WiFi.begin(ssid, password);

while (WiFi.status() != WL_CONNECTED) {
delay(500);
Serial.print(".");
}

Serial.println("");
Serial.println("WiFi connected");
Serial.println("IP address: ");
Serial.println(WiFi.localIP());

dht.begin();
}
void loop() {
sendSensor();
delay(9876);
delay(9876);
delay(9876);
}

void sendSensor()
{
float h = dht.readHumidity();
float t = dht.readTemperature(); // or dht.readTemperature(true) for Fahrenheit

timenow = millis();
if (isnan(h) || isnan(t)) {
Serial.println("Failed to read from DHT sensor!");
Serial.println(h);
Serial.println(t);

return;
}else{
Serial.print(timenow); Serial.print(": ");
Serial.print(h); Serial.print("% rH, ");
Serial.print(t); Serial.println("°C");
}

echo $location;
echo $humidity;
echo $temperature;
}else{trigger_error("No temperature given", E_USER_ERROR);}
}else{trigger_error("No humidity given", E_USER_ERROR);}
}else{trigger_error("No location given", E_USER_ERROR);}

$servername = "localhost";
$username = "nope";
$password = "double-nope";
$dbname = "weather";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$t = time();
$timedb = $t - ($t % 60);
$col1 = "hum_".$location;
$col2 = "temp_".$location;

$sql = "INSERT IGNORE INTO weatherdata (time)
VALUES (FROM_UNIXTIME($timedb))";
if ($conn->query($sql) === TRUE) { } //else { echo "Error: " . $sql . "<br>" . $conn->error;}

$sql2 = "UPDATE weatherdata SET
$col1 = $humidity,
$col2 = $temperature
WHERE time = FROM_UNIXTIME($timedb)";

if ($conn->query($sql2) === TRUE) { } //else { echo "Error: " . $sql . "<br>" . $conn->error;}

$servername = "localhost";
$username = "nope";
$password = "I_said_nope?";
$dbname = "weather";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$plimit = 1000; // sql limit
$arr_time = array();
$arr_hum = array();
$arr_temp = array();
$colquery1 = "hum_".$location;
$colquery2 = "temp_".$location;
if ($result = $conn->query("SELECT UNIX_TIMESTAMP(time) as time, $colquery1 as hum, $colquery2 as temp FROM weather.weatherdata ORDER BY time DESC LIMIT $plimit;")) {
while($row = $result->fetch_array(MYSQLI_ASSOC)) {
$arr_time[] = $row['time']*1000;
$arr_hum[] = $row['hum'];
$arr_temp[] = $row['temp'];
}
$y = sizeof($arr_time);
echo "[";
for ($x=0; $x<($y-1); $x++){
echo "[".$arr_time[$x].",";
if(is_null($arr_hum[$x])){echo "null";}else{echo $arr_hum[$x];}
echo ",";
if(is_null($arr_temp[$x])){echo "null";}else{echo $arr_temp[$x];}
echo "],";
}
echo "[".$arr_time[$x].",";
if(is_null($arr_hum[$x])){echo "null";}else{echo $arr_hum[$x];}
echo ",";
if(is_null($arr_temp[$x])){echo "null";}else{echo $arr_temp[$x];}
echo "]]";
}

var seriesOptions = [],
seriesCounter = 0,
names = ['BAD', 'WZ', 'KUE', 'SZ', 'OUT'];
var processed_json1 = new Array();
var processed_json2 = new Array();

$.each(names, function (i, name) {
$.getJSON('http://192.168.2.96/getdata2.php?loc=' + name.toLowerCase(), function (data) {

processed_json1[i] = [];
processed_json2[i] = [];
seriesOptions[i] = {
name: name,
data: data
};

for (ii = 0; ii < data.length; ii++){
processed_json1[i].push([data[ii][0],data[ii][1]]);
processed_json2[i].push([data[ii][0],data[ii][2]]);
}

;
// As we're loading the data asynchronously, we don't know what order it will arrive. So
// we keep a counter and create the chart when all the data is loaded.
seriesCounter += 1;

if (seriesCounter === names.length) {
createChart();
}
});
});

function createChart() {

$('#container').highcharts({
chart: {
type: "spline"
},
title: {
text: "Logged temperature/humidity data"
},
xAxis: {
type: 'datetime',
dateTimeLabelFormats: {
day: '%e of %b'
},
allowDecimals: true,
title: {
text: ""
}
},

yAxis: [{
title: {
text: "Temperature [°C]"
}
}, {
title: {
text: "rel. humidity [%]"
},
opposite: true
}],
tooltip: {
crosshairs: [true,true],
xDateFormat: '%b %e %Y, %H:%M',
},
series: [{
name: 'Humidity @ Bathroom ',
data: processed_json1[0],
yAxis: 1,
tooltip: {
valueSuffix: '%'
}
},
{
name: 'Humidity @ Living Room',
data: processed_json1[1],
yAxis: 1,
tooltip: {
valueSuffix: '%'
}
},
{
name: 'Humidity @ Kitchen',
data: processed_json1[2],
yAxis: 1,
tooltip: {
valueSuffix: '%'
}
},
{
name: 'Humidity @ Bedroom',
data: processed_json1[3],
yAxis: 1,
tooltip: {
valueSuffix: '%'
}
},
{
name: 'Humidity @ Patio',
data: processed_json1[4],
yAxis: 1,
tooltip: {
valueSuffix: '%'
}
},
{
name: 'Temperature @ Bathroom ',
data: processed_json2[0],
tooltip: {
valueSuffix: '°C'
}
},
{
name: 'Temperature @ Living Room',
data: processed_json2[1],
tooltip: {
valueSuffix: '°C'
}
},
{
name: 'Temperature @ Kitchen',
data: processed_json2[2],
tooltip: {
valueSuffix: '°C'
}
},
{
name: 'Temperature @ Bedroom',
data: processed_json2[3],
tooltip: {
valueSuffix: '°C'
}
},
{
name: 'Temperature @ Patio',
data: processed_json2[4],
tooltip: {
valueSuffix: '°C'
}
}]
});
};

</script>
</head>
<body>

<div id="container" style="height: 700px"></div>