ESP32 Send Temperature and Humidity Data to localhost XAMPP for Absolute Beginners Step by Step

  Переглядів 61,452

Ahmad Logs

Ahmad Logs

Рік тому

In this tutorial video, you will learn how to send temperature and humidity data from an ESP32 microcontroller to a localhost XAMPP server using a simple PHP script. This video is specifically designed for absolute beginners who have little or no experience with programming and web development.
The video covers all the necessary steps in a step-by-step manner, including downloading and installing XAMPP, setting up the project folder, writing and testing the PHP script, and finally, sending fake data to the server using the ESP32 serial monitor.
Additionally, the video also explains the code used to send the temperature and humidity data from the ESP32 to the server and provides line-by-line explanations of the PHP script used to receive and store the data in a MySQL database.
By the end of the video, you will have a working system that can send and store real-time data from your sensors.
--------------------------------------------------------------------------------------------------------------------
Buy On Amazon
--------------------------------------------------------------------------------------------------------------------
1. ESP32 Espressif - amzn.to/3YCq2dS
2. DHT11 Temperature Humidity Sensor - amzn.to/421TIUD
3. Breadboard - amzn.to/3ysOvHX
--------------------------------------------------------------------------------------------------------------------
Useful Video Links
--------------------------------------------------------------------------------------------------------------------
Send DHT11 data to PHP MySQL Server
• Send DHT11 data to PHP...
--------------------------------------------------------------------------------------------------------------------
Social Media Links
--------------------------------------------------------------------------------------------------------------------
GitHub:
github.com/ahmadlogs/
UKposts:
ukposts.info?sub...
--------------------------------------------------------------------------------------------------------------------
Download Code
--------------------------------------------------------------------------------------------------------------------
github.com/ahmadlogs/xampp-esp32
--------------------------------------------------------------------------------------------------------------------
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.
Warning: I will use High Voltages which if incorrectly or improperly used could result in serious injuries or death. So be careful of what you are doing because I will take no responsibility for any of your actions.
Warning: In some countries it is required to register GSM module from govt authorities before using it. So, get proper understanding of govt laws related to GSM technologies.
#esp32 #dht11 #xamppserver

