Arduino IDE + ESP32 + PHP + MySQL Database + XAMPP | ESP32 with MySQL Database (localhost)
ฝัง
- เผยแพร่เมื่อ 18 พ.ค. 2024
- Arduino IDE + ESP32 + PHP + MySQL Database + XAMPP | ESP32 with MySQL Database (localhost).
In this project video I use Arduino IDE (V1.8.9), Notepad++ (V8.4.6), Arduino Core for The ESP32 (V1.0.6), XAMPP (V3.2.2), PHP (V7.3.0), ESP32 (ESP32 DEVKIT V1), DHT11 Sensor and LEDs.
00:00 Opening
00:33 Project Preview
01:46 Modules and Components used in this project
02:08 Installation
02:13 Testing the Installation
04:07 Testing the Installation - Demo
04:29 Testing ESP32 sending and receiving data to/from MySQL Database
04:35 Testing ESP32 sending and receiving data to/from MySQL Database - Creating Databases and Tables
06:29 Testing ESP32 sending and receiving data to/from MySQL Database - PHP Code
09:08 Testing ESP32 sending and receiving data to/from MySQL Database - Arduino Code
12:25 Testing ESP32 sending and receiving data to/from MySQL Database - Demo
14:07 Final ESP32 with MySQL Database
14:14 Final ESP32 with MySQL Database - Creating Databases and Tables
15:24 Final ESP32 with MySQL Database - PHP Code
22:40 Final ESP32 with MySQL Database - Arduino Code
24:30 Final ESP32 with MySQL Database - Demo
27:43 Closing
Download Arduino Code and other files : drive.google.com/file/d/1fErv...
The code file is saved in the .rar file format. I created a .rar file using Winrar V5.50, so to extract it, make sure you use the same version of Winrar that I use or the latest version or use the winrar extractor online.
SORRY IF MY ENGLISH IS CONFUSING, I USE AN ONLINE TRANSLATOR.
THANKS FOR WATCHING & DON'T FORGET TO LIKE , SHARE, COMMENT AND SUBSCRIBE.
***********************************************
For other video tutorials on this channel, please see this playlist:
- Basic4Android (B4A) Tutorials : • Basic4Android (B4A) | ...
- Electronics Tutorials : • 3 LED Flip Flop
- Arduino Tutorials : • Arduino | Scrolling Te...
- Great Cow Basic Tutorials : • Great Cow BASIC with A...
- Bascom Avr Tutorials : • Bascom Avr | How to Se...
- VB .NET Tutorials : • Visual Basic .NET | ...
- LoLin NodeMCU V3 ESP12E ESP8266 Tutorials : • Arduino | LoLin NodeMC...
- ESP32 Tutorials : • Arduino IDE + ESP32 | ...
- ESP32 CAM Tutorials : • Arduino IDE + ESP32 Ca...
***********************************************
***********************************************
Download Arduino IDE : www.arduino.cc/en/software
Download Notepad++ : notepad-plus-plus.org/downloads/
Download XAMPP : www.apachefriends.org/downloa...
***********************************************
***********************************************
Libraries used :
- DHT sensor library : www.arduino.cc/reference/en/l...
- Adafruit Unified Sensor : www.arduino.cc/reference/en/l...
- Arduino_JSON : www.arduino.cc/reference/en/l...
***********************************************
***********************************************
Source of icon on Thumbnail :
- XAMPP icon : www.iconfinder.com/icons/9601...
- PHP icon : www.iconfinder.com/icons/4373...
- MySQl icon : www.iconfinder.com/icons/1012...
- Database icon : www.iconfinder.com/icons/2990...
***********************************************
***********************************************
Reference :
- Color reference when editing video : www.arduino.cc/en/Trademark/C...
- Generate Random Alphanumeric Strings in PHP : code.tutsplus.com/tutorials/g...
- JSON PHP : www.w3schools.com/js/js_json_...
- Send POST data using XMLHttpRequest : stackoverflow.com/questions/9...
- ambiguous overload for 'operator=' : arduinojson.org/v6/error/ambi...
- compare a char array in if statement : forum.arduino.cc/t/compare-a-...
- Date and time in 24 hours format : stackoverflow.com/a/65439792
- Creating beautiful HTML tables with CSS : dev.to/dcodeyt/creating-beaut...
- pure javascript table row pagination : stackoverflow.com/a/68453319
and from other sources that I can not write one by one.
*********************************************** - วิทยาศาสตร์และเทคโนโลยี
Parabéns pelo canal! Mais um inscrito
this is a great tutorial wit XAMPP very easy
Thank you so much man you've saved my life with this tutorial 🙏
You're welcome 🙂
I really thank you very much for your kindness to give us the full Source code and a step by step guide. I followed and get the same result as you did. I also integrated send updated data to Telegram bot.
You're welcome🙂.
I am happy if my video is useful for you.
Thank you so much sir I learned lot of things from this video ❤❤
You're welcome 👍🙂
Hi. Great project. I want to fully remove LED controlling and use it like my bedroom IAQ controlling. Can you help me with that?
Thanks.
Any book that can broaden my understanding of Arduino and Database connection?
THANKS BRO
You're welcome 🙂.
Hi Uteh Str, I am one of your viewers and I have watched your video on controlling DHT11 and LED using MySQL and PHP. Currently, I am working on a project that requires the use of HX711 to collect data, and I was wondering if you could create a video on using HX711 and DHT11 with MySQL and PHP to help me with this project. The video should cover real-time data visualization and data logging. Your help would be greatly appreciated. Thank you.
Genio
Nice tutorial sir ❤️😊
Thank you 👍❤🙂
@@utehstr tlg buat video monitoring sensor via lora yg dilengkapi fitur table data dan export datanya gan
awesome😁😁
Thank you 🙂.
Hello, Thank you for all you done on this project it is awesome. I have one question. I have relays two of them. I need to trigger them on then off after some time. Can you help me out please? I'm not good at coding but I'm good at hardware.
great
Thank you 👍🙂
All your videos are great but I could only confirm from these webserver database videos that they are meant for intranet only i.e. these projects won't work through the internet from remote location.
So, I'll be very helpful to you if you could make a detailed video on the database server reading sensors data and controlling appliances using NodeMcu (ESP8266) through the internet from any remote location.
Many webhosts offer hosting services.... you can connect to home network from any place in world too
Thanks! Let me sugest a topic, how about sonoff DIY + rainmaker?😘
Thank you for the suggestion 👍🙂.
excellent, but I only get TEMPERATURE NN°C , HUMIDITY NN % WHY? I'm following all steps, the esp32 connect very well
Can it be converted to ESP8266 nodeMCU please? 😞
Um exemplo muito bem explicado. parabéns. Eu somente consegui atualizações no banco de dados, após desligar o FIREWALL do Win 10. apanhei muito com isto.
isto se deve por ser LOCAL (ESP32 no mesmo PC)
Does this project have REST architecture?
Can I use the ESP8266 as a replacement?
Is it possible we send sms from db through esp32?
kalau pengen ngecek data tersebut ada di database atau engga gimana bang? kayak ngecek apakah uid rfid terdaftar di database atau engga, thanks
why when I use float in temperature it don't give data? but yours is working. What did you do?
plase mack a video how to get esp32 in ac volt and ampere send mysql database using ZMPT101B + SCT-013-030 Non-invasive AC Current Sensor
Hi Friend izit any others ways if i don't want to use localhost?
Hi not working on ESP8266 nodeMCU 😞
Bisakah saya menggunakan ESP8266 sebagai pengganti?
Bonjour, Juste pour indiquer qu'il suffit de bien suivre le tuto.J'avais fait une erreur et forcement ca fonctionne pas !!Encore une fois merci pour ce tuto très clair. Serait il possible de vous contactez avec un projet identique mais avec un bouton poussoir, une sonde DS18b20,les deux LEDs et un relais avec un timer.Merci
Update with gauge sir 😁
no nodemcu 8266?
brother where is databse.php file please give me ??
Hi friend, thanks for the tutorial but think there's a lot off ambiguity about dbUsername, dbPassword, dbhost and dbName. httpCode return 404 when getdata.php, updateDHT11data.php and Parsing input failed! when control_LEDs(), please can you explain me what's can cause this problem.
Bonjour, je viens de suivre pas a pas le tuto et j'ai également le même problème vous pouvez m'aider.Merci
how to make Arduino IDE + ESP32CAM + PHP + MySQL Database + XAMPP | ESP32CAM with MySQL Database (localhost)???
Hi, can I get it that way .. if there is, let me know, I really need it because I want to do a final project
What does the data httpCode : -1 in serial port monitor
means? (in the part of testing ESP32 sending and receiving data). It gives me that instead of httpCode : 200
Hello, were you able to solve this problem?
how you solve this problem please ?
how you solve this problem please ?
your firewall o antivirus is blocking
@@eliorap you saved my life bro thanks
http eror ada saran ga bro?
Where is HTTPClient.h library
IP address it's ip in wifi?
Parsing input failed! I don't know where is the error 😭😭
the error was, we have to delete the comments in getdata,php before
does it also work with an ESP8266 D1 Mini?
The arduino code on this project doesn't work on ESP8266.
@@utehstr Is there any possibility to do the same project with an ESP8266
@@manu2053 See here: th-cam.com/video/J9ziYzmiW9I/w-d-xo.html
does it work with Arduino UNO?
It doesn't work with Arduino UNO.
Kapan bikin line follower pakek maping hehehe
Maaf 🙏, blm buat materi tentang itu, msh ngerjain materi lain.
Mas punya banyak source code itu beli dimana ya?, boleh saya beli juga?
Untuk belajar
Saya gak beli source code, saya buat sendiri, tentu saja dari berbagai sumber referensi.
Wahh hebat banget mas
@@minoriproject4552 Gk hebat2 banget kok 🙂, cm rajin nyoba2 aja.
is it possible with esp8266
See here: th-cam.com/video/J9ziYzmiW9I/w-d-xo.htmlfeature=shared
kk, kok saya gagal pengiriman data ke mysqlnya? httpcodenya -1
Pastikan bahwa ESP32 dan komputer server berada pada jaringan wifi yang sama.
use SQLite in esp32 may be better, haha
mas buat yang versi Nodemcu 8266 dengan tampilan yang sama dengan video ini dong
How can I contact you?
ขี้งกจัด
Bonjour, merci pour le tutoriel très précis, mais j'ai une erreur : httpCode renvoie 404 lorsque getdata.php, updateDHT11data.php et l'entrée d'analyse ont échoué ! lorsque control_LEDs(), pouvez-vous m'expliquer ce qui peut causer ce problème.
Merci de votre reponse