I am building a few RPi with temperature sensors and they are all connected to the same lan by ethernet. Raspberry Pi 1 has address 220.127.116.11 Raspberry Pi 2 has address 18.104.22.168 Raspberry Pi 3 has address 22.214.171.124
The web server with a LAMP stack has IP address of 126.96.36.199 (I am inventing the IPs for explanation purpose).
How would I be able to log the data to the web server with a SQL statement from all RPis? For now I tried with one RPi that is running the server on localhost, but I would like for the server to be run on a machine different from the raspberry pi(s) and have the RPis log data to the database in SQL.
Any ideas? :)