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

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/Emb...

[@Addybhoot93]

Really man a grand salute to you for working in such noise.

[@embedotronics]

thanks 👍

[@nayyershahzad8051]

Very nice!. Info flow is also very logical and natural. Good work!

[@lukstil9320]

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]

Perfect on RPi3 with MariaDB. Next step is to combine with Grafana...👍

[@ezhilanbalgan7412]

Super Project! Exactly what I want to get clarity. Thanks a lot.

[@embedotronics]

thanks for the compliment 👍

[@hanabesbes2490]

Really good and detailed explanation!. But I am confused about server adress and IPAddress value. Would you please help me , in this case?

[@ekafajhariadwar234]

thank you very much, Sir. Now I can destroy my problem. I can't wait for your another tutorials video.

[@arnandosg1660]

Ralat Destroy=solved

[@LaurinusPonpon]

Man, I rarely leave comments, but I have to tell you, you're a star! You saved me.

[@BHR777]

Thanks for this superb tutorial. I really like it, because it is well explained and no steps are hidden.

[@robginsburg6413]

Excellent project - well thought through, well explained and very helpful. Thank you!

[@Ahmadnaweed786]

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]

thanks 👍

[@maineimes]

Thank you, very much! From Brazil

[@mohammedalsahly5412]

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.

[@derekhawley9660]

Great video and code ... thanks a lot for your help. Loved the dogs barking in the background :)

[@embedotronics]

thanks

[@reynaldobernabe9634]

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!

[@user-qf2jl1vb6d]

Really great sharing , thank you very much

[@embedotronics]

Welcome

[@ekafajhariadwar234]

Thanks Sir, from Indonesia

[@muhammadjameelkhan8853]

realy very nice vdo with guns and dogs sound just kidding but realy very good vdo

[@mohamedjasa3206]

thanks bro from Sri Lanka

[@embedotronics]

thanks

[@tonynorrington3371]

really nice and unique one, but what would be it's major use sir?

[@embedotronics]

you can use this to make attendance system

[@tonynorrington3371]

@@embedotronics awsome idea , also what more things you can do with php and Arduino?

[@andresvanegaspatino8642]

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

[@coffeecuppepsi]

The background sounds like a bunch of kindergarten kids broke into a construction site and are demolishing the building

[@brazo98]

Nice project. Thx a lot 🖖🏻🖖🏻🖖🏻

[@alphaO27]

Great video, have you tried sending data at a higher ratem say every 20ms ?

[@embedotronics]

Not yet

[@andreyboyko7849]

Thanks for video.

[@user-uh1el6br6n]

Thank you very much, It works well!

[@embedotronics]

Glad it helped

[@karolkowalewski4627]

You are the best thank's so much

[@hillarychristine586]

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.

[@peerappel2012]

Thank you very much. You are awesome!

[@eslamshahin0]

Thanks very much for your efforts

[@embedotronics]

thanks

[@emanuelacostagutierrez2255]

Thank you very much

[@eldaryf]

Why can we hear gunshots in the background

[@Gus64]

Is there any way to visualize the data? What about if you have multiple sensors, and you want to control them indiviually?

[@ramm1343]

nice question did you find the answer

[@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]

what problem you are facing?

[@lionciomorcilla3045]

Very Helpful!!!

[@neerajgupta9431]

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

[@harshalbharre9685]

Thanks a lot!

[@sitinuraishahbintiabdulmut2867]

15:10 the data still not insert after i refresh it

[@louietapao]

I got error, hope someone will help

[@pablosaizortuno4740]

good work!

[@tariq4846]

How can we code multiple DHT22 sensors and push all data to my web hosting database?

[@embedotronics]

you have to create multiple instances for every dht22 sensor and then send data to database.

[@tariq4846]

@@embedotronics How to do this? Most of us here are new/beginners

[@shivamvlogs9304]

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

[@MohamedNuzrath]

thank you

[@sahiku5357]

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 ?

[@carlomagnojr1253]

great! can you display the data in real time charts or gauges?

[@embedotronics]

we can show this data on google spreadsheet if you want charts their we can make charts as well 👍

[@carlomagnojr1253]

@@embedotronics I prefer using HTML that will display the temperature in thermometer and gauge for humidity. Many thanks

[@munirayt786]

Could you please share the HTML for the same on my mail [e-mail]

[@shraddhakshirsagar6630]

Thanks sir..this is very useful video.. Can we import data in excel file and then can we send this file to user?

[@embedotronics]

we can import data in google spreadsheet as well

[@luchocarcamo3416]

hola logre guardar solo un registro después se cae la conexión constantemente que puedo hacer?

[@arturotorres2685]

como quedo tu php de php

[@arturotorres2685]

el archivo php, pues no se conecta el mio

[@luchocarcamo3416]

hello I managed to save only one record after the connection drops constantly, can I do it?

[@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]

you can use wifi module as well

[@markdavidfernandez147]

if im using mq135 gas sensor, i can send also the gas value to the database? thank you so much

[@embedotronics]

Thanks for appreciating words 👍

[@EngineerVijitaaDas]

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]

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👍

[@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

[@irminsul2]

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 :)

[@teurejonism8531]

Warning: Undefined array key "temperature" in C:\xampp\htdocs\temperature\dht.php on line 20 there's an error, help me please

[@warrenmiranda4943]

This is great. But can i use this on rfid instead of dht11 ?

[@embedotronics]

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]

@@embedotronics is it possible with fingerprint..

[@mariezdesire6045]

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]

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.

[@subhamdas2491]

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

[@bgcleo]

Sir, how to setting the byte mac address? Thanks before

[@rodaveprestado2359]

Thanks😊😊

