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: / 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

[@ELECTRONOOBS]

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

[@user-bi5yj7hs9t]

Te olvidas de el canal hispano :")

[@skyevanderheijden5382]

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]

@@skyevanderheijden5382 me too the same my error

[@arunjallipalli8118]

I also had same error please help me to fix it

[@thijsschrooten9843]

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

[@jonmms9193]

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!

[@Gmtail]

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

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]

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

[@fernandoarellano7126]

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

[@fernandoarellano7126]

Keep the good work!

[@MarceloCutin]

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

[@trashk1483]

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

[@vasuyadav2931]

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

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

[@ebrahimprice2154]

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

[@ochienoeliud5723]

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

[@theN10CITYproject]

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

[@guywhoknows]

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

[@wdujsub7902]

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!

[@DylanNeo]

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.

[@Kevindarrah]

thanks for the shout out!

[@mmdnaderi7183]

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

[@a332pilot]

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

[@thijsschrooten9843]

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

[@a332pilot]

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

[@MCsCreations]

Really interesting!!! 😃 Thanks!

[@JessicaRyan7of9]

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

[@TheDrewker]

Subscribed because finally somebody provided a banana for scale

[@warrenmabunga7633]

Very helpful tutorial 😊. Thank you ❤️

[@muhammadihsan10001]

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

[@vishalparkar]

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 ?

[@ivovass195]

Very nice and detailed explanation and example. Thank you

[@ohh9979]

wow, that was really helpful. Thank You.

[@mariya5480]

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

[@fridolineckerd6135]

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

[@mariya5480]

@@fridolineckerd6135 i decided not to do this😂

[@joaocol2978]

Thank you so much! You're the best!

[@gregjohnson5194]

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]

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?

[@rooster443]

You are my hero, never forget!

[@MasKimochi]

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

[@capistor1]

Beautifully done!

[@jrdofficial-qb4gu]

did u tried it?

[@soheibbel5085]

Wow dude, that's amazing

[@mayurthombare3288]

Great video, thanks for all the information..

[@johntello8904]

this is so cool, thank you for the explanation

[@haddad8956]

so gooooooood

[@Ammy-bc6bh]

You worked a lot on it. Thanks for share

[@muhammadsameer883]

Excellent. Nicely done

[@electronic7979]

Very good project 👍

[@khaleedan]

Nice work man

[@merlinarthur4661]

You saved my day. Thank you so much

[@jacks4321]

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

[@richardbagin9260]

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

[@fouzaialaa7962]

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

[@1_HighDuke]

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

[@deomarshalsimorangkir6603]

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

[@AnonyStudio]

@@deomarshalsimorangkir6603 yes we can help you

[@juhopeltola3993]

I placed order for one emmediatly I sow this. Thank you.

[@brixtongun]

Thanks for the info, very helpful.

[@amilsonmartinsdarosajunior3271]

Amazing!!! Thanks for sharing!

[@PiyushNikam]

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?

[@HerZamanOyun]

Thanks for this beneficial content :)

[@ahmedmohamedhassan9205]

You are awsome thanks for the whole process

[@18770299]

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.

[@abdullahalmaruf5513]

Thanks for sharing..... Great job 👍

[@nicalosmckennon822]

Love the effort 👍

[@jeffhousen8968]

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]

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]

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

[@S0K0N0MI]

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

[@TheRainHarvester]

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]

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

[@Indosmarthome]

thank you for sharing, nice and useful

[@alexanderurezchenko6446]

Thanks for your work!

[@thaliasolutions_media2]

Excellent tutorial thanks for sharing

[@uphaarmobile3584]

Thanks !! It help me a lot!! Great appreciation for you sir--

[@mohammedkhalifa5822]

Awesome video

[@Son0rOo]

Porfa no tardes mucho en sacar este proyecto en español, gracias!

[@richardvanderweerd6596]

Nice video. Learned a lot! Thanks

[@deomarshalsimorangkir6603]

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

[@deomarshalsimorangkir6603]

Can you help me about this project? Send me your email address . I have any question

[@hunkbol6154]

Thanks you sir It helps lot I'm finding for this for month 💘💘💘💘💗💚💜💓💞💚💚💚💔💟💟👍

[@deomarshalsimorangkir6603]

Hi sir are you understand about database my sql?

[@victortorres2080]

Hello friend, excellent project with a lot of potential, something that must be taken into account when using public servers (Free), is privacy and data loss.

[@Engycation]

Very Nice Video

[@sigmata0]

