Sending Temperature and Humidity Data to MySQL Server(PHPMYADMIN) using Arduino

  Переглядів 207,117

Embedotronics Technologies

Embedotronics Technologies

5 років тому

Hello Guys,
In this Project I've interfaced DHT11 with arduino and then I'm sending data of dht11 which is humidity and temperature to phpmyadmin database.
You can buy tools from amazon, below are the links:
Arduino Uno link in amazon: amzn.to/2yYpcyT
Ethernet Shield link in amazon: amzn.to/2KyTn6i
DHT11 link in amazon: amzn.to/2z0awiB
FB; / embedotronics
you can get the source code from this link:
github.com/Embedotronics/Send...

КОМЕНТАРІ: 253
@lukstil9320
@lukstil9320 3 роки тому
Really good and detailed explaination! Worked for me very well. Hope you keep on with doing such HIGH QUALITY HOW TO'S! Greetings from Germany.
@lukstil9320
@lukstil9320 3 роки тому
Perfect on RPi3 with MariaDB. Next step is to combine with Grafana...👍
@nayyershahzad8051
@nayyershahzad8051 3 роки тому
Very nice!. Info flow is also very logical and natural. Good work!
@ezhilanbalgan7412
@ezhilanbalgan7412 4 роки тому
Super Project! Exactly what I want to get clarity. Thanks a lot.
@embedotronics
@embedotronics 4 роки тому
thanks for the compliment 👍
@BHR777
@BHR777 2 роки тому
Thanks for this superb tutorial. I really like it, because it is well explained and no steps are hidden.
@Addybhoot93
@Addybhoot93 3 роки тому
Really man a grand salute to you for working in such noise.
@embedotronics
@embedotronics 3 роки тому
thanks 👍
@mohammedalsahly5412
@mohammedalsahly5412 4 роки тому
Thank you for the full explanation, do you have the explanation for this the temp and humility project to start from the beginning because I am new in this field . thank you again.
@ekafajhariadwar234
@ekafajhariadwar234 4 роки тому
thank you very much, Sir. Now I can destroy my problem. I can't wait for your another tutorials video.
@arnandosg1660
@arnandosg1660 4 роки тому
Ralat Destroy=solved
@robginsburg6413
@robginsburg6413 3 роки тому
Excellent project - well thought through, well explained and very helpful. Thank you!
@sahiku5357
@sahiku5357 2 роки тому
is it possible to modify an existing row in database instead of creating a new one, for example change the row where the id is 1 everytime ?
@the_kebbabbaro
@the_kebbabbaro 3 роки тому
Goodevening sir, I'm doing this project but the serial monitor displays "Failed to configure Ethernet using DHCP", does it mean that for doing that I have to disable the dhcp into my network? The string error should come up as soon as the MAC address is ==0, but I left the one that you put in the file
@maineimes
@maineimes 4 роки тому
Thank you, very much! From Brazil
@ekafajhariadwar234
@ekafajhariadwar234 4 роки тому
Thanks Sir, from Indonesia
@christinesonya5993
@christinesonya5993 3 роки тому
Sir, how about if i use thermocouple as the temperature censor?
@luchocarcamo3416
@luchocarcamo3416 4 роки тому
hello I managed to save only one record after the connection drops constantly, can I do it?
@hanabesbes2490
@hanabesbes2490 2 роки тому
Really good and detailed explanation!. But I am confused about server adress and IPAddress value. Would you please help me , in this case?
@mafatikhulilmi6469
@mafatikhulilmi6469 3 роки тому
hello.., could I sending data into mysql using bulk insert concept ? thank you ..
@leonardnavales1763
@leonardnavales1763 4 роки тому
sir, i love to do it in a simple ohmmeter and the data will show on mysql database, can you give me some help on the codes? thanks.
@J3zp3rs
@J3zp3rs 4 роки тому
Hello if im using a webserver how do i write in the php then? It still should be localhost right because the file is local on the server but i still get it wrong. What should i do? "Cannot connect to db"
@naqeebraza4845
@naqeebraza4845 3 роки тому
Sir I want to send current and voltage sensors data to mysql. What changes I need to make in this code and database?
@Joma0411
@Joma0411 3 роки тому
Hi sir mine says Notice: Undefined index: temperature in C:\xampp\htdocs\tempsens\dht.php on line 20 what should i do ?
@hillarychristine586
@hillarychristine586 3 роки тому
Hello sir, I would like to ask you about this project. I have follow along all the instruction in video. Why do I get connection failed sir? I have change the IP server with local IP and also activate DHCP. I always make sure that my ethernet and wifi not bridged. Thank you sir.
@auxinnepaul8203
@auxinnepaul8203 3 роки тому
hello, is possible to adjust threshold on the app so that when temperature is high fans are activated
@andresvanegaspatino8642
@andresvanegaspatino8642 2 роки тому
Hello thanks for the Video. I ask you: if we want the server to be on a host, what would the GET request be like? Thanks a lot
@LaurinusPonpon
@LaurinusPonpon 4 роки тому
Man, I rarely leave comments, but I have to tell you, you're a star! You saved me.
@chris9yearsago698
@chris9yearsago698 2 роки тому
Hello brother, will this work on other sensor like turbidity and ph level sensor for water ?
@derekhawley9660
@derekhawley9660 2 роки тому
Great video and code ... thanks a lot for your help. Loved the dogs barking in the background :)
@embedotronics
@embedotronics Рік тому
thanks
@reynaldobernabe9634
@reynaldobernabe9634 4 роки тому
Nice tutorial!!! Kudos to you my friend... i learn alot from you..hope you create more tutorials to help others. can you create RFID using RDM6300 going to PHP database, iot using ethernet shield - websocket, fire alarm monitoring system and many more... many people/enthusiast will benefit from your talented skills!
@ricardohdc
@ricardohdc 3 роки тому
Hi bro, How I can connect with external web server? I did the same steps but the project didn't work. I did with local server and all was OK.
@neerajgupta9431
@neerajgupta9431 4 роки тому
hello pawan joshi sir it was a nice and very helpful video. i have tried to do the same however the data is not getting updated in mysql server on pressing the enter button means from broswer. i am using wamp server instead of xampp. i have used the same code as usggested by you. i have checked privileges part also in mysql. kindly help in this regards
@halilyldz4013
@halilyldz4013 2 місяці тому
I work send to sensor data to MySQL with ESP8266 WiFi module and Ardunio Uno. But, ESP8266 always failed. Can you aid me?
@abimedia6689
@abimedia6689 3 роки тому
can we use gsm module instead of the internet from arduino please?
@jamesprada6301
@jamesprada6301 Рік тому
hi sir. i have a question. if im going to use rfid reader, servo and ultrasonic sensor, am i going to connect those to the ethernet sheild(like in the thumbnail)?
@embedotronics
@embedotronics Рік тому
you can use wifi module as well
@yohanesie6038
@yohanesie6038 3 роки тому
hello can you give tutorial sending timestamp to database but with IRsensor? so, if something crossing the sensor it will count, and if crossing backward will decrease the count. i want to create people counter but with database. Thx
@ianabarca8950
@ianabarca8950 4 роки тому
Do you know how to send data like water temperature sensor and ph level?
@subhamdas2491
@subhamdas2491 3 роки тому
bro can u just tell me how to upload any values to a server....like in this code what should be the value of the server for online
@reetumidriff4733
@reetumidriff4733 3 роки тому
Hi, Can you give me example of this project with Arduino nano 33 ble sense and ethernet shield2?
@Addybhoot93
@Addybhoot93 3 роки тому
Can we store the date in Oracle cloud using Mysql?
@markdavidfernandez147
@markdavidfernandez147 4 роки тому
if im using mq135 gas sensor, i can send also the gas value to the database? thank you so much
@embedotronics
@embedotronics 4 роки тому
Thanks for appreciating words 👍
@peerappel2012
@peerappel2012 4 роки тому
Thank you very much. You are awesome!
@Beroldas
@Beroldas 4 роки тому
Hello, i have a question. I need the exactly same thing, but instead of Arduino im using Raspberry Pi Model 3b. Is there any difference between sending data from arduino to MySQL and sending data from RPI to MySQL?
@embedotronics
@embedotronics 4 роки тому
from raspberry pi you can directly send data through python code.
@mayank9266
@mayank9266 3 роки тому
Please say me how can i store finger print in mysql/php using Arduino uno finger print module
@lukstil9320
@lukstil9320 3 роки тому
Trying it on Rpi3 with LAMP server. Are there any differences between XAMPP and LAMP server doing this? Works prefekt on Windows with XAMPP but wont on the Rpi 3 with LAMP installed...
@lukstil9320
@lukstil9320 3 роки тому
Ok got it to work with my Pi 3 + mysql + php + esp8266 + dht11. Thanks for the really good explaination!
@himavatheapganesanstudent7845
@himavatheapganesanstudent7845 Рік тому
Hi, i tried to do exactly the same in video. but mine didn't connect. When I tried with url it did connect but when connect with arduino id doesn't send data. can you help
@orlandogalveziii35
@orlandogalveziii35 Рік тому
Can I Use ethernet module instead of ethernet shield?
@niloxz3367
@niloxz3367 Рік тому
hi i followed all ur steps my serial monitor shows my data and the connection is available but the data doesent get forwarded to mysql
@champagnegascogne9755
@champagnegascogne9755 Місяць тому
is this entire project compatible with MongoDB?
@user-uh1el6br6n
@user-uh1el6br6n 3 роки тому
Thank you very much, It works well!
@embedotronics
@embedotronics 3 роки тому
Glad it helped
@ineffableseul
@ineffableseul 3 роки тому
Sir can i still received the data even i Don't have internet? But only a router?
@bgcleo
@bgcleo 4 роки тому
Sir, how to setting the byte mac address? Thanks before
@dustflame2412
@dustflame2412 Рік тому
Hi I'm trying to make this but when i open my serial monitor it say that "FAILED TO CONFIGURE ETHERNET USING DHCP" how to resolve thsi? Can anybody help me?
@teurejonism8531
@teurejonism8531 3 роки тому
Warning: Undefined array key "temperature" in C:\xampp\htdocs\temperature\dht.php on line 20 there's an error, help me please
@goenzaone
@goenzaone 3 роки тому
if i want to use 2 sensor, how i create to send it to database
@mohamedjasa3206
@mohamedjasa3206 4 роки тому
thanks bro from Sri Lanka
@embedotronics
@embedotronics 4 роки тому
thanks
@kentpaul8269
@kentpaul8269 4 роки тому
Sir can max30100 send to database also?
@zaynirich3738
@zaynirich3738 2 роки тому
Can you please tell me how we can find the client IP address ?(that u mentioned above code)
@alphaO27
@alphaO27 Рік тому
Great video, have you tried sending data at a higher ratem say every 20ms ?
@embedotronics
@embedotronics Рік тому
Not yet
@guidobraun2920
@guidobraun2920 2 роки тому
After the jun 21 Windows Update my greenhouse data collection crashed. Today I build up exactly what you show here. But over the browser i can only send one time the data. After that the dht.php send me "Errant query". And only 1 dataset is in the database. Did you know that? Or did you know a solutin for that problem? UPDATE: Sorry, the problem was me.. i forgot the click in the box behind the "Null Index" ..
@riceballs2633
@riceballs2633 3 роки тому
Is it ok for other database?
@prasunbiswas8025
@prasunbiswas8025 3 роки тому
Will this whole process work without internet?
@thesopalin6689
@thesopalin6689 4 роки тому
Hello I would like to do the same thing (video) but with a grove temperature sensor v1.2 and a wifi module (grove uart wifi v1.1). I can not modify the code accordingly so if someone sees this message and know about it I am very interested because it is for my bac therefore very important given the coef ...
@ilhamrahmatmuharam8501
@ilhamrahmatmuharam8501 3 роки тому
Sir, I tried sending the numbers manually in the browser via "localhost: 81 / testcode / dht.php? temperature = 34 & humidity = 10", why did the number never reach the database and continue loading in the browser? my localhost is localhost: 81 Thanks before..
@user-pn7es2ry5p
@user-pn7es2ry5p 2 роки тому
I have the same problem
@himanshunikam6251
@himanshunikam6251 4 роки тому
Is this code is work with protruse simulator?
@hillsome4095
@hillsome4095 3 роки тому
hello , can i know how mlx90614 to phpmyadmin using nodemcu ?
@elpojoloco339
@elpojoloco339 3 роки тому
hello i have Errant query: insert into mesure set humidity='48', temperature='46'
@ineffableseul
@ineffableseul 3 роки тому
Sir is it wireless?
@Gus64
@Gus64 11 місяців тому
Is there any way to visualize the data? What about if you have multiple sensors, and you want to control them indiviually?
@ramm1343
@ramm1343 7 місяців тому
nice question did you find the answer
@Ahmadnaweed786
@Ahmadnaweed786 3 роки тому
dogs barking hahahah! my friend this is ok, but worse than that is the keyboard button clicks louder than your voice! anyway very informative video, definitely helped me. thumps up!
@embedotronics
@embedotronics 3 роки тому
thanks 👍
@arfendkhalifa
@arfendkhalifa 3 роки тому
what the different char server and ip address? how to get shar server and ip address? please help...
@muhammadjameelkhan8853
@muhammadjameelkhan8853 2 роки тому
realy very nice vdo with guns and dogs sound just kidding but realy very good vdo
@harshalbharre9685
@harshalbharre9685 4 роки тому
Thanks a lot!
@tatendarupanga8655
@tatendarupanga8655 Рік тому
l need help on sending sensor data from sensors on the fuel probe to MySQL Server(PHPMYADMIN) using Arduino and esp8266 (fuel monitoring)
@embedotronics
@embedotronics Рік тому
what problem you are facing?
@EngineerVijitaaDas
@EngineerVijitaaDas 3 роки тому
I dont have any WiFi shield to connect with my microcontroller. I want to send via WiFi network. But I am confused about assigning server and IPAddress value. Would you please help me , in this case?
@embedotronics
@embedotronics 3 роки тому
please do follow my nodemcu tutorial for the same if you don't want use ethernet shield, it will be there in nodemcu project playlist👍
@coffeecuppepsi
@coffeecuppepsi Рік тому
The background sounds like a bunch of kindergarten kids broke into a construction site and are demolishing the building
@andreyboyko7849
@andreyboyko7849 4 роки тому
Thanks for video.
@mnunez6153
@mnunez6153 4 роки тому
thanks for sharing. currently i;m searching links for using RFID instead of DHT sensor I already have the hardware setup, I just need a sample php code to display the log via browser.
@embedotronics
@embedotronics 4 роки тому
For implementation of RFID no need to change on php code, you just need to modify arduino code a bit.
@fazlynfadzil433
@fazlynfadzil433 4 роки тому
Embedotronics Technologies hi do you have tutorial on that? Rfid to the database. Sample on arduino code
@embedotronics
@embedotronics 4 роки тому
@@fazlynfadzil433 you can take the help from our one video where we are sending RFID data to google spreadsheet, you need to change in the get request part of arduino code, just call the php code file from that and a bit modification for other parameters.👍
@fazlynfadzil433
@fazlynfadzil433 4 роки тому
Embedotronics Technologies thankyou
@brazo98
@brazo98 Рік тому
Nice project. Thx a lot 🖖🏻🖖🏻🖖🏻
@emanuelacostagutierrez2255
@emanuelacostagutierrez2255 4 роки тому
Thank you very much
@tariq4846
@tariq4846 Рік тому
How can we code multiple DHT22 sensors and push all data to my web hosting database?
@embedotronics
@embedotronics Рік тому
you have to create multiple instances for every dht22 sensor and then send data to database.
@tariq4846
@tariq4846 Рік тому
@@embedotronics How to do this? Most of us here are new/beginners
@karolkowalewski4627
@karolkowalewski4627 3 роки тому
You are the best thank's so much
@shraddhakshirsagar6630
@shraddhakshirsagar6630 4 роки тому
Thanks sir..this is very useful video.. Can we import data in excel file and then can we send this file to user?
@embedotronics
@embedotronics 4 роки тому
we can import data in google spreadsheet as well
@lionciomorcilla3045
@lionciomorcilla3045 3 роки тому
Very Helpful!!!
@kimryan563
@kimryan563 4 роки тому
can i send data to phpmyadmin without ethernet shield? just connect it the arduino via USB cable to my computer that is connected to the internet. if it is possible can u teach me?
@embedotronics
@embedotronics 3 роки тому
we made that project as well please check arduino playlist where I've used python for that 👍👍
@shivamvlogs9304
@shivamvlogs9304 2 роки тому
bro awesome work you have done but I'm getting this error "Parse error: syntax error, unexpected string content "", expecting "-" or identifier or variable or number in C:\xampp\htdocs\testCode\gpsData.php on line 22" plz solve this error
@irminsul2
@irminsul2 3 роки тому
Hello ... great example and good how-to ;)!. like it! (maybe reduce background noise next time! :) .... i would need some help though i am using an Arduino NANO 33 IoT with included Wireless module. i am getting connection to my wireless without problems. i have the database set up to get data as your example shows. i have the php-server setup and i can get data into the datebase with help of the .php file you have in your example. i allready did some modifications to my type of data and so on ... i currently have a www-server on my arduino, but that is rather slow and a database makes much more sense for me ... BUT i dont get the http-request from your example modified to get it to work. it always brings me back "no connection" ... so i dont have the ethernet shield - i suppose i dont need to include the ethernet.h library ... but how do I connect and get the http-request / to my .php file which would then bring the data inot my sqlDB? .. thanks for your help we might get in direct contact :)
@warrenmiranda4943
@warrenmiranda4943 4 роки тому
This is great. But can i use this on rfid instead of dht11 ?
@embedotronics
@embedotronics 4 роки тому
Of course you can use, on that case php code will be same, you need to modify arduino code, you can take the help of one video in which we are sending rfid data to Google spreadsheet.
@PavanKumar-mx4pw
@PavanKumar-mx4pw 4 роки тому
@@embedotronics is it possible with fingerprint..
@learnbox3783
@learnbox3783 3 роки тому
Who is doing firing behind you?
@user-qf2jl1vb6d
@user-qf2jl1vb6d 5 місяців тому
Really great sharing , thank you very much
@embedotronics
@embedotronics 4 місяці тому
Welcome
@eslamshahin0
@eslamshahin0 2 роки тому
Thanks very much for your efforts
@embedotronics
@embedotronics Рік тому
thanks
@mariezdesire6045
@mariezdesire6045 3 роки тому
why i receive this after the query? Errant query: insert into dht11 set humidity='50', temperature='4' first time i tried it was ok, but from the second i've always received this
@AhmadLogs
@AhmadLogs Рік тому
The error message you are receiving indicates that there is a problem with your MySQL query. Specifically, the error message suggests that there is a syntax error in your query, which is causing the database to reject it. you can try running the query directly in the MySQL console to see if there are any more detailed ABOUT THE error messages.
@blackwhite5606
@blackwhite5606 2 роки тому
I dont know why, my problem is " Warning: Undefined array key "temperature" in C:\xampp\htdocs\teshum\dht.php on line 20", i follow step by step from your video but i have problem, please help me Thanks
@inamullahkhan5718
@inamullahkhan5718 Рік тому
im getting the same error have u found a solution to that?
@carlomagnojr1253
@carlomagnojr1253 4 роки тому
great! can you display the data in real time charts or gauges?
@embedotronics
@embedotronics 4 роки тому
we can show this data on google spreadsheet if you want charts their we can make charts as well 👍
@carlomagnojr1253
@carlomagnojr1253 4 роки тому
@@embedotronics I prefer using HTML that will display the temperature in thermometer and gauge for humidity. Many thanks
@munirayt786
@munirayt786 4 роки тому
Could you please share the HTML for the same on my mail munitash@gmail.com
@mokarrommahmud8575
@mokarrommahmud8575 4 роки тому
what if I use a sound sensor instead pf DHT11?
@embedotronics
@embedotronics 4 роки тому
No issue it will work as sound sensor will give one analogue value.
@benitodannes7768
@benitodannes7768 4 роки тому
help? i already connected the arduino with the pc. it says connected, but i refresh my database, and there is no new entry is there any way to debug the php file? just in case the mistake is there
@bgcleo
@bgcleo 4 роки тому
Has your problem been resolved?
@benitodannes7768
@benitodannes7768 4 роки тому
@@bgcleo nope. still no clues. ends up using phyton instead of this method
@pablosaizortuno4740
@pablosaizortuno4740 3 роки тому
good work!
@muhammadhilman4489
@muhammadhilman4489 3 роки тому
How about arduino uno change to arduino nano ? How to solve it bruh
@abhishekl4079
@abhishekl4079 3 роки тому
thank you brother
@omarfattharusho7916
@omarfattharusho7916 4 роки тому
How to use esp8266nodemcu wifi module instead of ethernet shield in here
@embedotronics
@embedotronics 4 роки тому
You need to change the code a bit, as in nodemcu we need to initialize ssid and password, also few things will be changed, I recommend you to first work with example codes of npdemcu, then you will understand that it's easy to interface with that as well
@tonynorrington3371
@tonynorrington3371 2 роки тому
really nice and unique one, but what would be it's major use sir?
@embedotronics
@embedotronics Рік тому
you can use this to make attendance system
@tonynorrington3371
@tonynorrington3371 Рік тому
@@embedotronics awsome idea , also what more things you can do with php and Arduino?
@MohamedNuzrath
@MohamedNuzrath Рік тому
thank you
@kaushik36
@kaushik36 4 роки тому
The php code works very good locally in xampp server, but the same does not work in aws ubantu _ lamp, anyone here any thoughts why it may be like this. mysql ports are open & able to connect..
@embedotronics
@embedotronics 4 роки тому
did you install LAMP server on your Linux machine properly? you can visit our hackster link for more information www.hackster.io/embedotronics-technologies/arduino-sending-sensor-data-to-mysql-server-phpmyadmin-a604d4
Arduino MASTERCLASS | Full Programming Workshop in 90 Minutes!
1:25:31
Programming Electronics Academy
Переглядів 2,3 млн
Voloshyn - ЗУСИЛЛЯ (прем'єра треку 2024)
06:17
VOLOSHYN
Переглядів 599 тис.
Has Generative AI Already Peaked? - Computerphile
12:48
Computerphile
Переглядів 177 тис.
Arduino is sending dht11 data to MySQL server(PHPMYADMIN) using python
29:04
Embedotronics Technologies
Переглядів 16 тис.
How to send DHT11 data to MySQL server using NodeMCU
16:13
Embedotronics Technologies
Переглядів 61 тис.
i cant stop thinking about this exploit
8:40
Low Level Learning
Переглядів 144 тис.
Communicating from an Arduino to an HTML/JavaScript Webpage
24:15
Adam Thomas
Переглядів 82 тис.
The ARM chip race is getting wild… Apple M4 unveiled
4:07
Fireship
Переглядів 490 тис.
CÓMO HACER UN SERVIDOR WEB ARDUINO DE TEMPERATURA Y HUMEDAD
19:24
Luis Carlos Galán
Переглядів 58 тис.
Arduino Data Logger Project - Very Easy
6:50
educ8s.tv
Переглядів 131 тис.
Нужно ли чистить ПК от пыли?
0:59
CompShop Shorts
Переглядів 101 тис.
🤯Самая КРУТАЯ Функция #shorts
0:58
YOLODROID
Переглядів 2,8 млн
wyłącznik
0:50
Panele Fotowoltaiczne
Переглядів 853 тис.
САМЫЙ дешевый ПК с OZON на RTX 4070
16:16
Мой Компьютер
Переглядів 95 тис.