You can find the complete project details (schematics + source code) on my blog ► RandomNerdTutorials.com/visualize-esp32-esp8266-sensor-readings-from-anywhere/ For this project, you'll need a hosting account with PHP and MySQL. You can use any hosting provider. I recommend using Bluehost and you can use this link to setup a Hosting Account + Free Domain Name ► RandomNerdTutorials.com/bluehost/
hi， i don‘t know if you can see my comment, but if you could answer i would really appreciate it! I have followed your steps and everything went well until step4, when i enter the page of esp-chart.php, it shows access denied for user (password yes) . so i though maybe i should start up again, then i deleted the old database etc. then it come out no matter what i write, the website didn‘t change. like even if i give a wrong username in post-data.php. and change the echo from „no data posted with http post“ into „hahaha“, the website still shows no data posted with http post. what should i do ?
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.
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?
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.
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
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.
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)
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?
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.
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?
use AJAX to refresh some parts of your page i.e the charts .. if you include refresh in the header of HTML as they mentioned the whole page will keep refreshing which is not neat and of a bad UX
@@sudanielectronics5112 well.... In Arduino IDE every thing it work, HTTP code is 200. But nothing show on website and don't have any data post to Database :(
I think you need give access to the database for everyone. My database generates access denied error, I think it's because it blocks every IP access by default. I am not sure how to open that
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.
In order to make this project work, you need to have your own hosting account + domain name. The apiKeyValue is just a random string that you can modify. It’s used for security reasons, so only anyone that knows your API key can publish data to your database . More information here: randomnerdtutorials.com/visualize-esp32-esp8266-sensor-readings-from-anywhere/
hello, and thank you for this video. When I change the name of the database more nothing works it gives me this as an error -> -> Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /volume1/web/index.php on line 33 Error: Call to a member function fetch_assoc() on bool in /volume1/web/index.php on line 33 Call Stack: 0.0004 360584 1. {main}() /volume1/web/index.php:0 ... why ???
You can find the complete project details (schematics + source code) on my blog ► RandomNerdTutorials.com/visualize-esp32-esp8266-sensor-readings-from-anywhere/
For this project, you'll need a hosting account with PHP and MySQL. You can use any hosting provider. I recommend using Bluehost and you can use this link to setup a Hosting Account + Free Domain Name ► RandomNerdTutorials.com/bluehost/
hi， i don‘t know if you can see my comment, but if you could answer i would really appreciate it! I have followed your steps and everything went well until step4, when i enter the page of esp-chart.php, it shows access denied for user (password yes) . so i though maybe i should start up again, then i deleted the old database etc. then it come out no matter what i write, the website didn‘t change. like even if i give a wrong username in post-data.php. and change the echo from „no data posted with http post“ into „hahaha“, the website still shows no data posted with http post. what should i do ?
If I want to use Arduino Mega With Ethernet Shield, is it possible?
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.
That's probably one of my next projects (control outputs) with this setup
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?
Wow can you do it DHT11 sensor
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.
rui, how to post data without refreshing the page?
Excellent! Very neat description.
Thank you!
Exactly I wanna work upon!! Keep the good work!! Thanks!!
Thanks for watching! I'm glad it was helpful
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
Los grFicos she actualizan "solo", cada vex quebsebunsere un Nuevo dato MySQL?
hi i get a 301 error on the serial monitor and data dont reach the database.. the chart is working
what to do?
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.
SAME PLS SEND HELP
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)
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?
Yes you can use it just need to include dht11 libarary First in your code.
Hi, how to automatically update the webpage instead of refresh again and again?
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.
and htmlspecialchars :D ..
may i used node red to send my sensor data?????
Great Help and Thanks
i got problem when i search example.com/esp-chart.php because access denied. Please help me rui
ua-cam.com/video/zssr59F0QPc/v-deo.html&ab_channel=HarithaComputers%26Technology
this can help you
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?
is this problem still up to date for you?
@@mateszecsi9157 hi, I got it working in the end. Thank you
this is a big help for me. Thank you very much
Hey, can you provide some auto refresh code for the web page so we dont need to refresh it manual? Thanks
You can do that in the html header with the meta tag
Use this command in HEAD section
30 Means number of second.
@@sudanielectronics5112 thanks!
use AJAX to refresh some parts of your page i.e the charts .. if you include refresh in the header of HTML as they mentioned the whole page will keep refreshing which is not neat and of a bad UX
@@mibrahim4245I've been trying to do it but I still can't figure it out. can you please help me how to do it
Can you do this using Flask instead of php?
thank you dude good job
Hi, Can we publish data from multiple ESP32 to the same Database?
of course you can, as long as the esp32 have the same APIkey
how to auto refresh chart sir?
is there any tutorial for local website only?
You can follow this project instead (run your local web server): randomnerdtutorials.com/esp32-esp8266-plot-chart-web-server/
Was a great video. Can I use DHT11 sensor instead of BME280 sensor? I tried a lot but it didn't work :((. Thanks anyway
Hi,
You have to include dht11 libarary First in your code and use dht11 functions to read the temperature and humidity and then send the request.
@@sudanielectronics5112 well.... In Arduino IDE every thing it work, HTTP code is 200. But nothing show on website and don't have any data post to Database :(
@@sudanielectronics5112 oh, it works now. Thanks a lot. I missed a letter " in Arduino code so it didn't work :(
@@thienthuluc3451 can u please send the modified code ?
moka143@gmail.com
thank you
I think you need give access to the database for everyone. My database generates access denied error, I think it's because it blocks every IP access by default. I am not sure how to open that
I found my answer here: ua-cam.com/video/zssr59F0QPc/v-deo.html
Hello, i have a error.In the monitor "httpRequestData: api_key=xxxxxxx=20.40&value2=99.90&value3=20.40
Error code: -1
.
17/5000
how do fix this ?
wrong domain, don't forget using "..../post-data.php"
Can I get free domain with free plan ?
How to get api key?
real nice content
Thanks!
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.
How to get API key
In order to make this project work, you need to have your own hosting account + domain name. The apiKeyValue is just a random string that you can modify. It’s used for security reasons, so only anyone that knows your API key can publish data to your database
. More information here: randomnerdtutorials.com/visualize-esp32-esp8266-sensor-readings-from-anywhere/
bro the cheapest deal for hosting is 147 usd .
+1
hello, and thank you for this video.
When I change the name of the database more nothing works it gives me this as an error ->
-> Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /volume1/web/index.php on line 33 Error: Call to a member function fetch_assoc() on bool in /volume1/web/index.php on line 33 Call Stack: 0.0004 360584 1. {main}() /volume1/web/index.php:0 ... why ???