I hope others have mentioned this, but you've implemented no security of communication between the webserver and controller nor the between the webserver and the browser client. On the face of it I would expect anyone to be able to control whatever your website controls. This means if you set it to issue alarms or set equipment on or off, anyone on the planet could do so. You show an example of opening your door latch remotely, and in this setup anyone could do so if they found your free website. Some of this would be ameliorated if you'd implemented SSL between the controller and the website, and between the client of the website and the browser. On top of this I'd be adding an authorization page to access your control page (as a minimum). The 000website service does not provide SSL protection unless you pay for it. In fact it doesn't even supply SSH services. It's unclear if you could implement SSL yourself, using a self signed certificate or one of the free services (letsencrypt.org/ for instance). Really, I'd be more inclined to buy a small SoC device like a Raspberry Ri and setup the web server on it, which means you have complete control over how and what is implemented. This would enable you to have SSL and SSH services, and even a VPN server (like OpenVPN) if you desire. I'd then create a port forward setup on your home router to allow connections to that host from the Internet. All the communications between that host and your Arduino would be inside your local network and not over the Internet (and you could add encryption to that traffic as well if you so desired). If you wanted a specific domain address to resolve where your home public IP address is, you could use one of the Dynamic DNS services that are available for no cost. No-IP, or FreeDNS come to mind but there are a range of others who provide this service. If you use a VPN, then you connect via VPN to your host first, then either login or simply control things via the website as you've demonstrated. You could get a similar effect by using an SSH channel to connect to your host from the outside, if you didn't want to setup up VPN. Security is one of the concerns best implemented from the beginning and not just tacked on later in the process.

[@arsenars1]

Hi. Thanks very much. Its working. Just it was problem with my ESP module and also one mistake in your conection diagram

[@budipriyatno5853]

Thank you sir..very helpful

[@SAHNI-um1jh]

Make more videos on this topic

[@vijaysulakhe5605]

Excellent explanation and video, many THANKS. Hope you make video about STM32 projects with Arduino IDE.

[@yogeshitaliya473]

Nice one bhai

[@baderbouchelga7872]

Great job 👍 thanks

[@pratiksalunke3910]

Sir you are great ❤❤❤ Sir please make arduino based attendance system with database.

[@akthamahmed2171]

Thanks nice project 👍🧡

[@yohanesadicw]

Thanks dude.. Your explain so clearly easy to do :)

[@deomarshalsimorangkir6603]

Bang email nya apa saya ingin bertanya

[@deomarshalsimorangkir6603]

@@yohanesadicw udah mas cek

[@msunrl8577]

nice tutorial! thanks!

[@cursoderobotica]

awesome proyect!!! I think you could make the script using Python! that is way too easy compare with Php ☺️- a lot of libraries for this job! hello from 🇦🇺👋🏼

[@migzleon4047]

Good stuff..!!

[@mrrcomp]

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]

Same here

[@victorgarnier9902]

did any of you guys figure that out?

[@homero9438]

Good work

[@chamluck]

Thank you very much. It 's very useful for any person who wants to create a project about ESP8266 and PHP. Great

[@deomarshalsimorangkir6603]

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

[@paul_vantieghem]

Cayenne IoT on a Raspberry Pi is very powerful and very easy for beginners. No coding resuired. You can add sensors, motors, screens, ... and confiqure them with a wizard. It's crazy

[@jaribcastillosalcedo2134]

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!

[@jhonsebastianboterolemos3046]

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

[@mariashantifernandes4672]

Nice video, thanks.

[@adelashour3253]

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

[@yugalsharma13]

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!

[@ramazaneryildiz07]

thank you very much, you are very good

[@chriswouse7713]

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

[@raagamparmar179]

xD

[@helmi9159]

thank you so much

[@mv9693]

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

[@jparky1972]

Brilliant!!

[@lelandclayton5462]

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]

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.

[@yogeshitaliya473]

Nice one

[@andrejcupac7359]

Hi...awesome video it was very helpful and interesting...but could you make a tutorial on how to control an esp8266 from anywhere around the world with another esp38266 instead of a smartphone.

[@ongkisuhendar]

nice video

[@ingcentellas8704]

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?

[@macmillan4487]

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

[@rverm1000]

wow thats complicated. i got to learn this.

[@ahmedboudi1808]

Thank you for your excellent tutorial and all your videos ... but the diagram at 8:11 has some comments from me ... 1- PIN GPIO0 grounded when upload code, float otherwise 2- divider resistor is inverted ,The medium point must connected to RX(ESP).

[@omarel-azab5223]

i did that and yet the esp doesnt connect to the wifii network, any idea why?

[@helmi9159]

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