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.
***********************************************
28 июн 2024