Uploaded October 2022 | Updated September 2026, 2 weeks ago

---

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/1fErvEQtL7AHs8Y7uIqs6nFZm20Ao51Sp/view?usp=sharing

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 : youtube.com/watch?v=-BIq32-qEgA&list=PLnXsmScWzcm6RVlhPM7qg_OJ2N8OpV99d
- Electronics Tutorials : youtube.com/watch?v=rLdsWt6EP6w&list=PLnXsmScWzcm766h5Dn4AJjbJRzDfCPh4h
- Arduino Tutorials : youtube.com/watch?v=A3_EBZqCG5s&list=PLnXsmScWzcm48hvcTTRAUFcP5Fjd4u8cS
- Great Cow Basic Tutorials : youtube.com/watch?v=orHrLmEvp0o&list=PLnXsmScWzcm7xejzacm5cKJMIh_tXXxN8
- Bascom Avr Tutorials : youtube.com/watch?v=JYKSkNQq9eM&list=PLnXsmScWzcm6F9gX1wYenqjKdqVSM7d6B
- VB .NET Tutorials : youtube.com/watch?v=Sy2vjWO0ydM&list=PLnXsmScWzcm4g8AWEJ6WXVUOBh_cWF5_z
- LoLin NodeMCU V3 ESP12E ESP8266 Tutorials : youtube.com/watch?v=8jMr94B8iN0&list=PLnXsmScWzcm5MERfTvcUNKsYhOUGKe3-V
- ESP32 Tutorials : youtube.com/watch?v=To3TIOFX6cA&list=PLnXsmScWzcm7Y5yCDItJP5Kny_MJ8DeDD
- ESP32 CAM Tutorials : youtube.com/watch?v=_5VmYJZI4XI&list=PLnXsmScWzcm6HjC0CIfVmRG1855tjhj5z
***********************************************

***********************************************
Download Arduino IDE : arduino.cc/en/software
Download Notepad++ : notepad-plus-plus.org/downloads
Download XAMPP : apachefriends.org/download.html
***********************************************

***********************************************
Libraries used :
- DHT sensor library : arduino.cc/reference/en/libraries/dht-sensor-library
- Adafruit Unified Sensor : arduino.cc/reference/en/libraries/adafruit-unified-sensor
- Arduino_JSON : arduino.cc/reference/en/libraries/arduino_json
***********************************************

***********************************************
Source of icon on Thumbnail :
- XAMPP icon : iconfinder.com/icons/96018/xampp_icon
- PHP icon : iconfinder.com/icons/4373082/file_logo_logos_php_script_type_icon
- MySQl icon : iconfinder.com/icons/1012821/code_development_logo_mysql_icon
- Database icon : iconfinder.com/icons/299089/database_icon
***********************************************

***********************************************
Reference :
- Color reference when editing video : arduino.cc/en/Trademark/CommunityLogo
- Generate Random Alphanumeric Strings in PHP : code.tutsplus.com/tutorials/generate-random-alphanumeric-strings-in-php--cms-32132
- JSON PHP : w3schools.com/js/js_json_php.asp
- Send POST data using XMLHttpRequest : stackoverflow.com/questions/9713058/send-post-data-using-xmlhttprequest
- ambiguous overload for 'operator=' : arduinojson.org/v6/error/ambiguous-overload-for-operator-equal
- compare a char array in if statement : forum.arduino.cc/t/compare-a-char-array-in-if-statement/89991/5
- Date and time in 24 hours format : stackoverflow.com/a/65439792
- Creating beautiful HTML tables with CSS : dev.to/dcodeyt/creating-beautiful-html-tables-with-css-428l
- pure javascript table row pagination : stackoverflow.com/a/68453319

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