Store temperature data from Domoticz in mySQL for historical analyses

storetemps.php

<?php
define('sqlserver','127.0.0.1');
define('sqluser','domotica');
define('sqlpassword','domotica');
define('sqldatabase','domotica');
define('updatedatabase',true);//Set to false once the database is created, set to true to add devices
define('domoticzip','127.0.0.1');
define('domoticzport','8080');
define('numberofhours',1);//Defines how many hours of detailed data is updated in _day table. Set to a high number for initial run.
define('numberofdays',1);//Defindes how many days of min,avg and max is updated in _month table. Set to a high number for initial run.
define('devices',array(231,236,238,573,588,1260,1475));//IDXs of temperature devices
define('sleep',10000);//Defines how many microseconds of sleep there should be between queries, can be usefull on low power devices
if (updatedatabase) {
	createupdatedatabase();
}
$db=new mysqli(sqlserver,sqluser,sqlpassword,sqldatabase);
if ($db->connect_errno>0) {
	die('Unable to connect to database ['.$db->connect_error.']');
}
foreach (devices as $idx) {
	$device=json_decode(
		file_get_contents(
			'http://'.domoticzip.':'.domoticzport.'/json.htm?type=devices&rid='.$idx),
		true
	);
	if (!empty($device['result'][0]['Name'])) {
		$name=$device['result'][0]['Name'];
		$day=json_decode(
			file_get_contents(
				'http://'.domoticzip.':'.domoticzport.'/json.htm?type=graph&sensor=temp&idx='.$idx.'&range=day'),
			true
		);
		if (!empty($day['result'])) {
			foreach ($day['result'] as $i) {
				$stamp=$i['d'];
				if(strtotime($stamp)>time()-(3600*numberofhours)){
					$temp=$i['te'];
					$query="INSERT INTO `temp_day` (`stamp`,`$name`) 
						VALUES ('$stamp','$temp') 
						ON DUPLICATE KEY UPDATE `$name`='$temp'";
					echo $query.'<br>';
					if (!$result=$db->query($query)) {
						echo('There was an error running the query "'.$query.'" - '.$db->error);
					}
					usleep(sleep);
				}
			}
		}
		usleep(sleep);
		$month=json_decode(
			file_get_contents(
				'http://'.domoticzip.':'.domoticzport.'/json.htm?type=graph&sensor=temp&idx='.$idx.'&range=month'),
			true
		);
		if (!empty($month['result'])) {
			foreach ($month['result'] as $i) {
				$stamp=$i['d'];
				if (strtotime($stamp)>time()-(86400*numberofdays)) {
					$min=$i['tm'];
					$avg=$i['ta'];
					$max=$i['te'];
					$cmin=$name.'_min';
					$cavg=$name.'_avg';
					$cmax=$name.'_max';
					$query="INSERT INTO `temp_month` (`stamp`,`$cmin`,`$cavg`,`$cmax`) 
						VALUES ('$stamp','$min','$avg','$max') 
						ON DUPLICATE KEY UPDATE `$cmin`='$min',`$cavg`='$avg',`$cmax`='$max'";
					echo $query.'<br>';
					if (!$result=$db->query($query)) {
						echo('There was an error running the query "'.$query.'" - '.$db->error);
					}
					usleep(sleep);
				}
			}
		}
		usleep(sleep);
	}
}

