Visualize Your Sensor Readings from Anywhere in the World (ESP32/ESP8266 + MySQL + PHP)

In this project, you'll create a web page that displays sensor readings in a plot that you can access from anywhere in the world. In summary, you’ll build an ESP32 or ESP8266 client that makes a request to a PHP script to publish sensor readings in a MySQL database.

Like my page on Facebook:
Follow me on twitter:

Subscribe for more projects like this!

#IoT #ESP32 #ESP8266 #Arduino

[fabiocardoso_dev_br]

It worked as a charm on my local web server, using XAMPP. If we could improve this project, like, adding buttons in order to remote control it, it would be outstanding. Thank you very much and congratulations, buddy.

[sriraj_go]

I was looking for something very similar to work on my PhD. Excellent tutorial for beginners like me who have limited experience with programming. Thank you very much.

[jackofalltrades]

Is this feasible? Instead of saving the data to the MYSQL database using internet connection, How about save it on sdcard instead then use the ESP SoftAP to access the data and display it on a webpage?

[carronhi]

Hello Rui, quick question, can you please help me to know how can i stop the automatic scale in the Y values? I appreciate your help, thank you and keep doing this amazing work.

[bsktrol]

Hi Rui. I like your videos. Can i make this project more real time, for example every 1 seconds instead of 30 seconds. do i have to make such a this video by firebase database or is it possible with mysql

[AnshumanFauzdar]

Exactly I wanna work upon!! Keep the good work!! Thanks!!

[naufal]

rui, how to post data without refreshing the page?

[raghuyadav]

sir, I am using arduino pro mini, ESP8266-01, and DPS310. Can you please help me how do i make connection and program ESP8266-01 (doesn't have programmable port)

[joanjimenezfrias]

Hello so nice tutorial, I was wondering if you can help me with something, I am getting this message in the serial monitor "HTTP Response code: 200" and my database did not receive the information. what does it mean?
Thanks.

[megladon]

Thanks this is just what I need. Do you know if you are able to disable the wifi, Bluetooth and temporarily the gsm to conserve power? Further, in the post-data.php I would recommend using filter_input instead of the test_input function, you should also use a prepared statement just for in case to protect against SQL injection.

[Darkk]

Very nice write up and good use of MySQL to store the data. Going to try using Grafana to generate the pretty graphs as it can pull the data from MySQL. Also for the sensor can I use DHT22 since it's pretty common item?

[ManuelCastillo-kqxy]

Los grFicos she actualizan "solo", cada vex quebsebunsere un Nuevo dato MySQL?

[janvierabueza]

this is a big help for me. Thank you very much

[Ivanhateineidee]

Hey, can you provide some auto refresh code for the web page so we dont need to refresh it manual? Thanks

[fabiotortorella]

hi i get a 301 error on the serial monitor and data dont reach the database.. the chart is working
what to do?

[susantasharma]

Hi, how to automatically update the webpage instead of refresh again and again?

[SiriusFuenmayor]

Can you do this using Flask instead of php?

[naufal]

i got problem when i search example.com/esp-chart.php because access denied. Please help me rui

[crouchingchicken]

Hi thank you for the tutorial, I did everything according to this video but my charts php when che king online says connection failed do you leave server servername as localhost?

[thienthuluc]

Was a great video. Can I use DHT11 sensor instead of BME280 sensor? I tried a lot but it didn't work :((. Thanks anyway