Send DHT11 data to PHP MySQL Server using NodeMCU ESP8266

Today, I will show you how to send DHT11 data to MySQL Server. Then you can display temperature and humidity data on your own dashboard in real-time. I have just connect the DHT11 sensor to NodeMcu ESP8266. And after uploading the code, the NodeMCU start sending temperature and humidity data to MySQL Server.
This is a NodeMcu based internet of things project. And you do not need to use any IOT cloud Platform. I will show you how to build cloud like platform using a PHP and MySQL Server.

The dashboard of this project is very simple. I've added two gauge meters to display the real-time temperature and humidity data. You can also visualize all the latest data in tabular form. This project is just like having your own weather station dashboard and you can monitor your weather station readings, from anywhere in the world.

--------------------------------------------------------------------------------------------------------------------
Parts Buy Links (Affiliate Links)
--------------------------------------------------------------------------------------------------------------------

0:00 - Intro
0:46 - Advantages of your own IOT Cloud
1:45 - Project Code and Related Resources
2:07 - Recommended Hosting for Weather Station Froject
2:36 - Create a Subdamin
3:35 - Crate MySQL Database
4:32 - Uploading SQL file in Database
5:07 - Upload Project Files to Web Server
5:42 - Project Configuration
7:34 - Testing Project with Fake Data
8:07 - Wiring NodeMCU with DHT11
8:32 - NodeMCU Sketch (Programming)
9:04 - Arduino Serial Monitor Tesing
9:17 - End Screen

--------------------------------------------------------------------------------------------------------------------
Useful Video Links
--------------------------------------------------------------------------------------------------------------------
NodeMCU SIM800L GPS Tracker

Arduino IOT Cloud Home Automation With ESP32 and NodeMCU

--------------------------------------------------------------------------------------------------------------------
Social Media Links
--------------------------------------------------------------------------------------------------------------------
GitHub:
YouTube:

--------------------------------------------------------------------------------------------------------------------
Download Code
--------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------
Disclaimer
--------------------------------------------------------------------------------------------------------------------
Disclaimer: All videos are for educational purposes and use them wisely. Any video may have a slight mistake, please take decisions based on your research. This video is not forcing anything on you.

#NodeMCU #ESP8266 #ESP8266Projects

[ryusama]

Very simple and understandable guide. Thanks!

[Lovely-bxse]

Bonjour, Tous d'abord un grand merci pour ce tuto très complet précis accompagné en plus de l'ensemble des elements.Pour ce qui cherche, ne cherchez plus vous avez trouvé. J'avoue ne pas être un grand spécialiste et grâce a ce tuto j'ai put appliquer l'ensemble du projet ( avec un serveur LAMP ) sur un Raspberry.
Merci !!!

[abdiqadirmohamednor]

Thank you so much you helped me deeply

[AhmadMehraGohar]

very nice and professional best product

[TechTrendsShameer]

Hi Bro, How to change the maximum value in the gauge from 100 to any other higher value? Please help me.

[Lovely-bxse]

Je me permets de revenir vers vous pour une question, peut on rajouter la fonction MQTT a ce projet?Merci de votre reponse

[tariq]

How to display multiple sensors data on same page?

[TechnicalidEas]

Arduino or NodeMCU will have a push switch attached. When I press in that switch, the location will go to our mobile

[kamalkamel]

very great project, how control devices, example relay and display temperature!!

[tamapra]

If you could explain each PHP file that'd be great since im a beginner. Thanks!

[DiyintheGhetto]

Hello, What happens if you have multiple sensors on multiple esp866. How can I do that within mysql to store and display them?

[Lovely-bxse]

Bonjour, J'ai essaye d'adapter votre code pour un capteur DS18B20 mais les valeurs ne change pas elle m'indique 24 et 77.

[virenrao]

monitor in showing http 200 code at nodemcu side, but data not available on php page.
I am using infinity web hosting

[TechTrendsShameer]

Hi bro. How to change the color of the gauge in the output. I tried in the script, but the color goes to blank

[amirtelecom]

Verry Nice ...
Can this be used with SIM800l ?

[omsvdfr]

how to fix bad requests. response code 400. the file sensordata.php cant find HTTP request, btw im using hostinger as webhost

[nonel]

Thank you so much for this. I'm having issues with http.begin(client, SERVER_NAME); It gives error Compilation error: no matching function for call to 'HTTPClient::begin(WiFiClient&, const char*&)' I would appreciate if you can help

[annoorkhan]

Nice, I tested your projects and it worked perfect but now I need to control few LED from web page, so what I have to do ?do I have to use mqtt broker?

[SAURABHKUMAR-pyor]

Hi bro
I did everything like u said. Database is getting data if we try to add fake data through post_data_test.php and nodemcu is also sending data successfully as it's showing http code 400 on serial monitor but it is not saving in database of the website if we check in database.
Can you tell me the reason?plz

[syaduinotech]

Thanks for sharing. I try already but fail to get the function. I am using personal website.. its so hard many creator using free..huhu. can you share video about own personal website. I try using randomnerdtutorial get the http code 300. Mind to help. Using the personal website. I did not know the host name.