ESP8266 + Arduino + database - Control Anything from Anywhere

Рет қаралды 628,655

Күн бұрын

$2 for 5PCBs (Any solder mask colour): jlcpcb.com
Make a WIFi connection, uplaod the PHP files and send and get data from an online database and by that control anything from anywhere in the world with WiFi connection. The options are limitless... Just have an idea...
Help my projects on Patreon : / electronoobs
my Q&A page: electronoobs.com/eng_preguntas...
Facebook page: / electronoobs
Canal en Español: / electronoobs en español
LINKS
-------------------------------------
Tutorial website :electronoobs.com/eng_arduino_t...
Schematic: electronoobs.com/images/Arduin...
Project ZIP file: electronoobs.com/images/Arduin...
000Webhost: www.000webhost.com/
🔬PRINTERS FDM
-------------------------------------
Artillery Sidewinderr X1 (364€ Aliexpress): s.click.aliexpress.com/e/_9y9haI
Artillery GENIUS (307€ Aliexpress): s.click.aliexpress.com/e/_A9SvG2
Creality3D Ender 3 Pro (230€ Aliexpress): s.click.aliexpress.com/e/_APcCa2
Anycubic Mega S (206€ Aliexpress): s.click.aliexpress.com/e/_ALcTLs
ELEGOO NEPTUNE 2 (186€ Aliexpress): s.click.aliexpress.com/e/_AM2y7c
Prusa i3 MK3S Clone (393€ Aliexpress): s.click.aliexpress.com/e/_ASNXyi
Creality CR-10 V3 (480€ Aliexpress): s.click.aliexpress.com/e/_AnycCO
🔅PRINTERS RESIN
-------------------------------------
ELEGOO Mars Pro (208€ Aliexpress): s.click.aliexpress.com/e/_A0nVFY
ELEGOO Saturn MSLA (480€ Aliexpress): s.click.aliexpress.com/e/_AKxJim
Anycubic Photon Mono (199€ Aliexpress): s.click.aliexpress.com/e/_9ulv4K
Creality HALOT ONE (275€ Aliexpress): s.click.aliexpress.com/e/_Ak7jBC
Like share and subscribe to motivate me. Thank you
#ESP8266
#Arduino
#IOT

Пікірлер: 584

@ELECTRONOOBS 5 жыл бұрын

Follow me on FACEBOOK for more: facebook.com/Electronoobs help me on Patreon: www.patreon.com/ELECTRONOOBS

@user-bi5yj7hs9t 5 жыл бұрын

Te olvidas de el canal hispano :")

@skyevanderheijden5382 4 жыл бұрын

