Arduino IDE + NodeMCU ESP12E ESP8266 + MySQL Database | NodeMCU Getting Data from MySQL Database

Arduino IDE + NodeMCU ESP12E ESP8266 + MySQL Database | NodeMCU ESP12E ESP8266 Getting Data from MySQL Database. In this project video I use Arduino IDE 1.8.9 , Notepad++ V7.7.1 , MySQL Database with XAMPP V.3.2.2 , LED and NodeMCU ESP12E ESP8266.

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:

***********************************************
***********************************************
Image Source:
***********************************************
Reference :

and from several other sources.
***********************************************
Music Background:

Luxury by Causmic
Genre and Mood : Hip-hop and Rap | Calm

Track: Sunflower — Soyb [Audio Library Release]
Music provided by Audio Library Plus

Creative Commons — Attribution 3.0 Unported — CC BY 3.0
***********************************************

[walteravellaneda]

It is the best video tutorial I have seen on the ESP8266 module, PHP and phpmyadmin. Thank you very much friend

[arupghosh]

thanks to make a farmer like me happy...

[rubialugattimoreira]

Excelente! Congratulations for smart IOT projects.

[genaminin]

This is what I was looking for. thanks a lot!!!

[allenaxon]

Hi, thanks for the video. My problem is that everything is working until it gets to the " if " statement, regardless whether the serial monitor shown "1" or "0" it just jump to the "else" part, and the Led stay on.
if (payloadGet == "1") {
Serial.println(payloadGet);
digitalWrite(LED_D8, LOW); //--> Turn off
}
else {
Serial.print("turn Led ON"); //for debugging
digitalWrite(LED_D8, HIGH); //--> Turn on
}
I suspect it is this "String payloadGet = http.getString();"'
the "payloadGet" is a String, so the "if" can't evaluate the result.
Any help will be greatly appreciated. Thanks!

[nwbstplyr]

Hi and great video! I am curious to know if how can you use the data from the database like say for an example the data is a PHONE NUMBER on the database and I want to get that value everytime a card is scanned pertaining to that card so that I can send a message using a gsm module? Im using rfid and the only thing missing is this idea. Any help would be greatly appreciated thanks!

[young]

This is amazing tutorial... But i have a question for you sir. In this video you are make LED ON or OF base on a value in the first column. Have you ever make it with read state 1 or 0, but from last column that submited. The purpose if 1 want to record date time when 1 turn on or off LED. Please answer, and make a tutorial + share code. Thank.. God blash you

[alfredosantos-rsyl]

How about the scheduling. Can you set a start datetime and end date and time?

[ismail_aydemir_mylife]

bu aynı zamanda localhost olmayan, gerçek sitedende çalışabilir mi? bu konuda mysql olmadan yapılamaz mı?

Olá amigo, preciso de uma ajuda, eu não consigo compilar esse codigo, da esse erro, exit status 1
Compilation error: call to 'HTTPClient::begin' declared with attribute error: obsolete API, use ::begin(WiFiClient, url) sou novato em ESP e estou apanhando um pouco, quer dizer bastante.

[TechnicalYarana]

sir isko ham esp32 me nahi bana sakte hai kya

[andrewsanjaya]

thanks, it helps me a lot. but i have question, how to get a dynamic data?

[matiasleiva]

Hola! es posible realizarlo con un Ethernet Shield?.

[old-egy]

very good you are smart and have a lot of feeling

[vidixagoeng]

good video, keep it up

(suggestion) try with more LED, it will make it more interesting

[LeimanGoVlog]

Apa sudah coba mas untuk sekaligus database menerima data yang dikirim dari esp?

[yadwindersingh]

Can i control from anywhere using this method?

[matiasleiva]

Excelente video! podría ayudarme con algunas dudas?

[FSEProjectToturial]

Gimna cara ny menggabungkan banyak esp ke 1 server mysql gan?

[PqMQQWE]

misi mas, mau tanya, itu echo $data['stat'] yang ada di file GetData.php, gunanya untuk apa ya mas? Apakah untuk pengecekan saja, kalau datanya berhasil diambil? atau itu memang penting, untuk nanti diteruskan ke NodeMcu nya (masuk ke payloadget)? Saya sudah mnegerti code code yang lainnya, tetapi hanya ini saja yang membuat saya bingung. Sebelumnya terima kasih, video nya sangat membantu. Saya jadi lebih mengerti dengan apa itu request dan respond, terutama untuk di Mikrokontroler