Interesting thermometer to share a website

Configuration
1

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

Must be downloaded from https://github.com/MultiTricker/TMEP clone or download.

Copy the app directory to your WebServer and you can rename it for example to temperatur

Example: http://yourdomena.com/temperatur/

Create a TMEP database on the server and import the mysql-db-full.sql file

Set the database login name and password in the config.php file

When everything is done correctly the website is displayed.

That’s all about installing the program.

My sensors:

Entity ID
sensor.netatmo_kezmarok_mucenikov_259_1_obyvacka_outdoor_temperature
sensor.netatmo_kezmarok_mucenikov_259_1_obyvacka_outdoor_humidity

How can I send data to the database?

MariaDB:192.168.1.200:3306
Database name: TMEP
Table: tme

kdy = when day and time (example 2019-09-20 13:15:00 )
teplota = temperature °C (example 10.9 )
vlhkost = humidity (example 60.8 )

Can anyone help me create a script?

2

I can’t help you with that. But one thing i have to share. Your sensors are talking to me. They tell me, where to find you… :smiley:

image
image1449×961 417 KB

3

work out the MySQL command to insert the data, then do a Shell command to insert the data.

Run the resulting service every X seconds.

4

:smiley: Yes, you guessed it

5

Well thank you.

Can you show me an example? I haven’t done it yet.

6

There are hundreds of mysql resources on the internet. No one is going to give you a lesson here. Why not ask on the github page for that database you want to use?

7

I already have a database. I just don’t know how to send the temperature to the database. I wrote it at the beginning.

8

And I told you to ask on their github what mysql command you need to run to insert the data. I cannot read whatever language they are using.