function createupdatedatabase()
{
	$db=new mysqli(sqlserver,sqluser,sqlpassword,sqldatabase);
	if ($db->connect_errno>0){
		die('Unable to connect to database ['.$db->connect_error.']');
	}
	$sqldatabase=sqldatabase;
	$result=mysqli_fetch_assoc(
		mysqli_query(
			$db,
			"SELECT count(*) as count 
			FROM information_schema.TABLES 
			WHERE (TABLE_SCHEMA = '$sqldatabase') 
				AND (TABLE_NAME = 'temp_day')"
		)
	);
	if ($result['count']==0) {
		$query="CREATE TABLE temp_day (
			stamp datetime PRIMARY KEY
			)";
		if (!$result=$db->query($query)) {
			die('There was an error running the query ['.$query.' - '.$db->error.']');
		}
	}
	foreach (devices as $idx) {
		$device=json_decode(
			file_get_contents(
				'http://'.domoticzip.':'.domoticzport.'/json.htm?type=devices&rid='.$idx),
			true
		);
		if (!empty($device['result'][0]['Name'])) {
			$name=$device['result'][0]['Name'];
			$result=mysqli_fetch_assoc(
				mysqli_query(
					$db,
					"SELECT COLUMN_TYPE 
						FROM INFORMATION_SCHEMA.COLUMNS 
						WHERE table_name = 'temp_day' 
							AND COLUMN_NAME = '$name';"
				)
			);
			if ($result['COLUMN_TYPE']!='float(3,1)') {
				$query="ALTER TABLE `temp_day`  ADD `$name` FLOAT(3,1) NULL;";
				if (!$result=$db->query($query)) {
					die('There was an error running the query ['.$query.' - '.$db->error.']');
				}
			}
		}
	}
	$result=mysqli_fetch_assoc(
		mysqli_query(
			$db,
			"SELECT count(*) as count 
			FROM information_schema.TABLES 
			WHERE (TABLE_SCHEMA = '$sqldatabase') 
			AND (TABLE_NAME = 'temp_month')"
		)
	);
	if ($result['count']==0) {
		$query="CREATE TABLE temp_month (
			stamp date PRIMARY KEY
			)";
		if (!$result=$db->query($query)) {
			die('There was an error running the query ['.$query.' - '.$db->error.']');
		}
	}
	foreach (devices as $idx) {
		$device=json_decode(
			file_get_contents(
				'http://'.domoticzip.':'.domoticzport.'/json.htm?type=devices&rid='.$idx),
			true
		);
		if (!empty($device['result'][0]['Name'])) {
			$name=$device['result'][0]['Name'];
			$tables=array($name.'_min',$name.'_avg',$name.'_max');
			foreach ($tables as $table) {
				$result=mysqli_fetch_assoc(
					mysqli_query(
						$db,
						"SELECT COLUMN_TYPE 
						FROM INFORMATION_SCHEMA.COLUMNS 
						WHERE table_name = 'temp_month' 
							AND COLUMN_NAME = '$table';"
					)
				);
				if ($result['COLUMN_TYPE']!='float(3,1)') {
					$query="ALTER TABLE `temp_month`  ADD `$table` FLOAT(3,1) NULL;";
					if (!$result=$db->query($query)) {
						die('There was an error running the query ['.$query.' - '.$db->error.']');
					}
				}
			}
		}
	}
}
?>

I've tried it and it works for me.
I would like to modify this script to store temperature and humidity.
I will run cron every 5 minutes.
Simply send only the temperature and humidity.

I need it to store this in this database:

Data send to MYSQL:

sqldatabase: TMEP
table: tme
column teplota = Temp
column vlhkost = Humidity
column kdy = date and time

Domoticz Devices:
Idx: 641
Hardware: Netatmo temperature
ID: AE67
Unit: 0
Name: Mučeníkov 1
Type: Temp + Humidity
SubType: WTGR800
Data: 7.9 C, 63 %

Can you please edit this script for me? I don't have the same programming knowledge.
Thank you very much for your help.

He wanted to use it for my site: https://kkweb.sk/teplota/

Source Code: https://github.com/MultiTricker/TMEP
Demo page: http://www.roudnice.eu/index.php?ja=en&je=C

Humidity is in 'hu' of the json, so $hum=$i['hu']
Then you also need to change the tables to have columns for that and update the queries.

So far, only the temperature works for me, I couldn't give the moisture.

INSERT INTO tme (kdy,teplota) VALUES ('2021-04-26 12:00','9.2') ON DUPLICATE KEY UPDATE teplota='9.2'