ESP8266 + Arduino + database - Control Anything from Anywhere

День тому

$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: / @electronoobsenespanol
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

КОМЕНТАРІ: 580

@ELECTRONOOBS 4 роки тому

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

@user-bi5yj7hs9t 4 роки тому

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 3 роки тому

Thank you for properly explaining things from start to end.. Most UKpostsrs 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.

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

@fernandoarellano7126 4 роки тому

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

@fernandoarellano7126 4 роки тому

Keep the good work!

@MarceloCutin 4 роки тому

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 2 роки тому

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

@guywhoknows 2 роки тому

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!!!

@ebrahimprice2154 4 роки тому

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

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

@josephcagiano3055 2 роки тому

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

@chinmoytahbildar3278 4 роки тому

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

@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!

@ochienoeliud5723 3 роки тому

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

@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!

@theN10CITYproject Рік тому

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

@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?

@mmdnaderi7183 4 роки тому

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

@Kevindarrah 3 роки тому

thanks for the shout out!

@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 ?

@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!

@muhammadihsan10001 4 роки тому

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

@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?

@warrenmabunga7633 4 роки тому

Very helpful tutorial 😊. Thank you ❤️

@fouzaialaa7962 4 роки тому

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

@helmi9159 4 роки тому

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

@JessicaRyan7of9 4 роки тому

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

@jeffhousen8968 4 роки тому

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 3 роки тому

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

@S0K0N0MI 3 роки тому

@@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 роки тому

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

@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 2 роки тому

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?

@adelashour3253 4 роки тому

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

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

@mariya5480 2 роки тому

Thank you so much! I am going to make best friends lamp for distance relationships. Your tutorial is the best one I saw on UKposts! 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😂

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

@ohh9979 3 роки тому

wow, that was really helpful. Thank You.

@rooster443 4 роки тому

You are my hero, never forget!

@juhopeltola3993 4 роки тому

I placed order for one emmediatly I sow this. 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.?

@johntello8904 3 роки тому

this is so cool, thank you for the explanation

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

@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 ?

@ivovass195 2 роки тому

Very nice and detailed explanation and example. Thank you

@joaocol2978 4 роки тому

Thank you so much! You're the best!

@kumeshananth8166 7 місяців тому

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

@MCsCreations 4 роки тому

Really interesting!!! 😃 Thanks!

@hamidreza1627 4 роки тому

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

@rafaelyahu 3 роки тому

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

@shobhitkumarpatkar5468 2 роки тому

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

@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 3 роки тому

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.

@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?

@richardbagin9260 4 роки тому

"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 Місяць тому

huge help!

@merlinarthur4661 2 роки тому

You saved my day. Thank you so much

@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

@capistor1 4 роки тому

Beautifully done!

@jrdofficial-qb4gu 5 місяців тому

did u tried it?

@alessandroloschi8865 4 роки тому

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

@rottison 4 роки тому

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

@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

@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?

@navadeep.ganesh 4 роки тому

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

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

@soheibbel5085 4 роки тому

Wow dude, that's amazing

@jhonsebastianboterolemos3046 3 роки тому

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

@kabeatzz2186 4 роки тому

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

@kishoreg8835 4 роки тому

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

@MrBlacks4 3 місяці тому

Do you have a sloution with an App for android instead of a homepage? The two-way-communication is necessary for my project. I want to send commands and receive data with the app.

@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?

@Ammy-bc6bh 3 роки тому

You worked a lot on it. Thanks for share

@johncojiebizar7806 2 місяці тому

Hello, waht if i only need the switching of light bulbs?? what do i need to edit in the php file? and can arduino uno handle it??

@1_HighDuke 4 роки тому

This is a great tutorial, especially for the php part. Thanks a lot!

@deomarshalsimorangkir6603 2 роки тому

Hi i dont understand about the project, can you help me?

@AnonyStudio 2 роки тому

@@deomarshalsimorangkir6603 yes we can help you

@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"

@marnolotz461 3 роки тому

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.

@arunjallipalli8118 4 роки тому

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

@jr52990 3 роки тому

Is it possible to use If This Then That to have a smart home device (like Alexa) to control the Arduino with this method?

@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!!!

@chriswouse7713 4 роки тому

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

@raagamparmar179 3 роки тому

@alikousali1646 3 роки тому

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

@MasKimochi 2 роки тому

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

@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?

@mayurthombare3288 4 роки тому

Great video, thanks for all the information..

@sokdolla 9 місяців тому

when we turn on off device by switch does on web control update status or not?

@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!

@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??

@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?

@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?

@mrrcomp 3 роки тому

Great Video .. Since the NodeMCU gives both the Connection to the Wifi and has I/O would be nice if you could possibly show how to convert your current project onto NodeMCU.. Just a suggestion :)

@joshuaolakanla3993 2 роки тому

Same here

@victorgarnier9902 Рік тому

did any of you guys figure that out?

@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!!!

@SAHNI-um1jh 4 роки тому

Make more videos on this topic

@user-qh7do3st4f Рік тому

thanks for sharing , i m try to upload everything accordingly but still can`t access to control the LED and when the error show that arduino can`t access to php

@pojintae3262 Рік тому

i dont understand about uploading the file into arduino mega. do i need to upload all or just MAIN_ESP8266 ?

@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?

@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

@brixtongun 2 роки тому

Thanks for the info, very helpful.

@nkit7672 4 роки тому

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

@kuro68000 4 роки тому

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

@khaleedan 4 роки тому

Nice work man

@Mystical-TEDDY_ Рік тому

Hey is there a version of the code for teh arduino that is lighter weight? since I only have an arduino Uno / might not need all of the things on that website. I tried editing it but I keep messing it up

@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 3 роки тому

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

@haddad8956 4 роки тому

so gooooooood

@JR-sq2js 2 роки тому

Also how do I use this witha Wenoos D1 R2 board that has a WiFi module implemented into it?

@hamitavcoglu9813 4 роки тому

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

@lelandclayton5462 4 роки тому

I like this very much however this is how I would do it. Arduino, ESP8266 and a Omega2 or Raspberry Pi as the host. Install LAMP on the Pi or LNMP on the Omega2 since it will be the host. Sign up with a DynamicDNS and setup vLan on the router with some port forwarding and you'll have your own IoT server. Wonder if anyone has made a Arduino to Python Crosscompiler / emulator yet. This way you can just use the Pi or Omega2. Toss in a ZWave Controller and then you could really do some awesome Home Automation with it.

@rdssdr939 4 роки тому

Hello Leland, I have done a project with the method you recommend. The advantage is that response time is much less. However somehow router stopped forwarding to assigned ports. To avoid router problems, one of the outputs is recycling router daily. So currently with DDNS service set on camera dvr, I get the ip address daily. But as port forwarding doesn’t work, I cannot access ardunio. Well, currently I’m 1000 km a way from router and cannot set back the port forwarding. So only way to fix this problem is replacing router with a remote control feature or to have a pc running teamviewer or logmein on it. Both options are costly. So as a result, I will have to update my ardunio that will run over a server database on internet. So if you are able to be near the router, your method is fine as you could fix issue on the place. But if you are a way and have a chance to set router settings once a year, Best to have a control over server database.