Тёмный

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

Uteh Str
Подписаться 18 тыс.
Просмотров 75 тыс.
50% 1

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

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 84   
@JS.SANTIAGO
@JS.SANTIAGO Год назад
Parabéns pelo canal! Mais um inscrito
@LearnWithGift101
@LearnWithGift101 7 месяцев назад
Thank you so much man you've saved my life with this tutorial 🙏
@utehstr
@utehstr 7 месяцев назад
You're welcome 🙂
@edinetgrunhed6000
@edinetgrunhed6000 2 месяца назад
this is a great tutorial wit XAMPP very easy
@avinashrajedits2217
@avinashrajedits2217 3 месяца назад
Thank you so much sir I learned lot of things from this video ❤❤
@utehstr
@utehstr 3 месяца назад
You're welcome 👍🙂
@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.
@Dynastie_RB_Rangers
@Dynastie_RB_Rangers 24 дня назад
C'est super
@symibiokatanda6924
@symibiokatanda6924 Год назад
awesome😁😁
@utehstr
@utehstr Год назад
Thank you 🙂.
@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
@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?
@ideconsultora4858
@ideconsultora4858 11 месяцев назад
Genio
@DiyintheGhetto
@DiyintheGhetto 6 месяцев назад
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.
@africano313
@africano313 6 месяцев назад
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)
@Kaixiang77441
@Kaixiang77441 11 месяцев назад
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.
@rubialugattimoreira1978
@rubialugattimoreira1978 Год назад
Thanks! Let me sugest a topic, how about sonoff DIY + rainmaker?😘
@utehstr
@utehstr Год назад
Thank you for the suggestion 👍🙂.
@dicksonesamai8746
@dicksonesamai8746 Год назад
Thanks. Any book that can broaden my understanding of Arduino and Database connection?
@eliorap
@eliorap Месяц назад
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 👍🙂
@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 8 месяцев назад
Many webhosts offer hosting services.... you can connect to home network from any place in world too
@korjdeguzman8621
@korjdeguzman8621 2 месяца назад
why when I use float in temperature it don't give data? but yours is working. What did you do?
@dandimnet445
@dandimnet445 Год назад
Can it be converted to ESP8266 nodeMCU please? 😞
@Lovely-bx8se
@Lovely-bx8se 6 месяцев назад
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
@detfarmers5g
@detfarmers5g Год назад
Can I use the ESP8266 as a replacement?
@bektinurwanto
@bektinurwanto Год назад
Update with gauge sir 😁
@choudharysaab2039
@choudharysaab2039 8 месяцев назад
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
@rifa6888
@rifa6888 Год назад
Is it possible we send sms from db through esp32?
@TechnicalYarana
@TechnicalYarana Год назад
brother where is databse.php file please give me ??
@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 11 месяцев назад
Hello, were you able to solve this problem?
@user-pn6cu1tr1p
@user-pn6cu1tr1p 9 месяцев назад
how you solve this problem please ?
@kinhkha1234
@kinhkha1234 8 месяцев назад
how you solve this problem please ?
@eliorap
@eliorap Месяц назад
your firewall o antivirus is blocking
@MohamedSalahTOUATI-pm6wo
@MohamedSalahTOUATI-pm6wo Месяц назад
@@eliorap you saved my life bro thanks
@oleksandrkosarevskyy882
@oleksandrkosarevskyy882 Год назад
Does this project have REST architecture?
@vinlee9812
@vinlee9812 Год назад
Hi Friend izit any others ways if i don't want to use localhost?
@UMARTILMISANI
@UMARTILMISANI 3 месяца назад
kalau pengen ngecek data tersebut ada di database atau engga gimana bang? kayak ngecek apakah uid rfid terdaftar di database atau engga, thanks
@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 7 месяцев назад
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
@gupchupwalaraipur
@gupchupwalaraipur Год назад
Where is HTTPClient.h library
@peterjonessacrobunac1146
@peterjonessacrobunac1146 Год назад
Bisakah saya menggunakan ESP8266 sebagai pengganti?
@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 6 месяцев назад
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?
@trongthangtran9944
@trongthangtran9944 7 месяцев назад
IP address it's ip in wifi?
@febrianathala7999
@febrianathala7999 Год назад
Kapan bikin line follower pakek maping hehehe
@utehstr
@utehstr Год назад
Maaf 🙏, blm buat materi tentang itu, msh ngerjain materi lain.
@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.
@eliorap
@eliorap Месяц назад
Parsing input failed! I don't know where is the error 😭😭
@eliorap
@eliorap Месяц назад
the error was, we have to delete the comments in getdata,php before
@Hafsa-hafsa25
@Hafsa-hafsa25 24 дня назад
For me too. Did you find the problem please?
@eliorap
@eliorap 21 день назад
@@Hafsa-hafsa25 the error was, we have to delete the comments in getdata,php before
@Noname-hc8mj
@Noname-hc8mj 11 месяцев назад
does it work with Arduino UNO?
@utehstr
@utehstr 11 месяцев назад
It doesn't work with Arduino UNO.
@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-J9ziYzmiW9I.html
@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.
@bimmaulana2702
@bimmaulana2702 Год назад
http eror ada saran ga bro?
@AtansZhao
@AtansZhao 2 месяца назад
use SQLite in esp32 may be better, haha
@adisolehudin4kb055
@adisolehudin4kb055 Год назад
mas buat yang versi Nodemcu 8266 dengan tampilan yang sama dengan video ini dong
@catl3593
@catl3593 4 месяца назад
is it possible with esp8266
@utehstr
@utehstr 4 месяца назад
See here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-J9ziYzmiW9I.htmlfeature=shared
@mohamadhosseinmetanat
@mohamadhosseinmetanat Год назад
How can I contact you?
@woraliteaimsamran9866
@woraliteaimsamran9866 9 месяцев назад
ขี้งกจัด
@Lovely-bx8se
@Lovely-bx8se 6 месяцев назад
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
Далее
ESP32 CAM with Google drive
5:45
Просмотров 4,8 тыс.
Arduino To ESP32: How to Get Started!
9:26
Просмотров 230 тыс.
ESP32 DHT Web Server Project
5:53
Просмотров 97 тыс.
Mac Studio из Китая 😈
0:34
Просмотров 125 тыс.