How To Publish Data To A Raspberry Pi LAMP Server
This session we will learn how to build an ESP32 client that makes an HTTP POST request to a Raspberry Pi LAMP server (Linux, Apache, MySQL, PHP).
The Raspberry Pi has a PHP script to insert data (sensor readings) into a MySQL database.
You’ll also have a web page that displays the sensor readings, timestamps and other information stored in the database. You can view your data locally from any browser in your network.
We will complete this project in 5 parts over several sessions :
1. Hosting Your PHP Application and MySQL Database – Raspberry Pi,
2. Preparing Your MySQL Database,
3. PHP Script HTTP POST – Insert Data in MySQL Database,
4. PHP Script – Display Database Content,
5. Preparing Your ESP32 or ESP8266,