ESP8266 + Arduino + database - Control Anything from Anywhere
ฝัง
- เผยแพร่เมื่อ 26 เม.ย. 2024
- $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 - วิทยาศาสตร์และเทคโนโลยี
Follow me on FACEBOOK for more: facebook.com/Electronoobs
help me on Patreon: www.patreon.com/ELECTRONOOBS
Te olvidas de el canal hispano :")
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.
@@skyevanderheijden5382 me too the same my error
I also had same error please help me to fix it
@@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.
Thank you for properly explaining things from start to end.. Most TH-camrs 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.
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.
One of the best channels I’ve ever found. Very grateful for your videos. Greetings from USA.
Thanks for sharing! This project really opens a wide range of possibilities.
Hai.. do u have the sample code for this project.???? Can u help me please???
@@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.
Seriously your videos really amazed me and I always waiting for your videos...God bless YOU...love from India
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.
Informative video. Definitely helpful with an IoT project. Time to brush up on AMP in the LAMP.
Great work. Very precise and informative tutorial guides. Lots of thanks
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!!!
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!
If I had some money I will support you in Patreon man!
Keep the good work!
this is the needle in the heystack i been searching for! perfect vid!!
Very helpful tutorial 😊. Thank you ❤️
I really enjoy watching your video's and the stuff you make is really awesome.
Hi, Thanks for sharing, the video has great quality both information and visuals, GREAT
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!
Really interesting!!! 😃
Thanks!
Very nice and detailed explanation and example. Thank you
You are my hero, never forget!
Thank you so much! You're the best!
Thank you for your knowledge.
It provided a solution to my problem
wow, that was really helpful. Thank You.
Some almost 13 minutes that are very worth it! Thank you so much 🙂
mine doesnt work. Can you maybe send me your code. then i try if your code does work on mine
@@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.
@@a332pilot lmao its been 2 years bro u good?
thanks for the shout out!
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
Hi sir, tell me if you understood about the topic, send me your email address
Hello, were you able to code it for nodeMCU?
this is so cool, thank you for the explanation
Subscribed because finally somebody provided a banana for scale
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 ?
You saved my day.
Thank you so much
dang.. the next level IoT tutorials.. it's sophisticated !!
Great video, thanks for all the information..
Thank you so much! I am going to make best friends lamp for distance relationships. Your tutorial is the best one I saw on TH-cam! I appreciate your work. Good luck with your channel. Subscribed
thats also why im here, did it work for you?
@@fridolineckerd6135 i decided not to do this😂
Wow dude, that's amazing
You worked a lot on it. Thanks for share
Beautifully done!
did u tried it?
Thanks for the info, very helpful.
Amazing!!! Thanks for sharing!
Thanks for this beneficial content :)
Thanks for your work!
Excellent tutorial thanks for sharing
Thanks for sharing..... Great job 👍
Excellent. Nicely done
You are awsome thanks for the whole process
This is a great tutorial, especially for the php part. Thanks a lot!
Hi i dont understand about the project, can you help me?
@@deomarshalsimorangkir6603 yes we can help you
Very good project 👍
Nice work man
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
Love the effort 👍
I placed order for one emmediatly I sow this. Thank you.
“Easy but difficult project”
Me: (wipes spat coffee off screen)
xD
so gooooooood
thank you for sharing, nice and useful
Nice video. Learned a lot! Thanks
Hi sir, tell me if you understood about the topic, send me your email address
Can you help me about this project? Send me your email address . I have any question
Thanks !!
It help me a lot!!
Great appreciation for you sir--
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.
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?
Agree, so much easier and more secure to use an authenticated MQTT broker like cloudMQTT, instead of a public http page.
@@ktaragorn Thats exactly the route I ended up taking. ;)
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....)
@@sexyandiknowit45thanks insane workaround. But u could change your ip and "crack" this method .
Thanks nice project 👍🧡
Thank you sir..very helpful
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?
Great job 👍 thanks
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!
Thanks dude.. Your explain so clearly easy to do :)
Bang email nya apa saya ingin bertanya
@@yohanesadicw udah mas cek
Thank you, great job, but why webpage, we are in time of mobile apps, what about nodemcu it has a wi fi adapter
Make more videos on this topic
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.
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.?
nice tutorial! thanks!
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 :)
Same here
did any of you guys figure that out?
Porfa no tardes mucho en sacar este proyecto en español, gracias!
sir, have you made arduino for control motor 1 phase like fan from internet?
Awesome video
thank you so much
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
Sir you are great ❤❤❤
Sir please make arduino based attendance system with database.
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!
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.
Thanks you sir
It helps lot
I'm finding for this for month
💘💘💘💘💗💚💜💓💞💚💚💚💔💟💟👍
Hi sir are you understand about database my sql?
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 ?
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.
Nice video, thanks.
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
thank you very much, you are very good
Hi. Thanks very much. Its working. Just it was problem with my ESP module and also one mistake in your conection diagram
"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
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
huge help!
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.
hello, i'm currently trying to do the same thing have you ever figured it out?
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?
I can't find uno codes too.
Thanks a lot for such great information but I want to ask why banana was kept at the table ?
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 🇦🇺👋🏼
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.
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.
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 .
Good stuff..!!
Thanks for the video! Do you have tutorial about connect firebase with lan cable (W5500/Esp32) ?
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.
Good work
impressive. Wonder though if the ESP could not directly switch the led's, read the sensors
Brilliant!!
Thank you very much. It 's very useful for any person who wants to create a project about ESP8266 and PHP. Great
Hi sir, tell me if you understood about the topic, send me your email address
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
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?
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.
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 ?