Arduino IDE + ESP32 + PHP + MySQL Database + XAMPP | ESP32 with MySQL Database (localhost)

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

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:

***********************************************

***********************************************
***********************************************

***********************************************
Libraries used :
***********************************************

***********************************************
Source of icon on Thumbnail :
***********************************************

***********************************************
Reference :

and from other sources that I can not write one by one.
***********************************************

[LearnWithGift]

Thank you so much man you've saved my life with this tutorial 🙏

[edinetgrunhed]

this is a great tutorial wit XAMPP very easy

[avinashrajedits]

Thank you so much sir I learned lot of things from this video ❤❤

[tagelassefa]

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.

[qwerty]

Hi. Great project. I want to fully remove LED controlling and use it like my bedroom IAQ controlling. Can you help me with that?

[dicksonesamai]

Thanks.
Any book that can broaden my understanding of Arduino and Database connection?

[detfarmersg]

Can I use the ESP8266 as a replacement?

[korjdeguzman]

why when I use float in temperature it don't give data? but yours is working. What did you do?

[dandimnet]

Can it be converted to ESP8266 nodeMCU please? 😞

[rifa]

Is it possible we send sms from db through esp32?

[eliorap]

excellent, but I only get TEMPERATURE NN°C , HUMIDITY NN % WHY? I'm following all steps, the esp32 connect very well

[oleksandrkosarevskyy]

Does this project have REST architecture?

[DiyintheGhetto]

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.

[Kaixiang]

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.

[TechnicalYarana]

brother where is databse.php file please give me ??

[UMARTILMISANI]

kalau pengen ngecek data tersebut ada di database atau engga gimana bang? kayak ngecek apakah uid rfid terdaftar di database atau engga, thanks

[vinlee]

Hi Friend izit any others ways if i don't want to use localhost?

[choudharysaab]

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

[SCOLIZ]

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

[africano]

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)