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
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.
***********************************************

Пікірлер: 86

  • @edinetgrunhed6000
    @edinetgrunhed60003 ай бұрын

    this is a great tutorial wit XAMPP very easy

  • @tagelassefa
    @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.

  • @utehstr

    @utehstr

    Жыл бұрын

    You're welcome🙂. I am happy if my video is useful for you.

  • @JS.SANTIAGO
    @JS.SANTIAGO Жыл бұрын

    Parabéns pelo canal! Mais um inscrito

  • @avinashrajedits2217
    @avinashrajedits22174 ай бұрын

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

  • @utehstr

    @utehstr

    4 ай бұрын

    You're welcome 👍🙂

  • @LearnWithGift101
    @LearnWithGift1018 ай бұрын

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

  • @utehstr

    @utehstr

    8 ай бұрын

    You're welcome 🙂

  • @MUHAMMADISMAILALFATIH-

    @MUHAMMADISMAILALFATIH-

    Ай бұрын

    me too bruhh

  • @qwerty3745
    @qwerty3745 Жыл бұрын

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

  • @Dynastie_RB_Rangers
    @Dynastie_RB_Rangers2 ай бұрын

    C'est super

  • @dicksonesamai8746
    @dicksonesamai8746 Жыл бұрын

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

  • @DiyintheGhetto
    @DiyintheGhetto7 ай бұрын

    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.

  • @Kaixiang77441
    @Kaixiang77441 Жыл бұрын

    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.

  • @symibiokatanda6924
    @symibiokatanda6924 Жыл бұрын

    awesome😁😁

  • @utehstr

    @utehstr

    Жыл бұрын

    Thank you 🙂.

  • @africano313
    @africano3137 ай бұрын

    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)

  • @rubialugattimoreira1978
    @rubialugattimoreira1978 Жыл бұрын

    Thanks! Let me sugest a topic, how about sonoff DIY + rainmaker?😘

  • @utehstr

    @utehstr

    Жыл бұрын

    Thank you for the suggestion 👍🙂.

  • @ideconsultora4858
    @ideconsultora4858 Жыл бұрын

    Genio

  • @warrenmabunga7633
    @warrenmabunga7633 Жыл бұрын

    Nice tutorial sir ❤️😊

  • @utehstr

    @utehstr

    Жыл бұрын

    Thank you 👍❤🙂

  • @shogunvanrepi3555

    @shogunvanrepi3555

    Жыл бұрын

    ​@@utehstr tlg buat video monitoring sensor via lora yg dilengkapi fitur table data dan export datanya gan

  • @struggwar
    @struggwar Жыл бұрын

    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.

  • @rollbeats7342

    @rollbeats7342

    9 ай бұрын

    Many webhosts offer hosting services.... you can connect to home network from any place in world too

  • @eliorap
    @eliorap3 ай бұрын

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

  • @mowlidabdi5734
    @mowlidabdi5734 Жыл бұрын

    THANKS BRO

  • @utehstr

    @utehstr

    Жыл бұрын

    You're welcome 🙂.

  • @ariansyahcenter
    @ariansyahcenter Жыл бұрын

    great

  • @utehstr

    @utehstr

    Жыл бұрын

    Thank you 👍🙂

  • @korjdeguzman8621
    @korjdeguzman86214 ай бұрын

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

  • @SCOLIZ
    @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

  • @1398cristhian

    @1398cristhian

    Жыл бұрын

    Hello, were you able to solve this problem?

  • @user-pn6cu1tr1p

    @user-pn6cu1tr1p

    10 ай бұрын

    how you solve this problem please ?

  • @kinhkha1234

    @kinhkha1234

    9 ай бұрын

    how you solve this problem please ?

  • @eliorap

    @eliorap

    3 ай бұрын

    your firewall o antivirus is blocking

  • @MohamedSalahTOUATI-pm6wo

    @MohamedSalahTOUATI-pm6wo

    2 ай бұрын

    @@eliorap you saved my life bro thanks

  • @detfarmers5g
    @detfarmers5g Жыл бұрын

    Can I use the ESP8266 as a replacement?

  • @rifa6888
    @rifa6888 Жыл бұрын

    Is it possible we send sms from db through esp32?

  • @oleksandrkosarevskyy882
    @oleksandrkosarevskyy882 Жыл бұрын

    Does this project have REST architecture?

  • @dandimnet445
    @dandimnet445 Жыл бұрын

    Can it be converted to ESP8266 nodeMCU please? 😞

  • @bektinurwanto
    @bektinurwanto Жыл бұрын

    Update with gauge sir 😁

  • @UMARTILMISANI
    @UMARTILMISANI4 ай бұрын

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

  • @vinlee9812
    @vinlee9812 Жыл бұрын

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

  • @Lovely-bx8se
    @Lovely-bx8se7 ай бұрын

    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

  • @TechnicalYarana
    @TechnicalYarana Жыл бұрын

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

  • @evstark
    @evstark5 күн бұрын

    Can you create that is hosted online?

  • @choudharysaab2039
    @choudharysaab20399 ай бұрын

    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

  • @dandimnet445
    @dandimnet445 Жыл бұрын

    Hi not working on ESP8266 nodeMCU 😞

  • @SamsungJ-hi5gb
    @SamsungJ-hi5gb Жыл бұрын

    how to make Arduino IDE + ESP32CAM + PHP + MySQL Database + XAMPP | ESP32CAM with MySQL Database (localhost)???

  • @JAMIL_01022

    @JAMIL_01022

    8 ай бұрын

    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

  • @mustaphakabou3827
    @mustaphakabou3827 Жыл бұрын

    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.

  • @Lovely-bx8se

    @Lovely-bx8se

    7 ай бұрын

    Bonjour, je viens de suivre pas a pas le tuto et j'ai également le même problème vous pouvez m'aider.Merci

  • @lorenzlandero3842
    @lorenzlandero3842 Жыл бұрын

    no nodemcu 8266?

  • @peterjonessc
    @peterjonessc Жыл бұрын

    Bisakah saya menggunakan ESP8266 sebagai pengganti?

  • @gupchupwalaraipur
    @gupchupwalaraipur Жыл бұрын

    Where is HTTPClient.h library

  • @febrianathala7999
    @febrianathala7999 Жыл бұрын

    Kapan bikin line follower pakek maping hehehe

  • @utehstr

    @utehstr

    Жыл бұрын

    Maaf 🙏, blm buat materi tentang itu, msh ngerjain materi lain.

  • @trongthangtran9944
    @trongthangtran99449 ай бұрын

    IP address it's ip in wifi?

  • @manu2053
    @manu2053 Жыл бұрын

    does it also work with an ESP8266 D1 Mini?

  • @utehstr

    @utehstr

    Жыл бұрын

    The arduino code on this project doesn't work on ESP8266.

  • @manu2053

    @manu2053

    Жыл бұрын

    @@utehstr Is there any possibility to do the same project with an ESP8266

  • @utehstr

    @utehstr

    Жыл бұрын

    @@manu2053 See here: kzread.info/dash/bejne/fG2uy7uzncy9aaw.html

  • @Noname-hc8mj
    @Noname-hc8mj Жыл бұрын

    does it work with Arduino UNO?

  • @utehstr

    @utehstr

    Жыл бұрын

    It doesn't work with Arduino UNO.

  • @eliorap
    @eliorap2 ай бұрын

    Parsing input failed! I don't know where is the error 😭😭

  • @eliorap

    @eliorap

    2 ай бұрын

    the error was, we have to delete the comments in getdata,php before

  • @Hafsa-hafsa25

    @Hafsa-hafsa25

    2 ай бұрын

    For me too. Did you find the problem please?

  • @eliorap

    @eliorap

    Ай бұрын

    @@Hafsa-hafsa25 the error was, we have to delete the comments in getdata,php before

  • @renosiskasyaflina2827
    @renosiskasyaflina2827 Жыл бұрын

    kk, kok saya gagal pengiriman data ke mysqlnya? httpcodenya -1

  • @utehstr

    @utehstr

    Жыл бұрын

    Pastikan bahwa ESP32 dan komputer server berada pada jaringan wifi yang sama.

  • @bimmaulana2702
    @bimmaulana2702 Жыл бұрын

    http eror ada saran ga bro?

  • @minoriproject4552
    @minoriproject4552 Жыл бұрын

    Mas punya banyak source code itu beli dimana ya?, boleh saya beli juga?

  • @minoriproject4552

    @minoriproject4552

    Жыл бұрын

    Untuk belajar

  • @utehstr

    @utehstr

    Жыл бұрын

    Saya gak beli source code, saya buat sendiri, tentu saja dari berbagai sumber referensi.

  • @minoriproject4552

    @minoriproject4552

    Жыл бұрын

    Wahh hebat banget mas

  • @utehstr

    @utehstr

    Жыл бұрын

    @@minoriproject4552 Gk hebat2 banget kok 🙂, cm rajin nyoba2 aja.

  • @catl3593
    @catl35936 ай бұрын

    is it possible with esp8266

  • @utehstr

    @utehstr

    6 ай бұрын

    See here: kzread.info/dash/bejne/fG2uy7uzncy9aaw.htmlfeature=shared

  • @AtansZhao
    @AtansZhao3 ай бұрын

    use SQLite in esp32 may be better, haha

  • @adisolehudin4kb055
    @adisolehudin4kb055 Жыл бұрын

    mas buat yang versi Nodemcu 8266 dengan tampilan yang sama dengan video ini dong

  • @mohamadhosseinmetanat
    @mohamadhosseinmetanat Жыл бұрын

    How can I contact you?

  • @woraliteaimsamran9866
    @woraliteaimsamran986610 ай бұрын

    ขี้งกจัด

  • @Lovely-bx8se
    @Lovely-bx8se7 ай бұрын

    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

Келесі