i have connected everything correctly but it does not work. when i open my serial monitor it keeps spitting out: 17:22:58.002 -> `f⸮⸮f⸮f~⸮⸮⸮⸮⸮f⸮f⸮⸮⸮f⸮⸮timeout 1 17:23:07.026 -> ESP CHECK FAILED 17:23:12.084 -> timeout 1 17:23:12.084 -> ESP RESET FAILED 17:23:17.122 -> timeout 1 17:23:17.122 -> ESP CWMODE SET FAILED 17:23:27.236 -> timeout 1 17:23:27.236 -> ESP SSID SET FAILED 17:23:27.275 -> CHECKING FOR AN IP ADDRESS 17:23:37.353 -> timeout 1 17:23:37.353 -> IP ADDRESS FAILtimeout 1 17:23:42.396 -> ESP CIPMUX SET FAILED 17:23:42.429 -> CONNECTING 17:23:47.517 -> timeout 1 17:23:47.517 -> FAILED TO CONNECT 17:23:52.560 -> timeout 1 i don't know how to fix this please help.

@khalidzaid123 4 жыл бұрын

@@skyevanderheijden5382 me too the same my error

@arunjallipalli8118 4 жыл бұрын

I also had same error please help me to fix it

@thijsschrooten9843 4 жыл бұрын

@@skyevanderheijden5382 Have you fixed this issue? I have the same issue but i think you need to make some changes in the code or something. I think you need to put some text in the serial monitor but I havent figured it out yet.

@Gmtail 4 жыл бұрын

Thank you for properly explaining things from start to end.. Most KZfaqrs assume people already know about PHP or making a web site, but I do not as I am sure others. So again, thank you for taking the time and doing it properly.

@jonmms9193 3 жыл бұрын

Now I don't know if anyone has spotted this. There is a ***MISTAKE*** in the schematic at 8:11 in the video. The voltage divider is wrongly connected to the Rx pin of the 8266 and pin 11 of the Arduino MEGA. One must disconnect: 1) upper terminal of the 1k resistor from pin 4 of the 8266 and 2) cyan wire from pin 11 of the MEGA and switch them over i.e. the cyan wire goes to the 8266 pin 4 and the upper terminal of the 1k resistor goes to pin 11 of the MEGA. If you leave it as is, no voltage dividing is accomplished and the full 5V level is applied to the Rx pin of the 8266; this can stress the ic to unknown results. Having said that, CONGRATS for one more great video and project!

@tcape72 4 жыл бұрын

great video, was able to create the website and uploaded and edited the files and had it working in about a half hour. Your instructions were perfect, thanks. Now I have to do the Arduino stuff.

@josephcagiano3055 2 жыл бұрын

One of the best channels I’ve ever found. Very grateful for your videos. Greetings from USA.

@MarceloCutin 5 жыл бұрын

Thanks for sharing! This project really opens a wide range of possibilities.

@trashk1483 3 жыл бұрын

Hai.. do u have the sample code for this project.???? Can u help me please???

@vasuyadav2931 3 жыл бұрын

@@trashk1483 The link to the tutorial is in the description. The tutorial webpage has a zip file which contains all the .ino files mentioned in the video.

@chinmoytahbildar3278 5 жыл бұрын

Seriously your videos really amazed me and I always waiting for your videos...God bless YOU...love from India

@guywhoknows 3 жыл бұрын

After that I feel like adding a video on how to host a website on a server and how to make the server in less than ten minutes. But I'd also have to address the firewall and poet forwarding so it was world wide enabled. Good bit of work there!!!

@ochienoeliud5723 3 жыл бұрын

Great work. Very precise and informative tutorial guides. Lots of thanks

@DylanNeo 3 жыл бұрын

Hello Sir, I have been learning arduino lately and I've been lead in my search to this video to try next. I have experience in front and back end web dev (including PHP), so I'm excited to put that knowledge together with Arduino to make something really interesting.

@fernandoarellano7126 4 жыл бұрын

If I had some money I will support you in Patreon man!

@fernandoarellano7126 4 жыл бұрын

Keep the good work!

@ebrahimprice2154 5 жыл бұрын

Informative video. Definitely helpful with an IoT project. Time to brush up on AMP in the LAMP.

@theN10CITYproject Жыл бұрын

this is the needle in the heystack i been searching for! perfect vid!!

@wdujsub7902 4 жыл бұрын

This is a very cool and informative tutorial that is easy to understand and super helpful especially the files in the description. Keep up the good work!

@Kevindarrah 3 жыл бұрын

thanks for the shout out!

@MCsCreations 5 жыл бұрын

Really interesting!!! 😃 Thanks!

@mmdnaderi7183 5 жыл бұрын

Hi, Thanks for sharing, the video has great quality both information and visuals, GREAT

@JessicaRyan7of9 5 жыл бұрын

I really enjoy watching your video's and the stuff you make is really awesome.

@TheDrewker 4 жыл бұрын

Subscribed because finally somebody provided a banana for scale

@yugalsharma13 2 жыл бұрын

Have you tried socket programming (using IPv6)? I presume that would be much faster than using a web app for this task. There's a lot of overhead involved in the management of web requests, right!

@helmi9159 5 жыл бұрын

sir, have you made arduino for control motor 1 phase like fan from internet?

@a332pilot 4 жыл бұрын

Some almost 13 minutes that are very worth it! Thank you so much 🙂

@thijsschrooten9843 4 жыл бұрын

mine doesnt work. Can you maybe send me your code. then i try if your code does work on mine

@a332pilot 4 жыл бұрын

@@thijsschrooten9843 I haven't done it yet, I meant the video is worth the time. But I'll work on it this week and update you.

@Mystical-TEDDY_ Жыл бұрын

@@a332pilot lmao its been 2 years bro u good?

@adelashour3253 5 жыл бұрын

Thank you, great job, but why webpage, we are in time of mobile apps, what about nodemcu it has a wi fi adapter

@PiyushNikam 3 жыл бұрын

Hey, really nice work man. Can you tell me how we can upload multiple Arduino code to a single Arduino? Will the previous uploaded code get deleted?

@18770299 2 жыл бұрын

hi, sorry im using sp01 but still not working "ESP CHECK FAILED " I cant set up the ESP01 trought the arduino mega.i have the USB programer for the sp01.

@warrenmabunga7633 5 жыл бұрын

Very helpful tutorial 😊. Thank you ❤️

@mv9693 3 жыл бұрын

Hello Sir, This is amazing, I have a question, consider this is what I used for Room #1, what should I do for multiple rooms with the same.?

@ivovass195 2 жыл бұрын

Very nice and detailed explanation and example. Thank you

@muhammadihsan10001 4 жыл бұрын

Thank you for your knowledge. It provided a solution to my problem

@mariya5480 3 жыл бұрын

Thank you so much! I am going to make best friends lamp for distance relationships. Your tutorial is the best one I saw on KZfaq! I appreciate your work. Good luck with your channel. Subscribed

@fridolineckerd6135 2 жыл бұрын

thats also why im here, did it work for you?

@mariya5480 2 жыл бұрын

@@fridolineckerd6135 i decided not to do this😂

@vishalparkar 2 жыл бұрын

Thanks a ton ! I don't find enough words to thank you. Your's is the first video Ihave ever seen on this topic that is all - descriptive enough yet in simple but precise language ! Keep up the work. Do you have any similar tutorial for Arduino Uno as well ? What will be the differences, at list ?

@ohh9979 3 жыл бұрын

wow, that was really helpful. Thank You.

@gregjohnson5194 4 жыл бұрын

Excellent, works like a charm now I’ll code it for nodemcu and just a couple sensors and home automations is in the bag! Thanks

@deomarshalsimorangkir6603 3 жыл бұрын

Hi sir, tell me if you understood about the topic, send me your email address

@victorgarnier9902 Жыл бұрын

Hello, were you able to code it for nodeMCU?

@alessandroloschi8865 5 жыл бұрын

Hello, I'm an electronic engineer and I want to do the same thing which you show in this video, using the same hw, but I need to use simulink for my project and I'm having some problems with the esp configuration. Can you give me some suggestions please? Maybe I can help you with other things and share some knowledge

@GeorgeGeorge-xj2bc 4 жыл бұрын

I am intending to work on esp8266 and my question is about how can someone learn it and programming it.But it seems like using ready made programs and libraries looks the only solution to handle with it.The AVR microcontrollers are familiar to me since i write both in C and assembly using the avr studio,but the esp8266 looks somehow like a "black box" unaccessible to a deeper learning.

@S0K0N0MI 4 жыл бұрын

Very cool video! Question; Is there a way for my phone to receive a push alert when something is triggered on the arduino? Email tends to be a little slow, sometimes over 15 minutes. I would like to have it alert me immediately. I want to use this to keep an eye on my fishtank.

@GabDrakee Жыл бұрын

Hello, sorry for the basic question, but how can i uplooad multiple files to the arduino ? I will try to alter your project a bit , to use a server i rent over the internet, from linux, which im configuring, do you think that i will have much complication ? I will try to make the arduino insert the info on my db , and control it on another webpage that i made. This is because i have a college project to make im trying to guide myself by your project in order to do something similar .

@shobhitkumarpatkar5468 2 жыл бұрын

Thanks a lot for such great information but I want to ask why banana was kept at the table ?

@joaocol2978 4 жыл бұрын

Thank you so much! You're the best!

@medilies 4 жыл бұрын

hello so the way esp(client) recieves data orders from the server is by checking the database . doesn't that consume a lot of network ressource since it needs to check periodicly! and isn't there any way to make our servers send data via http to esp ?

@salimshamim3851 4 жыл бұрын

Yes, you can. You have to use mqtt(in place of http requests), that would work in publish subscribe model, so your esp can subscribe to a topic and will get notified when your app will publish on that topic.

@ingcentellas8704 3 жыл бұрын

Hi! Thnks so much! This is a very very very good tutorial for this kind of purpose, I have a question, maybe another user (if there is such a good soul out there jeje) could answer me. Well, there is my question: Is it functional to use a sensor just connecting in a direct way? I mean For example, the DHT11 just connecting VCC GND and DATA or it is better if I use a wheatstone bridge?

@rafaelyahu 4 жыл бұрын

Thanks for the video! Do you have tutorial about connect firebase with lan cable (W5500/Esp32) ?

@kuro68000 5 жыл бұрын

So is this constantly polling or is there some "push" element?

@hamitavcoglu9813 4 жыл бұрын

How can I read some temperature by ntc (5k Ohm) sensor and see it from my phone from anywhere?

@shehabxcode 2 жыл бұрын

i don't have Arduino mega i have Arduino uno so is it possible to give me simple example about how to turn 4 leds on and off also get the leds status if its on or off.i tried your example on arduino uno but i got error message "Not enough memory"

@katsuoofficial8465 3 жыл бұрын

Sir can i use only the Text input and send ID number to database for may IOT attendance syem using only Nodemcu Esp8266 and a router

@mayurthombare3288 5 жыл бұрын

Great video, thanks for all the information..

@valerafox7795 2 жыл бұрын

So, that what I clarified: I can do a database (I know MySQL so it's better for me to use it), that's being handled by Arduino, and it can be accessed and retrieved for a change through any Net protocol (Ethernet, or any another IEEE protocol)? And the DB can be stored and saved on a SD card being connected through ISP? Are all the things I written right?

@navadeep.ganesh 4 жыл бұрын

Thank you for sharing this idea. Can i connect ESP32 Cam and stream video over global ip using same method?

@johntello8904 3 жыл бұрын

this is so cool, thank you for the explanation

@ssukhvant 3 жыл бұрын

Amazing project, I want to ask that if wifi network will not available then ? How Hardware will connect to the internet and access the database?

@gowrob_2777 3 жыл бұрын

why it dont work? I did all the things. but it shows me a page and this "You see this page because your website doesn't have "index.php" or "index.html" file in public_html folder." what should i do now

@kabeatzz2186 4 жыл бұрын

I want to send bme280 and gp2y1010au0f sensor data. Do i need to create variables for these values to send it ?

@marnolotz461 4 жыл бұрын

Great viddeo, thanks you. Quick question thouhg: I have an Arduino UNO, is there a way I can make it run more effectively on the UNO (eg. code I can snip) as I don't have an Arduino MEGA?

@TheKingDnz 3 жыл бұрын

I can't find uno codes too.

@jaribcastillosalcedo2134 4 жыл бұрын

Hello Electronoobs! First of all....great work and THANK YOU SO MUCH for all your videos. I'm having trouble with the PHP files and OOOwebhost....apparently the "code" or something is not working anymore. I would appreciate an update on this topic, maybe? It's worth it. Thanks in advance for all your help!

@rooster443 5 жыл бұрын

You are my hero, never forget!

@johnnyenglish7951 3 жыл бұрын

Great project. I would love use this project with my ESP8266 NODEMCU instead. But there are too many changes to the code needed and I'm a hobbyist with no idea how to start. Would also like to have a non-latching push button operation. Any help would be greatly appreciated.

@victorgarnier9902 Жыл бұрын

hello, i'm currently trying to do the same thing have you ever figured it out?

@kishoreg8835 5 жыл бұрын

is it possible to scan data from a QR code to make a device work with respect to the read data? if so how?

@jacks4321 5 жыл бұрын

You are such a great electronics engineer Love you 😘❤️😘😘

@MasKimochi 3 жыл бұрын

dang.. the next level IoT tutorials.. it's sophisticated !!

@mustaphakabou3827 2 жыл бұрын

Hello Electronoobs, thank you very mutch for this tutorial but I want to ask you about the:(String location_url = "/TX.php?id="; //location of your PHP file on the server.), I didn't understand how define or know my location_url and what you mean by the server ?

@hamza3098 2 жыл бұрын

how can I do the same project but only with reading the analog value of the sensors on my website without the other things shown in the video ?

@Ed19601 4 жыл бұрын

impressive. Wonder though if the ESP could not directly switch the led's, read the sensors

@jhonsebastianboterolemos3046 4 жыл бұрын

El video esta en español ? evisto algunos tuyos y se que hablas español tambien y quisiera saber si esta en español ya que me interesa mucho tu programacion en PHP y otras cositas

@Ammy-bc6bh 3 жыл бұрын

You worked a lot on it. Thanks for share

@b2eingimedali800 3 жыл бұрын

Thank you very mutch for this good tuto but when i compilation i get an error ""exit status 1 request for member 'print' in '1', which is of non-class type 'int' "" i dont how fixed please help me

@arunjallipalli8118 4 жыл бұрын

While dumping program to ardunio whether we should select esp8266 in board manager or atmega 2560

@hamidreza1627 4 жыл бұрын

Thank. What firmware should be uploaded into esp8266 for connecting to arduino??

@nkit7672 4 жыл бұрын

Can work if u use arduino uno??? Secondly can control that system on pc???

@merlinarthur4661 2 жыл бұрын

You saved my day. Thank you so much

@012chris210 4 жыл бұрын

Would I be able to send a web link to select a certain function to run within my Arduino code? I have a led strip with some preset modes and would like to be able to change them via a web link on my phone?

@f1-coldlaps460 2 жыл бұрын

If I only want the boolean variables, can I use an arduino uno?

@Tegatreides 3 жыл бұрын

hi thanks for the video. i have a question. i feel a little unconfortable putting the password of my db on a file. what if someone access the database_connect page and just clicks on show source?

@rottison 4 жыл бұрын

will the project work on a NodeMCU alone or does need the Arduino I have a few extra Nodes but not arduinos

@electronic7979 5 жыл бұрын

Very good project 👍

@alikousali1646 4 жыл бұрын

How I can setup this project with ethernet shield? (send value from mysql to arduino, control relays over ethernet,...)

@brixtongun 3 жыл бұрын

Thanks for the info, very helpful.

@yogeshitaliya473 4 жыл бұрын

How to controlle relay physical switch and web page with real time feedback states (on/off)

@capistor1 5 жыл бұрын

Beautifully done!

@jrdofficial-qb4gu 8 ай бұрын

did u tried it?

@MiguelGarcia-by3nn Жыл бұрын

Mi duda es, ¿se podría hacer todo esto desde Wordpress? es decir prescindir del web server y poder simular un IoT Cloud con Wordpress para ver los gráficos / charts y poder almacenar los datos medidos con los sensores por al menos 90 días. Gracias!!!

@abdelfattahmabchour2891 4 жыл бұрын

I have a project < stock management > and i need to make prototype of this system i ask you if i can make it with arduino+esp+website

@hamzaqasem9031 4 жыл бұрын

in tx.php i get the error: (Undefined variable: update_number in /storage/ssd3/262/13007262/public_html/TX.php on line 70) can any body help me!!!

@abeditani8293 5 жыл бұрын

Something goes wrong when I upload the code . It say that the LCD crestal is not valid . As it missing the LCD display code

@richardbagin9260 5 жыл бұрын

"Full version" of code will also work on arduino UNO or NANO (ATmega328P) if you store all string in program memory (flash) via "F( )" macro. e.g.: Serial.println(F("READY TO SEND")); ( or lcd.print(F(...)); ) Like this I reduce the used RAM to 70% (595 bytes left). Obviously I didn´t test it yet (because I don´t have an ESP Wi-Fi module). And if it will still cause stability problems you can store other variables (because 45% of program memory are still unused) (e.g.: const char SSID_ESP[] = "..."; const char SSID_KEY[] = "..."; ...) via PROGMEM macro. e.g.: PROGMEM const char SSID_ESP[] = "..."; but you will need to write a little bit of code e.g.: for(i=0; i

@Mystical-TEDDY_ Жыл бұрын

YO THANK you bro i been looking for something like this. Ima try it out. But would I have to make these changes by looking through EVERY LINE of code? or is there a faster to make these changes

@robinulrichsen8034 4 ай бұрын

huge help!

@fouzaialaa7962 5 жыл бұрын

Im an embedded systems engineer and i know how much work goes into something like this ......... It would take weeks to do .......thank you for your work

@N1ghtR1der666 2 жыл бұрын

but that built in antenna will seriously limit the range, how far do you get? and is there the same thing but with a antenna socket or solder point to install a higher gain antenna?

@soheibbel5085 5 жыл бұрын

Wow dude, that's amazing

@srrandall88 5 жыл бұрын

Thank you for the awesome video Can you use just an esp8266 node lua board? Also is there a way to log the database to get graphs On the website? I want to track environmental temp, humidity and pool temperature over time.. but access from anywhere

@engineeredessentials6660 5 жыл бұрын

Blynk

@thakessored2007 4 жыл бұрын

Can't it be done by node mcu with the same code?

@christoffernielsen3600 4 жыл бұрын

I only have a nodemcu v3 esp8266. How much code must be changed if I should run the arduino sketch directly on the esp8266 without using the arduino?

@chriswouse7713 5 жыл бұрын

“Easy but difficult project” Me: (wipes spat coffee off screen)

@raagamparmar179 3 жыл бұрын

@KennNRoska 4 жыл бұрын

Can i ask if the Texting is possible to type a text in an app inventor application then going to the other person phone but using the arduino SMS texting using IFTT

@hamzaqasem9031 4 жыл бұрын

in tx.php i get the error (Undefined variable: update_number in /storage/ssd3/262/13007262/public_html/TX.php on line 70) can any body help me!!!

@povnurb 4 жыл бұрын

Podrías hacer el video en español o tienes el tutorial en alguna página?

@abeditani8293 5 жыл бұрын

As it if the ( liquidcrystal_i2c.h is missing or something . Because it not let the compile test code success

@viliuspocius438 3 жыл бұрын

I want to make a temprature sensor that can send notification if it gets over 100°. It would be for a burner that heats tha water. I only need 1 value will arduino pro mini handel that??

@kumeshananth8166 9 ай бұрын

Hello sir can you please tell me what is the app should be downloaded to control the system. I mean that you are using some app on your mobile to control light that is what Iam asking sir

@jeffhousen8968 5 жыл бұрын

Hello my friends, we need to discuss basic website security please remember that allowing anyone that can see the website access to change it can result in....unexpected consequences this becomes even more important when you are controlling mechanical items through the website a basic password will stop the curious, for the determined, more drastic measures are needed do not rely on obscurity, that is useless for security that is all.

@S0K0N0MI 4 жыл бұрын

I'm a little conflicted; I can host the site locally and just go in via VPN tunnel for best security, BUT at that point ill have a server in the house already, so why not skip the arduino and use a raspberry Pi. I wonder if there is a way of making this self contained on the arduino. It can throw up a basic no frills HTML page and read data directly from its own EEPROM, so it might be possible?

@ktaragorn 4 жыл бұрын

Agree, so much easier and more secure to use an authenticated MQTT broker like cloudMQTT, instead of a public http page.

@S0K0N0MI 4 жыл бұрын

@@ktaragorn Thats exactly the route I ended up taking. ;)

@TheRainHarvester 3 жыл бұрын

Can you just create 2 websites : 1) for just the user controls, and 2) another for responding to the user controls? And this is pw protected and responds to user commands? This way, the user only gets access to #1. Not the meat of the innards which controls safety etc? (I'm a noob at internet. Just trying to learn....)

@oskar1504 3 жыл бұрын

@@Official_Baba_yagathanks insane workaround. But u could change your ip and "crack" this method .

@macmillan4487 7 ай бұрын

I have the same setup in my home, which includes lights fans ,water tank level monitor and control drinking water tap, all controlled through a website, now I am trying to backdoor and control some devices like fridge and washing machine which comes with wifi