No video :(

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

Подписаться 69 тыс.

Просмотров 57 тыс.

50% 1

For complete project details (schematics + source code), visit ► RandomNerdTutorials.com/visua...
Hosting Account + Free Domain Name ► RandomNerdTutorials.com/blueh...
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:
/ randomnerdtutorials
Follow me on twitter:
/ ruisantosdotme
Subscribe for more projects like this!
bit.ly/subscribeRNT
#IoT #ESP32 #ESP8266 #Arduino

Опубликовано:

6 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 69

@RuiSantosdotme 5 лет назад

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/

@mihoisoya7957 3 года назад

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 ?

@pk_dp453 2 года назад

If I want to use Arduino Mega With Ethernet Shield, is it possible?

@janvierabueza9105 3 года назад

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

@gopalakrishnan4137 3 года назад

Great Help and Thanks

@marketingceba9055 5 лет назад

Excellent! Very neat description.

@RuiSantosdotme 5 лет назад

Thank you!

@ayoubbencharef2215 3 года назад

thank you dude good job

@AnshumanFauzdar 5 лет назад

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

@RuiSantosdotme 5 лет назад

Thanks for watching! I'm glad it was helpful

@carronhi 2 года назад

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.

@alcanceweb 5 лет назад

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.

@RuiSantosdotme 5 лет назад

That's probably one of my next projects (control outputs) with this setup

@sriraj_go 4 года назад

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.

@bsktrol 3 года назад

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

@princemiro7241 5 лет назад

real nice content

@RuiSantosdotme 5 лет назад

Thanks!

@raghuyadav6729 4 года назад

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)

@SiriusFuenmayor 4 года назад

Can you do this using Flask instead of php?

@naufal9104 4 года назад

rui, how to post data without refreshing the page?

@fabiotortorella4546 4 года назад

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

@ManuelCastillo-kq3xy 4 года назад

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

@Darkk6969 4 года назад

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?

@sudanielectronics5112 4 года назад

Yes you can use it just need to include dht11 libarary First in your code.

@megladon9113 4 года назад

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.

@mibrahim4245 3 года назад

and htmlspecialchars :D ..

@toxicgaymer69 3 года назад

I'm using firebase, how do I set up multiuser Setup?? Wherein my android app access the data from firebase. But don't know how to setup multiple users

@AsadKhan-le7qi 2 года назад

may i used node red to send my sensor data?????

@TheCeremoniesOfIsrael 23 дня назад

Wow can you do it DHT11 sensor

@susantasharma 2 года назад

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

@bagus0165 3 года назад

how to auto refresh chart sir?

@joanjimenezfrias8037 4 года назад

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.

@kaiizookuu 3 года назад

SAME PLS SEND HELP

@RadionicaExpress 4 года назад

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

@kruppstahl1686 4 года назад

You can do that in the html header with the meta tag

@sudanielectronics5112 4 года назад

Use this command in HEAD section 30 Means number of second.

@RadionicaExpress 4 года назад

@@sudanielectronics5112 thanks!

@mibrahim4245 3 года назад

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

@pinoyvlogerist7521 3 года назад

@@mibrahim4245I've been trying to do it but I still can't figure it out. can you please help me how to do it

@sarathkumar341 4 года назад

Hi, Can we publish data from multiple ESP32 to the same Database?

@lmarkrol 4 года назад

of course you can, as long as the esp32 have the same APIkey

@mustafamontaser4955 4 года назад

Can I get free domain with free plan ? How to get api key?

@thienthuluc3451 4 года назад

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

@sudanielectronics5112 4 года назад

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.

@thienthuluc3451 4 года назад

@@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 :(

@thienthuluc3451 4 года назад

@@sudanielectronics5112 oh, it works now. Thanks a lot. I missed a letter " in Arduino code so it didn't work :(

@Ashyaa2 3 года назад

@@thienthuluc3451 can u please send the modified code ? moka143@gmail.com thank you

@crouchingchicken007 Год назад

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?

@mateszecsi9157 Год назад

is this problem still up to date for you?

@crouchingchicken007 Год назад

@@mateszecsi9157 hi, I got it working in the end. Thank you

@kissmaelufrancisco1885 4 года назад

is there any tutorial for local website only?

@RuiSantosdotme 4 года назад

You can follow this project instead (run your local web server): randomnerdtutorials.com/esp32-esp8266-plot-chart-web-server/

@naufal9104 4 года назад

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

@zakariaaglagal5824 3 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zssr59F0QPc.html&ab_channel=HarithaComputers%26Technology this can help you

@mathieusan 4 года назад

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

@mathieusan 4 года назад

I found my answer here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zssr59F0QPc.html

@Gonxzxauc 5 лет назад

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 ?

@naufal9104 4 года назад

wrong domain, don't forget using "..../post-data.php"

@saikumar-rn8hm 5 лет назад

How to get API key

@RuiSantosdotme 5 лет назад

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/

@saulotarsobc 2 года назад

@practicalofanything218 4 года назад

bro the cheapest deal for hosting is 147 usd .

@LpMaker 2 года назад

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 ???