[@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

[@christinesonya5993]

Sir, how about if i use thermocouple as the temperature censor?

[@elpojoloco339]

hello i have Errant query: insert into mesure set humidity='48', temperature='46'

[@Joma0411]

Hi sir mine says Notice: Undefined index: temperature in C:\xampp\htdocs\tempsens\dht.php on line 20 what should i do ?

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

[@halilyldz4013]

I work send to sensor data to MySQL with ESP8266 WiFi module and Ardunio Uno. But, ESP8266 always failed. Can you aid me?

[@embedotronics]

What error you are getting

[@lukstil9320]

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]

Ok got it to work with my Pi 3 + mysql + php + esp8266 + dht11. Thanks for the really good explaination!

[@anitasesarria]

Thanks sir. But, why my data can not insert to database ? My arduino has conected to server localhost, but there are no data in database. I use nodeMCU ESP. Please help me. Thanks #Indonesian

[@embedotronics]

Are you using nodemcu hardware or arduino?

[@anitasesarria]

I use nodeMCU hardware

[@embedotronics]

Okay you can check my nodemcu project playlist I've made the same tutorial based on nodemcu... Apart from that are you able to get data manually through browser?

[@louietapao]

@@embedotronics same problem with me, can't get data manually through browser due to 404 error. please help

[@mayank9266]

Please say me how can i store finger print in mysql/php using Arduino uno finger print module

[@the_kebbabbaro]

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

[@Beroldas]

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]

from raspberry pi you can directly send data through python code.

[@Maria-uu5cb]

czemu nikt nic nie pisze o strzalach

[@auxinnepaul8203]

hello, is possible to adjust threshold on the app so that when temperature is high fans are activated

[@VIGNESHWARANSDCIRCUITS]

Notice: Undefined index: temperature in C:\xampp\htdocs\VSD\dht.php on line 20 i am getting error like this sir can you help me on it

[@blackwhite5606]

yes, i got the same problem

[@reetumidriff4733]

Hi, Can you give me example of this project with Arduino nano 33 ble sense and ethernet shield2?

[@yohanesie6038]

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

[@naqeebraza4845]

Sir I want to send current and voltage sensors data to mysql. What changes I need to make in this code and database?

[@mafatikhulilmi6469]

hello.., could I sending data into mysql using bulk insert concept ? thank you ..

[@chris9yearsago698]

Hello brother, will this work on other sensor like turbidity and ph level sensor for water ?

[@blackwhite5606]

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]

im getting the same error have u found a solution to that?

[@J3zp3rs]

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"

[@wyc2462]

You GREAT!

[@guidobraun2920]

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" ..

[@abimedia6689]

can we use gsm module instead of the internet from arduino please?

[@kaushik36]

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]

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

[@goenzaone]

if i want to use 2 sensor, how i create to send it to database

[@ianabarca8950]

Do you know how to send data like water temperature sensor and ph level?

[@arfendkhalifa]

what the different char server and ip address? how to get shar server and ip address? please help...

[@thesopalin6689]

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

[@MSuriyaPrakaash]

thanks

[@hillsome4095]

hello , can i know how mlx90614 to phpmyadmin using nodemcu ?

[@arghittu_thms]

Hello. I followed this tutorial step by step but I have this error: when I type "localhost/testcode/dht.php?Temperature=30&humidity=70" and press ENTER, it gives me this error on the page: "Cannot select the DB "and in the Database table I do not charge anything: why?

[@embedotronics]

Did u give the db name in php code same as in phpmyadmin db name what you have created

[@arghittu_thms]

@@embedotronics Thanks already: this was the problem. Nice video!

[@champagnegascogne9755]

is this entire project compatible with MongoDB?

[@ricardohdc]

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.

[@orlandogalveziii35]

Can I Use ethernet module instead of ethernet shield?

[@kimryan563]

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]

we made that project as well please check arduino playlist where I've used python for that 👍👍

[@mnunez6153]

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]

For implementation of RFID no need to change on php code, you just need to modify arduino code a bit.

[@fazlynfadzil433]

Embedotronics Technologies hi do you have tutorial on that? Rfid to the database. Sample on arduino code

[@embedotronics]

@@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]

Embedotronics Technologies thankyou

[@Addybhoot93]

Can we store the date in Oracle cloud using Mysql?

[@ilhamrahmatmuharam8501]

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]

I have the same problem

[@shimaalsahfi8530]

i get these error ( Errant query: insert into sensor set sensor_state =' 5') i try to do again but i find same error every time ,how i can solve? and what is error?

[@embedotronics]

may be you are missing the quotation mark!!

[@shimaalsahfi8530]

Embedotronics Technologies I try is with another table it’s work but with this table it doesn’t work I think because the table has relationship with another table

[@embedotronics]

@@shimaalsahfi8530 ok, yeah that could be the reason, glad to hear you resolved that 👍

[@omarfattharusho7916]

How to use esp8266nodemcu wifi module instead of ethernet shield in here

[@embedotronics]

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

[@benitodannes7768]

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]

Has your problem been resolved?

[@benitodannes7768]

@@bgcleo nope. still no clues. ends up using phyton instead of this method

[@chrispusthiaine3735]

Notice: Undefined index: TEMP in C:\xampp\htdocs\connect.php on line 17.. i keep getting that error every time. Does anyone know how i can solve it?any input would be greatly appreciated.

[@blackwhite5606]

yes, same problem but not yet solve :(

[@AhmadLogs]

The error message you're seeing indicates that there's an undefined variable "TEMP" being used on line 17 of your "connect.php" file. To fix this error, you need to make sure that the "TEMP" variable is defined before it's used. You can define it by assigning a value to it or by checking if it's set before using it. you can check if the "TEMP" variable is set before using it like this: if (isset($_GET['temp'])) { $TEMP = $_GET['temp']; // rest of the code } else { echo "Error: TEMP variable not set"; }