КОМЕНТАРІ: 190
@ansellroman6620
@ansellroman6620 10 місяців тому
httpCode: -1 how i can solve this ??? i think the program is no error. please help
@AhmadLogs
@AhmadLogs 10 місяців тому
The issue you're facing seems to be related to the connection to the localhost. It's possible that your firewall or antivirus software is blocking the connection. To verify this, you can follow these steps: 1. Disable the antivirus and firewall temporarily. 2. Confirm the IP address of your computer. You can do this by checking the network settings or using the command prompt and typing "ipconfig" (for Windows) or "ifconfig" (for macOS/Linux). 3. Check the IP address displayed in the serial monitor of your Arduino. By comparing the IP addresses, you can determine if they match. If they don't match, it could indicate a network configuration issue or a problem with the code. However, if they match and you are still unable to establish a connection, it's likely that the firewall or antivirus software is causing the problem. Remember to re-enable your antivirus and firewall once you have completed the troubleshooting steps. If you continue to experience issues, please provide more details or specific error messages so that I can assist you further. In addition to the steps mentioned earlier, please ensure that both Apache and MySQL services are running on your computer. Here's how you can check: 1. For Apache: Open your web browser and enter "localhost" or "127.0.0.1" in the address bar. If you see a default web page or the Apache server page, it indicates that Apache is running correctly. If not, you may need to start the Apache service. This can typically be done through a control panel or using commands specific to your operating system. 2. For MySQL: You can use a graphical user interface (GUI) tool like phpMyAdmin or MySQL Workbench to verify the status of the MySQL server. Alternatively, you can open the command prompt and enter the command "mysql -u root -p". If you can access the MySQL prompt without any errors, it means that MySQL is running properly. If you encounter any connection errors, you might need to start the MySQL service. Ensuring that both Apache and MySQL are running will ensure the proper functioning of your local development environment. If you encounter any issues or error messages during these checks, please let me know so that I can provide further assistance.
@sujayhl145
@sujayhl145 10 місяців тому
Sir please make a video related to it
@AhmadLogs
@AhmadLogs 10 місяців тому
@@sujayhl145 I will try
@rappuff6458
@rappuff6458 9 місяців тому
@@AhmadLogs is the video up yet sir?
@yasaskumarasinghe1830
@yasaskumarasinghe1830 8 місяців тому
i have the same issue, i try several method using both wampserver and xampp. still no solution, anyone got the answer for this particular error
@edinetgrunhed6000
@edinetgrunhed6000 6 днів тому
now, i know PHP is not dead, it so simple,powerful and once you installed XAMPP everything is there, thank you the video
@savvycreativeadventurer
@savvycreativeadventurer 8 місяців тому
Brilliant! Thank you so much for the easy to understand and follow explanation! So easy to understand and yet such a detailed and thorough explanation. I actually done the setup of my "web server" on a small arm single board computer and i could still follow the examples, just had to change a directory or two in order to us the http folder in my setup.
@Elsa.zoneNt
@Elsa.zoneNt 11 місяців тому
Thanks! This helped a lot, unliked those others who throw codes at you and call it a "tutorial".
@AhmadLogs
@AhmadLogs 11 місяців тому
thanks
@mvcart6316
@mvcart6316 6 місяців тому
You have saved my Final Paper!!!!!!!
@happymatekenya394
@happymatekenya394 7 місяців тому
I am using raspberry pi pico W in Thonny and after following your approach I am now able to send data to my localhost. Thanks alot Sir
@brunodalessio4622
@brunodalessio4622 Рік тому
Thank you very much for this great tutorial and for the very clear explanations. Next step would be to have the temperature with one decimal cipher
@AhmadLogs
@AhmadLogs Рік тому
Great suggestion! can you giveme some more detail
@mrx.0000
@mrx.0000 8 місяців тому
This helped me a lot.Thank you !,very much.
@huytuan6452
@huytuan6452 7 місяців тому
this video helped me a lot, thankyou so much
@user-nb1zf8iy5m
@user-nb1zf8iy5m 7 місяців тому
Excellant presentation. Thank you very much.
@kientong3455
@kientong3455 14 днів тому
thank you sir! you literally saved my project!
@quaninhphamhong7130
@quaninhphamhong7130 8 місяців тому
appreciate your vids so much. They helped me a lot
@AhmadLogs
@AhmadLogs 8 місяців тому
so nice of you
@collinsk8754
@collinsk8754 4 місяці тому
Great tutorial! 👏👏
@Lovely-bx8se
@Lovely-bx8se 16 днів тому
Bonjour, voila enfin un vrais tuto .Merci pour ce temps passé pour cette réalisation. Après avoir réalisé ce projet, j'ai put refaire le même avec un capteur DS18B20 avec un esp8266 ( avec quelque modifications très simple bien sur ).Cela fonctionne parfaitement que ce soit avec XAMPP ou Lamp sur le PI. Continuez , vos vidéos son très intéressantes et riches d'informations. Pour ceux qui on cherché comme moi pour ce genre de projet, ne cherchez plus vous avez trouvé.
@b_space_technology
@b_space_technology 15 днів тому
Je suis du meme avis. Vous êtes de quel pas ?
@Lovely-bx8se
@Lovely-bx8se 12 днів тому
@@b_space_technology Bonjour,de quel pays?De France,pas loin de Paris
@b_space_technology
@b_space_technology 12 днів тому
@@Lovely-bx8se ok super ! J’ai un souci avec ma connexion HTTPclient. Ca me donne un message d’erreur not found. J’aimerai savoir si vous avez exécuté le code net comme dans la vidéo et cela a marché ?
@Lovely-bx8se
@Lovely-bx8se 12 днів тому
@@b_space_technology Bonjour, j'ai effectivement de base utilise le code fournis dans cette vidéo qui a très bien marché. Il est a noté que ma connexion est une Freebox de base sans paramétrage particulier ( port ou autre chose ) avec XAMPP sur ma machine de base. Ton message d'erreur ressemble beaucoup a une erreur concernant l'accès a la page PHP. As tu effectué les test de base de bonne connexion sur la page PHP?L'envois de valeur a partir de cette page sur MYSQL? Avant tous code avec esp.Si oui et que cela fonctionne, as tu bien suivis les conseils pour remplir le champ 44 const char* SERVER_NAME = '',peut etre il manque une lettre, un chiffre
@amiralimohammadi2069
@amiralimohammadi2069 27 днів тому
it's was perfect, I'm really enjoyed
@Lets_Travel712
@Lets_Travel712 29 днів тому
nice video it helped me alot . thank u sir
@labandrick9240
@labandrick9240 Рік тому
Great video as usual and I hope next video would be RFID attendance system v5 with xamp 😊
@AhmadLogs
@AhmadLogs Рік тому
Coming soon!
@labandrick9240
@labandrick9240 Рік тому
@@AhmadLogs thanks that would be great 👍
@prabhakm5144
@prabhakm5144 Рік тому
@@AhmadLogs im having some doubts can u give ur mail id
@danilospinolabatista3249
@danilospinolabatista3249 4 місяці тому
nice video, helped me a lot
@harishananthevarajah3131
@harishananthevarajah3131 2 місяці тому
Thank you so much for the above video sir, but is it possible to make the ESP as an access point instead of station mode
@amanshrestha6528
@amanshrestha6528 5 місяців тому
That really helped me a lot! Thank you very much for the video. I still have a question regarding this. So you showed us how to send dht data from esp32 over wifi network. Is it also possible that esp 32 can send data to xampp server over bluetooth?
@Mihce06
@Mihce06 2 місяці тому
Thanks for this video. Would it be possible to get the HTTPClient library?
@alfonso2ff
@alfonso2ff Рік тому
Show!! It worked perfectly fine! However, it is necessary to alert to release the windows firewall for private networks, otherwise the database is not reached by ESP32. Other than that, congratulations and many thanks for sharing your projects.
@AhmadLogs
@AhmadLogs Рік тому
Thanks for the info
@aligermah3674
@aligermah3674 11 місяців тому
greaat thanks alot every thing is explened well thanks alot
@AhmadLogs
@AhmadLogs 11 місяців тому
so nice of you
@pascalime4276
@pascalime4276 2 місяці тому
thanks a lot your videos is very helpful. However I have a little problem, the serial monitor prints 200 like you said and the websocket client received it well but the table that will store the data didn't create new record, also I refreshed the database but nothing showed what i might be making wrong?
@happymatekenya394
@happymatekenya394 7 місяців тому
You are a Goat
@syaifulannam
@syaifulannam 3 місяці тому
I want to ask. If I want to change the microcontroller with raspberry, are this running with different device?
@ZahidHasan-ky6oy
@ZahidHasan-ky6oy Рік тому
Good job.
@AhmadLogs
@AhmadLogs Рік тому
Many many thanks
@KAVIYAPRABHAKMSEC
@KAVIYAPRABHAKMSEC Рік тому
Can u plzz make tutorial about GPS with node mcu?
@zhepty12
@zhepty12 Місяць тому
heplfull terima kasih..
@leerhoscht
@leerhoscht 8 місяців тому
Thx bro
@AhmadLogs
@AhmadLogs 8 місяців тому
welcome
@ECEpendi
@ECEpendi 3 місяці тому
Sir, what if I want to change it from localhost to the original server or vps server? thanks.
@23mauxanh
@23mauxanh 6 місяців тому
LOVE U
@syaifulannam
@syaifulannam 3 місяці тому
Can i ask sir? I have project to make controlling temperature use AC dimmer and monitoring use max31855k, is it possible to send t temperature data to database? Thanks
@charlesdesouza9313
@charlesdesouza9313 7 місяців тому
The columns in myphpadmin stopped updating after I successfully uploaded the ESP32's code. Do you have any idea how to solve it? In a nutshell, I received the message that it worked with the messages in Serial.print were delievered to my serial monitor, but the data stopped being sent to the MyPHPAdmin.
@user-if1pe2ft1v
@user-if1pe2ft1v 3 місяці тому
Hello , Actually using this library HTTPclient is the synchronous method, because data send through HTTP POST it stuck CPU for sometime. Can you give some Asynchronous method.
@menardcaponpon9152
@menardcaponpon9152 6 місяців тому
hello sir in my case the isset part is not working on mine so the data cannot be displayed in the database whta should i do sir this is for the project in my school appreciate a lot if you reply
@kamalkamel7559
@kamalkamel7559 Рік тому
niiiiiiiiiiice! thank you my freind
@AhmadLogs
@AhmadLogs Рік тому
Thank you! Cheers!
@Pn-lw8ox
@Pn-lw8ox 16 днів тому
Can i use the same arduino ide code but use arduino uno rev4 WiFi , without esp32???
@romnickidang3201
@romnickidang3201 18 днів тому
Can you make a tutorial for storing data in the database using fingerprint
@parvazno
@parvazno Рік тому
that is so great may you explain how we could added another type of sensor like motion detect or siren or take picture with esp32cam and send to server with each motion detect? please extend this project to full other type sensor too. regrads
@AhmadLogs
@AhmadLogs Рік тому
noted.
@user-hx5ge8ll4g
@user-hx5ge8ll4g 10 місяців тому
It was one great tutorial , can u plz do tutorial for sending temperature pressure data using LoRa 32 module and receiving data through LiLyGo lora 32 receiver and then send it to data base.
@AhmadLogs
@AhmadLogs 10 місяців тому
will try soon
@hieuao2509
@hieuao2509 4 місяці тому
can u do it with soilmoisture sensor
@raihanzaenalmutakin9144
@raihanzaenalmutakin9144 6 місяців тому
ESP32 and localhost should have the same connection?
@rogeriohideki
@rogeriohideki Рік тому
would you like to post a project controlling the buttons by mysql along with dht11 on the same page?
@AhmadLogs
@AhmadLogs Рік тому
yes I can, but give me some more detail
@user-if1pe2ft1v
@user-if1pe2ft1v 3 місяці тому
one more thing is -1 or -11 Response code is received in between what is Reason for it??
@korjdeguzman8621
@korjdeguzman8621 24 дні тому
the code is good but it is not proceeding in sending the data in database. There is no error showed but it is not sending the data in database. How to solve that issue? thanks It just showed 'Database connection is ok' in payload no 'new record created successfully ' help me pls
@aadityaparmar5146
@aadityaparmar5146 9 місяців тому
I am getting the compilation error that HTTPClient.h: No such file or directory. Tried to find the library in Git Hub but couldn't find any. Can you please share the library?
@AhmadLogs
@AhmadLogs 8 місяців тому
hmmm. install the latest version of esp32 board in arduino ide
@wasdaletimelapse7658
@wasdaletimelapse7658 Місяць тому
Hi Friend, First let me say that your vide is very good and very easy to follow for a relative newcomer to PHP and Sql. It gives lots of steps and chances to confirm progress throughout the video. I have followed your video to the letter yesterday and all went great until the final step. I have a LAMP server set up on a Raspberry Pi4 and I am using an ESP32 to supply sensor data. The problem I am having is that the (postData) variable does not seem to be accepted by the server. I have tried with two tables in the same database and different types of data but with no success. When I monitor the output of the ESP all looks fine and matches your output exactly. I do get a connection response from the server but no data entry into the database. I have spent hours searching for a solution but I don't have the experience or knowledge to now exactly what I am looking at. I do hope you can help me. Thank you in advance.
@dmbeater2853
@dmbeater2853 Місяць тому
Hello partner, I had the same problem and finally I have solved it. Please check the comments box and look for my comment where I explain what I did. As well as you, I had to expend many hours to do it. Hope it helps you :D
@wasdaletimelapse7658
@wasdaletimelapse7658 Місяць тому
Hi, thank you very much for your reply. I somehow found my way to your explanation earlier today but now I can't remember how I got to it. could you please tell me how to find your comments. Thank you so much.@@dmbeater2853
@wasdaletimelapse7658
@wasdaletimelapse7658 Місяць тому
Hi, I cannot find your comments. Please help. Thank you.@@dmbeater2853
@abhradipdas4998
@abhradipdas4998 8 місяців тому
Data base is connected but could not add new record
@ocean2523
@ocean2523 2 місяці тому
call to 'HTTPClient::begin' declared with attribute error: obsolete API, use ::begin(WiFiClient, url) I am facing this error, please give solution
@jamesjsgaming9254
@jamesjsgaming9254 2 місяці тому
There is an Error in HTTPClient.h its says No such file or directory
@oshadhanirmana9761
@oshadhanirmana9761 2 місяці тому
The requested URL was not found on this server. plz help
@MariaAraujo-pt3cp
@MariaAraujo-pt3cp 9 місяців тому
Hi, I'm following your video but I got stuck in the 21:10 minute mark. I'm trying to validate my IP adress but i always get the HTTP ERROR 404. Do you know what could be the issue? Thank you!
@AhmadLogs
@AhmadLogs 9 місяців тому
hmmm. must connect the esp32 and your localhost machine to the same wifi network. TEST: connect the mobile phone and your localhost machine to the same wifi network. then test the ip address from your mobile phone browser to see if you can access the computer from your phone
@nosagigawidiansyah4016
@nosagigawidiansyah4016 10 місяців тому
Hello good videos! easy and simple to understand but i have issues why i can't get warning "New record created successfully" just connection database is OK? please help me because i use ur code for my thesis, thanks for yout help :)
@AhmadLogs
@AhmadLogs 10 місяців тому
have you checked in the database? see if data is stored in the table or not. use the same table name that I have used
@sidsingh5446
@sidsingh5446 11 місяців тому
Sir can u please retrive the humidity data from the database and perform some task like if humidity data is greater than 40 degree red led will glow
@AhmadLogs
@AhmadLogs 11 місяців тому
It is possible I will try to make a video on it soon
@sidsingh5446
@sidsingh5446 11 місяців тому
@@AhmadLogs thank u sir
@sagnikmitra6584
@sagnikmitra6584 10 місяців тому
Very well explained, I just need 1 more help. How can I send a setpoint value to this interface for controlling the temperature , say for example the temperature should work between 37 to 39 C. I do not want to send this condition in the Arduino code but as a simple txt file or csv file to the phpmyadmin and then check whether it is maintaining. Please do let me know
@AhmadLogs
@AhmadLogs 10 місяців тому
you can send the temperature data to the localhost server. and then The PHP script on the server will then receive the temperature data. it then check the condition "temperature is between 37 to 39 C", then you can perform specific action of the based of the condition true or false
@sagnikmitra6584
@sagnikmitra6584 10 місяців тому
@@AhmadLogs can you help me with the code and give atleast the skeleton?
@AhmadLogs
@AhmadLogs 10 місяців тому
@@sagnikmitra6584 sure!
@sagnikmitra6584
@sagnikmitra6584 10 місяців тому
@@AhmadLogs got the program but what will the setpoint.txt contain, like I want to know what will be written there?
@AhmadLogs
@AhmadLogs 10 місяців тому
@@sagnikmitra6584 the current temperature will be written in the file if within the range (37 to 39 C).
@user-vh5up1qc1r
@user-vh5up1qc1r 11 місяців тому
Hello, i have an error in the HTTPClient.h library, can you tell me which library you used?
@AhmadLogs
@AhmadLogs 11 місяців тому
can you explain the error. It is a built in library. when you install the esp32 core it automatically installed. I am using the esp32 core version 2.0.3
@user-vh5up1qc1r
@user-vh5up1qc1r 11 місяців тому
@@AhmadLogs I already solve the problem. Thank you :)
@a-21_chaudharibhavesh79
@a-21_chaudharibhavesh79 9 місяців тому
similarly how can i send npk value to mysql?
@AhmadLogs
@AhmadLogs 8 місяців тому
can you explain "npk value"?
@wafoguyleonard4106
@wafoguyleonard4106 Рік тому
Hello I did exactly like that. I have on serial monitor "database connection is OK" but new record is not created and the message does not appear on serial monitor. What xan be the problem please?
@AhmadLogs
@AhmadLogs Рік тому
test the php file directly from the localhost to test if the data is stored in the database or not
@jeremiahcruz6854
@jeremiahcruz6854 11 місяців тому
​@@AhmadLogshi I have the same problem. I already tried sending data from php directly to mysql and it was stored successfully. What should I check next?
@dca2814
@dca2814 2 місяці тому
can u give a linkt to httpclient lib?
@maharjanrazib
@maharjanrazib 11 місяців тому
Great Tutorial,but I cannot find HTTPClient Header file, can you help me?
@AhmadLogs
@AhmadLogs 11 місяців тому
it is built-in in the esp32 core you not need to install it separately
@rahuls4479
@rahuls4479 Місяць тому
How to edit the web page
@carlosmiguelzucherato2212
@carlosmiguelzucherato2212 11 місяців тому
Hi your video was very helpful for me!! But unfortunately my httpCode returns "httpCode: -1". My Apache and MySql are running and the IP is correct, Don't know waht to do :/
@AhmadLogs
@AhmadLogs 11 місяців тому
It is strange the project is still not working. is there any firewall blocking the apache or mysql?
@carlosmiguelzucherato2212
@carlosmiguelzucherato2212 11 місяців тому
@@AhmadLogs no, it has full access, i even redownloaded xampp and still nothing
@AhmadLogs
@AhmadLogs 11 місяців тому
@@carlosmiguelzucherato2212 httpCode is returning -1, it typically indicates a failure in establishing a connection to the server. Here are a few things you can check to troubleshoot the issue: 1. Verify the server's IP address: Double-check the URL variable in your code to ensure that it contains the correct IP address 2. Check network connectivity: Ensure that your micro-controller is connected to the network. 3. Firewall or antivirus settings: Check if any firewall or antivirus software is blocking the connection. Temporarily disable them and see if it resolves the issue.
@monishraju4789
@monishraju4789 10 місяців тому
Hiii sir. I couldn't send the data to the database. What i have to do ? Can you help me?
@AhmadLogs
@AhmadLogs 10 місяців тому
give me some more detail about the issue. what error display in the serial monitor
@ZahidHasan-ky6oy
@ZahidHasan-ky6oy Рік тому
Please make a rfid portable attendance system with web admin login page.
@AhmadLogs
@AhmadLogs Рік тому
noted.
@ShawankumarParida
@ShawankumarParida 9 місяців тому
How to store data in a SD card that is connected to esp32 with a sd card module?
@AhmadLogs
@AhmadLogs 8 місяців тому
I will try to make a video on it
@yudimulyadi6201
@yudimulyadi6201 9 місяців тому
Il try and succes until payload : database connection OK But not send data to database mysql, can you help?
@AhmadLogs
@AhmadLogs 9 місяців тому
any error displayed in the serial monitor? give me some more detail
@eduardodaveigabilibio8408
@eduardodaveigabilibio8408 4 місяці тому
I also have this problem, did you manage to solve it?
@user-wr8ln1ru5f
@user-wr8ln1ru5f 10 місяців тому
you didn't explain how to download the HTTPClient library, the one found in the arduino library manager isn't working
@AhmadLogs
@AhmadLogs 10 місяців тому
HTTPClient is the built-in library in the esp32 core. you do not need to install it separately.
@ShamimAhmed-rj9kr
@ShamimAhmed-rj9kr Рік тому
Please make an rfid attendace system with xampp server
@AhmadLogs
@AhmadLogs Рік тому
soon
@sidsingh5446
@sidsingh5446 8 місяців тому
Sir i want to print the sql database data to my arduino serial monitor. Is it possible. Hoe can i make this
@AhmadLogs
@AhmadLogs 8 місяців тому
It might gives you some help. ukposts.info/have/v-deo/nXaZg6KRi3yq02g.html
@sidsingh5446
@sidsingh5446 8 місяців тому
@@AhmadLogs sir please make a complete project on scanning the rfid and the rfid data will match with the sql database in which rfid data is stored. And if the rfid matched with the stored one then open the gate and green led will glow. Otherwise red led will glow
@sidsingh5446
@sidsingh5446 8 місяців тому
There is no video which help me to fetch the data from sql database and print that data to arduino serial monitor using ethernet module or wifi module
@AhmadLogs
@AhmadLogs 8 місяців тому
@@sidsingh5446 will try soon
@srinugovindas9781
@srinugovindas9781 10 місяців тому
Hii Iam doing project right now. My project title is automatic door opening system using pir sensor. For this project, iam using Arduino uno, esp32 and php(xampp server). I wrote the codes for this, Arduino uno code working and esp32 wifi is connected but the data is not stored into the mysql table, what is the problem can u tell me please??
@srinugovindas9781
@srinugovindas9781 10 місяців тому
Can u send your email id , I will send u the full details about the project. It's very urgent
@AhmadLogs
@AhmadLogs 10 місяців тому
I will soon create part two for this video. hope it will solve your issues.
@srinugovindas9781
@srinugovindas9781 10 місяців тому
@@AhmadLogs How much time it will take, it's very urgent iam doing project right now. I need to submit by tomorrow. I already try some coding I will send u, please provide your email id
@srinugovindas9781
@srinugovindas9781 10 місяців тому
Please sir help me!
@AhmadLogs
@AhmadLogs 10 місяців тому
@@srinugovindas9781 upload the code on github and share the link here. I will check that
@agung3h
@agung3h 8 місяців тому
Arduino code Serial.begin(115200); Iam using this code, and after upload is OK then, i am open serial monitor. But, it only shows ?????
@AhmadLogs
@AhmadLogs 8 місяців тому
have you select the correct baudrate from the bottom right corner of the serial monitor?
@agung3h
@agung3h 8 місяців тому
OK thanks
@agung3h
@agung3h 8 місяців тому
Now, i get error when try to send data from arduino if(isset($_POST["pressure"]) && isset($_POST["temperature"])) { $p = $_POST["pressure"]; $t = $_POST["temperature"]; $sql = "INSERT INTO wemosd1 (pressure, temperature) VALUES (".$p.",".$t.")"; after i change value to this code, the data base is not create new data. And it only show "Database connection is OK"
@AhmadLogs
@AhmadLogs 8 місяців тому
@@agung3h use print_r($_POST); at the top of the php file. to see what is inside. $_POST["pressure"]. the issue is with this "pressure" in the POST array. have you set the pressure in the esp32 code? the new code for testing: print_r($_POST); if(isset($_POST["pressure"]) && isset($_POST["temperature"])) { $p = $_POST["pressure"]; $t = $_POST["temperature"]; $sql = "INSERT INTO wemosd1 (pressure, temperature) VALUES (".$p.",".$t.")"; } test it and let me know
@agung3h
@agung3h 8 місяців тому
@@AhmadLogs After use your suggestion code, it show Database connection is OK Array ( )
@memesdealer6178
@memesdealer6178 11 місяців тому
my esp8266 won't reach mysql database, any suggestions?
@AhmadLogs
@AhmadLogs 11 місяців тому
post the serial monitor output here, to figure out the issue
@memesdealer6178
@memesdealer6178 11 місяців тому
@@AhmadLogs [HTTP] GET... failed, error: connection failed ; httpCode: -1 ; payload :
@santiagoespitiatorres2705
@santiagoespitiatorres2705 11 місяців тому
HI i made the same steps but my esp32 does not reach the database, what can be the problem?
@AhmadLogs
@AhmadLogs 11 місяців тому
what error display in the serial monitor
@santiagoespitiatorres2705
@santiagoespitiatorres2705 11 місяців тому
In the payload part doesn’t show “new record created successfully” he can’t reach the database
@sjaycreations1086
@sjaycreations1086 11 місяців тому
same problem - ( httpCode: -1)
@syakilla1510
@syakilla1510 10 місяців тому
Hi thank you for this video. It is an amazing videoo. I am wondering how to send the data to the website and make it visualize. At which part need to modify and how? Hopee that you willl notice this comment and able to respond to this. Thank you!
@AhmadLogs
@AhmadLogs 10 місяців тому
for sending data to website you need to upload the php files on the website, and change the following with the hosting provider credentials. 1. database username 2. database password 3. database name 4. database table name you might watch this video to send data to website. ukposts.info/have/v-deo/m4eXnKaegGtkqX0.html
@syakilla1510
@syakilla1510 10 місяців тому
@@AhmadLogs Okay thank you. Will try to do this soonn
@prapatsornnarmhung7256
@prapatsornnarmhung7256 9 місяців тому
my error is : Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\iot_project\connect.php on line 8 Connection failed: Access denied for user 'root'@'localhost' (using password: YES) So I solved the problem by typing mysql -u root -p on command this is result -> C:\Users\edite>mysql -u root -p Enter password: ************** ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I don't know how to solve it. please help me. Thank you so much!!
@user-cy2hq2zu6q
@user-cy2hq2zu6q 9 місяців тому
I have this problem too. Sir, Please save our life😭😭😭😭
@AhmadLogs
@AhmadLogs 9 місяців тому
test with the default username : root and leave the password blank. then let me know.
@user-cy2hq2zu6q
@user-cy2hq2zu6q 9 місяців тому
​@@AhmadLogs I already fix my problem, Thank you so much!!!
@jhey-nyt6206
@jhey-nyt6206 11 місяців тому
i got httpCode: -1 what is wrong with this?
@AhmadLogs
@AhmadLogs 11 місяців тому
verify your ip address
@nehamiglani1498
@nehamiglani1498 10 місяців тому
I can see 'database connection is ok' but not 'New recorded successfully'. Can you please see this code and tell me where I am going wrong, because I urgently need this for my project
@AhmadLogs
@AhmadLogs 10 місяців тому
ok. you can use the print_r($_POST); function to see if there is any "temp" data. print_r($_POST) will display all the data in the $_POST array. run the code below and see what display in the serial monitor
@nehamiglani1498
@nehamiglani1498 9 місяців тому
@@AhmadLogs Thank you so much! It was of great help. You literally make the best videos.
@AhmadLogs
@AhmadLogs 9 місяців тому
@@nehamiglani1498 thank you so much
@yudimulyadi6201
@yudimulyadi6201 9 місяців тому
@@AhmadLogs I Have same problem, but i try to print_r, i see array dont have any more, can you help to find my mistake ?
@AhmadLogs
@AhmadLogs 9 місяців тому
@@yudimulyadi6201 it means the data is not posting to localhost. have you see any error in the serial monitor?
@suryakiran1325
@suryakiran1325 10 місяців тому
I'm trying to compile your .ino code as per the instructions shown in the video...I'm using esp32 and dht11 sensor. Installed arduino sensor library 1.4.4. I'm getting HTTPClient.h not found error while compiling the program in arduino. Please help.
@AhmadLogs
@AhmadLogs 10 місяців тому
Have you selected the ESP32 board from the Tools menu in the Arduino IDE? The HTTPClient.h library is already included in the ESP32 core, so there is no need to install it separately.
@suryakiran1325
@suryakiran1325 10 місяців тому
@@AhmadLogs yes, sorry I forgot to mention that it is done now...just restarted the PC and error is gone now....anyways thanks...☺️👍
@AhmadLogs
@AhmadLogs 10 місяців тому
@@suryakiran1325 sounds good!
@cmylc657
@cmylc657 11 місяців тому
Hello Sir . I am having this problem " [HTTP] GET... failed, error: connection refused ///httpCode: -1 payload : //// " . I successfully sent test data to database via php.data however I have couldn't send it to the database by arduino . Can you help me please ?
@AhmadLogs
@AhmadLogs 11 місяців тому
make sure your apache and mysql server are up and running. just restart the apache and mysql. I think It will solve the issue
@omarnurhidayat4320
@omarnurhidayat4320 11 місяців тому
@@AhmadLogs i have same problem with him, and i already restart my apache and mysql but still nothing happened sir
@AhmadLogs
@AhmadLogs 11 місяців тому
@@omarnurhidayat4320 then again check your IP Address, also verify that you have entered the correct IP address in the code. just verify it and let me know
LIVE Data storage from RFID cards to MySQL
39:26
IMH Videos
Переглядів 8 тис.
Project Iot Kirim Data Nodemcu Ke MYSQL Database FULL TUTORIAL PART 1
52:13
Hobby Kita Project
Переглядів 6 тис.
1 класс vs 11 класс (рисунок)
00:37
БЕРТ
Переглядів 2,6 млн
ВЫШИБАЛЫ - Сатир, Янчик, Джарахов, Миша, Антон Форсаж
1:09:04
Nonomen funny video😂😂😂 #magic
00:29
Nonomen ノノメン
Переглядів 62 млн
ESP32 Web page creating and updating
32:11
Kris Kasprzak
Переглядів 131 тис.
Send DHT11 data to PHP MySQL Server using NodeMCU ESP8266
9:31
Ahmad Logs
Переглядів 13 тис.
Conexión de ESP32 con base de datos MySQL |  Micropython y XAMPP
14:45
BERMÚDEZ TECH
Переглядів 3,6 тис.
Coding a Web Server in 25 Lines - Computerphile
17:49
Computerphile
Переглядів 312 тис.
Why Some Designs Are Impossible to Improve: Quintessence
33:03
Design Theory
Переглядів 77 тис.
1 класс vs 11 класс (рисунок)
00:37
БЕРТ
Переглядів 2,6 млн