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 22.214.171.124 Raspberry Pi 2 has address 126.96.36.199 Raspberry Pi 3 has address 188.8.131.52
The web server with a LAMP stack has IP address of 184.108.40.206 (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? :)